/// <summary>
/// farpoint赋值
/// </summary>
/// <param name="arrayList">对象列表</param>
private void SetFpValue(ArrayList arrayList)
{
Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet cabinetObj = new Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet();
this.SpCabinet.RowCount = arrayList.Count;
for (int i = 0; i < arrayList.Count; i++)
{
cabinetObj = arrayList[i] as Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet;
this.SpCabinet.Rows[i].Tag = cabinetObj;
this.SpCabinet.Cells[i, 0].Text = cabinetObj.Store.ID;
this.SpCabinet.Cells[i, 1].Text = cabinetObj.ID;
this.SpCabinet.Cells[i, 2].Text = cabinetObj.GridCount.ToString();
if (cabinetObj.IsValid)
{
this.SpCabinet.Cells[i, 3].Text = "是";
this.SpCabinet.Rows[i].BackColor = Color.White;
}
else
{
this.SpCabinet.Cells[i, 3].Text = "否";
this.SpCabinet.Rows[i].BackColor = Color.HotPink;
}
this.SpCabinet.Cells[i, 4].Text = cabinetObj.OperEnv.Name;
this.SpCabinet.Cells[i, 5].Text = cabinetObj.OperEnv.OperTime.ToString();
this.SpCabinet.Cells[i, 6].Text = cabinetObj.Memo;
}
}
/// <summary>
/// 保存病案柜信息
/// </summary>
/// <returns>-1 失败 1 成功</returns>
protected int Save()
{
Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet cabinet = new Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet();
if (this.Valid() < 0)
{
return(-1);
}
//读取要保存的数据
cabinet.Store.ID = this.txtStoreNO.Text.Trim();
cabinet.ID = this.txtCabinetNO.Text.Trim();
cabinet.GridCount = NConvert.ToInt32(this.txtGridCount.Text.Trim());
cabinet.Memo = this.txtMemo.Text.Trim();
cabinet.IsValid = this.radioValid.Checked;
cabinet.OperEnv.ID = ((Neusoft.HISFC.Models.Base.Employee)Neusoft.FrameWork.Management.Connection.Operator).ID;
cabinet.OperEnv.OperTime = NConvert.ToDateTime(this.txtOperTime.Text);
//保存数据
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
this.cabinetMrg.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
if (this.txtCabinetNO.Enabled) //新增加的记录
{
if (this.cabinetMrg.Insert(cabinet) < 0)
{
MessageBox.Show("保存失败！ " + this.cabinetMrg.Err, "提示");
Neusoft.FrameWork.Management.PublicTrans.RollBack();
return(-1);
}
}
else //对现有数据都修改
{
if (this.cabinetMrg.Update(cabinet) < 0)
{
MessageBox.Show("保存失败！ " + this.cabinetMrg.Err, "提示");
Neusoft.FrameWork.Management.PublicTrans.RollBack();
return(-1);
}
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
return(1);
}
private string[] GetInfo(Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet caseCabinet)
{
string[] str = new string[7];
str[0] = caseCabinet.Store.ID; //病案库编码
str[1] = caseCabinet.ID; //病案柜编码
str[2] = caseCabinet.GridCount.ToString(); //格数
if (caseCabinet.IsValid)
{
str[3] = "1";
}
else
{
str[3] = "0";
}
str[4] = caseCabinet.Memo; //备注
str[5] = caseCabinet.OperEnv.ID; //最后一次操作员工号
str[6] = caseCabinet.OperEnv.OperTime.ToString(); //最后一次操作时间
return(str);
}
/// <summary>
/// 新增病案柜
/// </summary>
/// <param name="caseCabinet">病案柜记录类</param>
/// <returns>出现异常返回－1 成功返回1 插入失败返回 0</returns>
public int Insert(Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet caseCabinet)
{
string strSql = "";
if (this.Sql.GetSql("HealthReacord.Case.CaseCabinet.Insert", ref strSql) == -1)
{
return(-1);
}
try
{
//插入
strSql = string.Format(strSql, GetInfo(caseCabinet));
return(this.ExecNoQuery(strSql));
}
catch (Exception ex)
{
this.Err = ex.Message;
return(-1);
}
}
/// <summary>
/// 更新病案柜记录
/// </summary>
/// <param name="caseCabinet">病案柜记录类</param>
/// <returns>影响的行数-成功;-1-更新失败,0-异常</returns>
public int Update(Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet caseCabinet)
{
string strSql = "";
if (this.Sql.GetSql("HealthReacord.Case.CaseCabinet.Update", ref strSql) == -1)
{
return(-1);
}
try
{
string[] strParm = GetInfo(caseCabinet);
strSql = string.Format(strSql, strParm);
}
catch (Exception ex)
{
this.Err = "赋值时候出错！" + ex.Message;
return(-1);
}
// 执行SQL语句返回
return(this.ExecNoQuery(strSql));
}
/// <summary>
#endregion
#region 查询
/// <summary>
/// 根据病案柜编码查询病案柜的信息
/// </summary>
/// <param name="cabinetCode,cabinetCode">病案柜编码</param>
/// <returns>信息数组元素型: Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet</returns>
public ArrayList Query(string storeCode, string cabinetCode)
{
ArrayList List = null;
string strSql = "";
if (this.Sql.GetSql("HealthReacord.Case.CaseCabinet.Select", ref strSql) == -1)
{
return(null);
}
try
{
//查询
strSql = string.Format(strSql, storeCode, cabinetCode);
this.ExecQuery(strSql);
Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet cabinet = null;
List = new ArrayList();
while (this.Reader.Read())
{
cabinet = new Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet();
cabinet.Store.ID = this.Reader[0].ToString(); //病案库编码
cabinet.ID = this.Reader[1].ToString(); //病案库编码
cabinet.GridCount = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[2].ToString()); // 病案柜格数
//Cabinet.IsValid = this.Reader[3].ToString().Equals("0") ? false : true; //是否有效：1－是、0－否
cabinet.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[3].ToString()); //是否有效：1－是、0－否
cabinet.Memo = this.Reader[4].ToString(); //备注
cabinet.OperEnv.ID = this.Reader[5].ToString(); //最后一次操作员工号
cabinet.OperEnv.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[6].ToString()); //最后一次操作时间
List.Add(cabinet);
cabinet = null;
}
return(List);
}
catch (Exception ex)
{
this.Err = ex.Message;
return(null);
}
}
/// <summary>
/// 病案信息双击调入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void neuSpread1Cabinet_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet caseCabinet = new Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet();
int currRow = this.SpCabinet.ActiveRowIndex;
caseCabinet = this.SpCabinet.Rows[currRow].Tag as Neusoft.HISFC.Models.HealthRecord.Case.CaseCabinet;
if (caseCabinet.IsValid)
{
this.radioValid.Checked = true;
}
else
{
this.radioInvalid.Checked = true;
}
this.txtStoreNO.Text = caseCabinet.Store.ID;
this.txtCabinetNO.Text = caseCabinet.ID;
this.txtCabinetNO.Enabled = false;
this.txtGridCount.Text = caseCabinet.GridCount.ToString();
this.txtMemo.Text = caseCabinet.Memo;
this.txtOper.Text = caseCabinet.OperEnv.Name;
this.txtOperTime.Text = caseCabinet.OperEnv.OperTime.ToString();
}
