在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
public bool QueueToRegister(string appointsId, string enrolDoctor) { using (OleDbConnection conn = new OleDbConnection(DBHelper.Instance.ConnectionStr)) { conn.Open(); OleDbCommand cmd = conn.CreateCommand(); try { //插入号源属性 cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PROC_APPOINTTOENROL"; cmd.Parameters.Add("@p_APPOINTSID", OleDbType.VarChar).Value = appointsId; cmd.Parameters.Add("@p_ENROLDOCTOR", OleDbType.VarChar).Value = enrolDoctor; cmd.Parameters.Add("@p_IsUseCallCode", OleDbType.VarChar).Value = PubVariable.Instance.IsUseCallCode; cmd.Parameters.Add("@p_AreaName", OleDbType.VarChar).Value = PubVariable.Instance.AreaName; cmd.Parameters.Add("@p_result", OleDbType.Integer).Value = -1; cmd.Parameters["@p_result"].Direction = ParameterDirection.InputOutput; if (cmd.ExecuteNonQuery() > 0) { var aa = cmd.Parameters["@p_result"].Value.ToString(); return true; } } catch { return false; } finally { if (conn.State != ConnectionState.Closed) conn.Close(); } } return false; }
using (OleDbConnection conn = new OleDbConnection(str)) { OleDbTransaction tran = null; conn.Open(); OleDbCommand cmd = conn.CreateCommand(); tran = conn.BeginTransaction(IsolationLevel.ReadCommitted); cmd.Transaction = tran; try { //插入号源属性 cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PROC_APPOINTTOENROL"; cmd.Parameters.Add("@p_APPOINTSID", OleDbType.VarChar).Value = appointsId; cmd.Parameters.Add("@p_ENROLDOCTOR", OleDbType.VarChar).Value = enrolDoctor; cmd.Parameters.Add("@p_IsUseCallCode", OleDbType.VarChar).Value = isUseCallCode; cmd.Parameters.Add("@p_AreaName", OleDbType.VarChar).Value = areaName; cmd.Parameters.Add("@p_result", OleDbType.Integer).Value = -1; cmd.Parameters["@p_result"].Direction = ParameterDirection.InputOutput; if (cmd.ExecuteNonQuery() > 0) { string result = cmd.Parameters["@p_result"].Value.ToString(); log.WriteLogs("QueueToRegister return p_result:", "返回结果:", result); if (result.Trim() != "1") return false; tran.Commit(); log.WriteLogs("执行QueueToRegister:", "执行成功", ofdepart); return true; } } catch (Exception ex) { tran.Rollback(); log.WriteLogs("执行QueueToRegister:", "异常", ex.ToString()); return false; } finally { if (conn.State != ConnectionState.Closed) conn.Close(); } }
|
请发表评论