/// <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;
}
