/// <summary> /// 修改内镜 /// </summary> /// <param name="endoscopeInfo">内镜对象</param> /// <returns> /// 修改结果 /// </returns> public bool ModifyEndoscope(EndoscopeInfo endoscopeInfo) { return Global.DBProcess.ModifyEndoscope(Global.EndoscopeInfo, endoscopeInfo); }
/// <summary> /// Loads the endoscopes. /// </summary> /// <returns> /// 内镜信息 /// </returns> public List<EndoscopeInfo> LoadEndoscopes() { var selectsql = "select * from endoscopeInfo"; List<EndoscopeInfo> endoscopes = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(Global.ConnStr, CommandType.Text, selectsql)) { if (!reader.HasRows) { return endoscopes; } endoscopes = new List<EndoscopeInfo>(); while (reader.Read()) { var endoscopeInfo = new EndoscopeInfo { EndoscopeSn = reader.SafeRead<string>("endoscopeSn"), Id = reader.SafeRead<int>("id"), EndoscopeSim = reader.SafeRead<string>("endoscopeSim"), EndoscopeSeal = reader.SafeRead<string>("endoscopeSeal"), EndoscopeServYear = reader.SafeRead<int>("endoscopeServYear"), EndoscopeType = reader.SafeRead<string>("endoscopeType"), EndoscopeName = reader.SafeRead<string>("endoscopeName"), EndoscopeUseTime = reader.SafeRead<DateTime>("endoscopeUseTime"), Remark = reader.SafeRead<string>("remark") }; endoscopes.Add(endoscopeInfo); } } return endoscopes; }
/// <summary> /// 插入内镜信息 /// </summary> /// <param name="tableName">表名</param> /// <param name="endoscopeInfo">内镜信息</param> /// <returns>是否成功</returns> public bool ModifyEndoscope(string tableName, EndoscopeInfo endoscopeInfo) { int result = 0; var selectsql = string.Format("select id from endoscopeInfo where endoscopeSn='{0}'", endoscopeInfo.EndoscopeSn); object temp = SqlHelper.ExecuteScalar(Global.ConnStr, CommandType.Text, selectsql); SqlParameter[] paras = { this.GetSqlParameter("endoSn",endoscopeInfo.EndoscopeSn,DbType.String), this.GetSqlParameter("endoSim",endoscopeInfo.EndoscopeSim,DbType.String), this.GetSqlParameter("endoType",endoscopeInfo.EndoscopeType,DbType.String), this.GetSqlParameter("endoTypeName",endoscopeInfo.EndoscopeName,DbType.String), this.GetSqlParameter("endoSerYear",endoscopeInfo.EndoscopeServYear,DbType.Int32), this.GetSqlParameter("endoUseTime",endoscopeInfo.EndoscopeUseTime,DbType.DateTime), this.GetSqlParameter("endoSeal",endoscopeInfo.EndoscopeSeal,DbType.String), this.GetSqlParameter("remark",endoscopeInfo.Remark,DbType.String) }; using (var conn = new SqlConnection(Global.ConnStr)) { conn.Open(); if (temp == null) { var tran = conn.BeginTransaction(); var insertsql = @"insert into endoscopeInfo ( endoscopeSn,endoscopeSim,endoscopeType,endoscopeName,endoscopeServYear, endoscopeUseTime,endoscopeSeal,remark) values( @endoSn,@endoSim,@endoType,@endoTypeName,@endoSerYear,@endoUseTime,@endoSeal,@remark)"; try { result = SqlHelper.ExecuteNonQuery(tran, CommandType.Text, insertsql, paras); } catch (Exception ex) { Global.Log("插入endoscopeInfo数据失败", ex); tran.Rollback(); throw new Exception("插入endoscopeInfo数据失败"); } if (result <= 0) { tran.Rollback(); } insertsql = string.Format("insert into endoscopeTemp (endoscopeSn,endoscopeSim,cleanType) values('{0}','{1}','{2}')", endoscopeInfo.EndoscopeSn, endoscopeInfo.EndoscopeSim, 1); try { result = SqlHelper.ExecuteNonQuery(tran, CommandType.Text, insertsql); } catch (Exception ex) { Global.Log("插入endoscopeTemp数据失败", ex); tran.Rollback(); throw new Exception("插入endoscopeInfo数据失败"); } if (result > 0) { tran.Commit(); return true; } tran.Rollback(); } else { var updatesql = string.Format(@"update endoscopeInfo set endoscopeSn=@endoSn,endoscopeSim=@endoSim,endoscopeType=@endoType, endoscopeName=@endoTypeName,endoscopeServYear=@endoSerYear,endoscopeUseTime=@endoUseTime, endoscopeSeal=@endoSeal,remark=@remark where endoscopeSn='{0}'", endoscopeInfo.EndoscopeSn); try { result = SqlHelper.ExecuteNonQuery(Global.ConnStr, CommandType.Text, updatesql, paras); } catch (Exception ex) { Global.Log("更新endoscopeInfo信息失败", ex); throw new Exception("更新endoscopeInfo信息失败"); } if (result > 0) { return true; } return false; } } return false; }
/// <summary> /// 根据SIM获取相关信息 /// </summary> /// <param name="endoscopeSim">内镜卡号</param> /// <param name="tablename">表名</param> /// <returns> /// 内镜详细信息 /// </returns> /// <exception cref="System.Exception">SqlException</exception> public EndoscopeInfo GetEndoscopeMsgBySIM(string endoscopeSim, string tablename) { EndoscopeInfo endoscope = null; var selectsql = "select * from EndoscopeInfo where endoscopeSim=@endoscope"; SqlParameter[] paras = { this.GetSqlParameter("@endoscope", endoscopeSim, DbType.String) }; try { // reader读取内镜卡号 using (var reader = SqlHelper.ExecuteReader(Global.ConnStr, CommandType.Text, selectsql, paras)) { if (reader == null || !reader.HasRows) { return endoscope; } while (reader.Read()) { endoscope = new EndoscopeInfo { EndoscopeSn = reader.SafeRead<string>("endoscopeSn") }; } } } catch (Exception ex) { Global.Log("根据Sim卡号查找内镜出错", ex); throw new Exception("根据Sim卡号查找内镜出错"); } return endoscope; }
/// <summary> /// 保存内镜信息 /// </summary> /// <param name="endoscopeInfo">内镜编号</param> /// <returns> /// 是否保存成功 /// </returns> public bool SaveEndoscope(EndoscopeInfo endoscopeInfo) { bool result = false; try { if (GSetting.DataServ.ModifyEndoscope(endoscopeInfo)) { result = true; } } catch (Exception ex) { Global.Log(ex); } return result; }
/// <summary> /// Handles the Click event of the btnSaveEndo control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void BtnSaveEndo_Click(object sender, EventArgs e) { // 验证输入内容 if (this.Verify()) { var endoscopeInfo = new EndoscopeInfo { EndoscopeSn = txtEndoscopeSn.Text, EndoscopeSim = txtEndoscopeSIM.Text, EndoscopeSeal = txtEndoscopeSeal.Text, EndoscopeServYear = (int)cmbEndoYear.Value, EndoscopeType = cmbEndoscopeType.Text, EndoscopeName = txtEndoscopeTypeName.Text, EndoscopeUseTime = DateTime.Now, Remark = txtRemark.Text.Trim() }; // 保存内镜信息 if (GSetting.DataServBusi.SaveEndoscope(endoscopeInfo)) { GSetting.WashObj.ShowStatusTips(this.txtEndoscopeSn.Text + "保存成功!", Color.Green); this.EndoscopeManager_Load(null, null); } else { GSetting.WashObj.ShowStatusTips(this.txtEndoscopeSn.Text + "保存失败!", Color.Red); } } }
/// <summary> /// 修改内镜 /// </summary> /// <param name="tableName">表名</param> /// <param name="endoscopeInfo">内镜对象</param> /// <returns> /// 修改结果 /// </returns> public bool ModifyEndoscope(string tableName, EndoscopeInfo endoscopeInfo) { if (string.IsNullOrEmpty(tableName) || endoscopeInfo == null) { return false; } bool result = false; try { result = dataObject.ModifyEndoscope(tableName, endoscopeInfo); } catch (Exception) { return false; } return result; }
/// <summary> /// 根据SIM卡号获取User或者Endoscope的信息 /// </summary> /// <param name="sim">磁卡号</param> /// <returns> /// 用户/内镜信息 /// </returns> public string[] GetUserEndoscopeMsg(string sim) { if (string.IsNullOrEmpty(sim)) { return new string[0]; } var tempStr = new string[3]; var en = new EndoscopeInfo(); try { en = dataObject.GetEndoscopeMsgBySIM(sim, Global.EndoscopeInfo); } catch (Exception) { return new string[0]; } if (en != null) { tempStr[0] = "endoscope"; tempStr[1] = en.EndoscopeSn; } else { var u = new UserInfo(); try { u = dataObject.GetUserInfo(sim, Global.UserInfo); } catch (Exception) { return new string[0]; } if (u.UserName.Length > 0) { tempStr[0] = "user"; tempStr[1] = u.UserSn; tempStr[2] = u.UserName; } else { tempStr[0] = "no"; } } return tempStr; }