/// <summary>
/// 增加设备
/// </summary>
public void Add(Neusoft.HISFC.Models.Terminal.TerminalCarrier terminalCarrier)
{
try
{
//增加一行
this.fpSpread1_Sheet1.Rows.Add(this.fpSpread1_Sheet1.RowCount, 1);
//设置当前行
this.fpSpread1_Sheet1.ActiveRowIndex = this.fpSpread1_Sheet1.RowCount - 1;
int row = this.fpSpread1_Sheet1.ActiveRowIndex;
this.fpSpread1_Sheet1.SetValue(row, ( int )cols.ItemCode, terminalCarrier.CarrierCode, false);
this.fpSpread1_Sheet1.SetValue(row, ( int )cols.ItemName, terminalCarrier.CarrierName, false);
this.fpSpread1_Sheet1.SetValue(row, ( int )cols.UnitFlag, this.GetUnitNameById(terminalCarrier.CarrierType), false);
this.fpSpread1_Sheet1.Cells [row, ( int )cols.BookLmt].Text = "0";
this.fpSpread1_Sheet1.Cells [row, ( int )cols.SpecialBookLmt].Text = "0";
this.fpSpread1_Sheet1.SetValue(row, ( int )cols.TmpFlag, "2", false);
//{5A111831-190D-4187-8076-83E220BC97B2}
this.fpSpread1_Sheet1.SetValue(row, (int)cols.StartTime, "00:00:00", false);
this.fpSpread1_Sheet1.SetValue(row, (int)cols.EndTime, "00:00:00", false);
this.fpSpread1_Sheet1.SetValue(row, (int)cols.Machine, terminalCarrier.CarrierCode, false);
this.fpSpread1.Focus( );
this.fpSpread1_Sheet1.SetActiveCell(this.fpSpread1_Sheet1.ActiveRowIndex, ( int )cols.BookLmt, false);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "提示信息");
return;
}
}
/// <summary>
/// 设置医技设备数据显示
/// </summary>
/// <returns>成功返回1 失败返回-1</returns>
private int SetTerminal(Neusoft.HISFC.Models.Terminal.TerminalCarrier terminal)
{
int rowCount = this.fpSpread1_Sheet1.Rows.Count;
this.fpSpread1_Sheet1.Rows.Add(rowCount, 1);
this.fpSpread1_Sheet1.Cells[rowCount, 0].Text = terminal.Dept.ID;
this.fpSpread1_Sheet1.Cells[rowCount, 1].Text = terminal.CarrierCode;
this.fpSpread1_Sheet1.Cells[rowCount, 2].Text = terminal.CarrierName;
this.fpSpread1_Sheet1.Cells[rowCount, 3].Text = terminal.CarrierType;
this.fpSpread1_Sheet1.Cells[rowCount, 4].Text = terminal.CarrierMemo;
this.fpSpread1_Sheet1.Cells[rowCount, 5].Text = terminal.SpellCode;
this.fpSpread1_Sheet1.Cells[rowCount, 6].Text = terminal.WBCode;
this.fpSpread1_Sheet1.Cells[rowCount, 7].Text = terminal.UserCode;
this.fpSpread1_Sheet1.Cells[rowCount, 8].Text = terminal.Model;
if (terminal.IsDisengaged == "1")
{
this.fpSpread1_Sheet1.Cells[rowCount, 9].Text = "是";
}
else
{
this.fpSpread1_Sheet1.Cells[rowCount, 9].Text = "否";
}
this.fpSpread1_Sheet1.Cells[rowCount, 10].Text = terminal.DisengagedTime.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 11].Text = terminal.DayQuota.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 12].Text = terminal.DoctorQuota.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 13].Text = terminal.SelfQuota.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 14].Text = terminal.WebQuota.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 15].Text = terminal.Building;
this.fpSpread1_Sheet1.Cells[rowCount, 16].Text = terminal.Floor;
this.fpSpread1_Sheet1.Cells[rowCount, 17].Text = terminal.Room;
this.fpSpread1_Sheet1.Cells[rowCount, 18].Text = terminal.SortId.ToString();
if (terminal.IsPrestopTime == "1")
{
this.fpSpread1_Sheet1.Cells[rowCount, 19].Text = "是";
}
else
{
this.fpSpread1_Sheet1.Cells[rowCount, 19].Text = "否";
}
this.fpSpread1_Sheet1.Cells[rowCount, 20].Text = terminal.PreStopTime.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 21].Text = terminal.PreStartTime.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 22].Text = terminal.AvgTurnoverTime.ToString();
this.fpSpread1_Sheet1.Cells[rowCount, 23].Text = terminal.CreateOper;
this.fpSpread1_Sheet1.Cells[rowCount, 24].Text = terminal.CreateTime.ToString();
if (terminal.IsValid == "1")
{
this.fpSpread1_Sheet1.Cells[rowCount, 25].Value = true;
}
else
{
this.fpSpread1_Sheet1.Cells[rowCount, 25].Value = false;
}
this.fpSpread1_Sheet1.Cells[rowCount, 26].Text = terminal.DeviceType;
this.fpSpread1_Sheet1.Rows[rowCount].Tag = terminal;
return(1);
}
/// <summary>
/// 读取医技设备基本信息
/// </summary>
/// <param name="strSQL">查询SQL语句</param>
/// <returns>符合条件的数据集</returns>
private Neusoft.HISFC.Models.Terminal.TerminalCarrier GetComponentDetail2(string strSQL)
{
Neusoft.HISFC.Models.Terminal.TerminalCarrier terminal = null;
try
{
if (this.ExecQuery(strSQL) == -1)
{
return(null);
}
while (this.Reader.Read())
{
terminal = new Neusoft.HISFC.Models.Terminal.TerminalCarrier();
terminal.Dept.ID = this.Reader[0].ToString();
terminal.CarrierCode = this.Reader[1].ToString();
terminal.CarrierName = this.Reader[2].ToString();
terminal.CarrierType = this.Reader[3].ToString();
terminal.CarrierMemo = this.Reader[4].ToString();
terminal.SpellCode = this.Reader[5].ToString();
terminal.WBCode = this.Reader[6].ToString();
terminal.UserCode = this.Reader[7].ToString();
terminal.Model = this.Reader[8].ToString();
terminal.IsDisengaged = this.Reader[9].ToString();
terminal.DisengagedTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[10].ToString());
terminal.DayQuota = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[11].ToString());
terminal.DoctorQuota = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[12].ToString());
terminal.SelfQuota = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[13].ToString());
terminal.WebQuota = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[14].ToString());
terminal.Building = this.Reader[15].ToString();
terminal.Floor = this.Reader[16].ToString();
terminal.Room = this.Reader[17].ToString();
terminal.SortId = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[18].ToString());
terminal.IsPrestopTime = this.Reader[19].ToString();
terminal.PreStopTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[20].ToString());
terminal.PreStartTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[21].ToString());
terminal.AvgTurnoverTime = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.Reader[22].ToString());
terminal.CreateOper = this.Reader[23].ToString();
terminal.CreateTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[24].ToString());
terminal.IsValid = this.Reader[25].ToString();
terminal.DeviceType = this.Reader[26].ToString();
}
return(terminal);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
terminal = null;
return(null);
}
finally
{
this.Reader.Close();
terminal = null;
}
}
/// <summary>
/// 修改数据
/// </summary>
public void Modify()
{
if (this.fpSpread1_Sheet1.Rows.Count == 0)
{
return;
}
this.terminal = this.terminalManager.GetItem(this.fpSpread1_Sheet1.Cells[this.fpSpread1_Sheet1.ActiveRowIndex, 1].Text, dept.ID);
this.ShowMaintenanceForm("Update", this.terminal);
}
private void ShowMaintenanceForm(string inputType, Neusoft.HISFC.Models.Terminal.TerminalCarrier terminal)
{
if (this.MainteranceUC == null || this.MainteranceForm == null)
{
this.InitMaintenanceForm();
}
this.MainteranceUC.InputType = inputType;
this.MainteranceUC.Terminal = terminal;
this.MainteranceForm.ShowDialog();
this.QueryDesign(this.dept.ID);
}
/// <summary>
/// 医技设备保存
/// </summary>
/// <returns>无</returns>
protected virtual int Save()
{
if (this.validate() == -1)
{
return(-1);
}
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
terminalManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
Neusoft.HISFC.Models.Terminal.TerminalCarrier terminal = this.GetItem();
if (inputType.ToString().ToUpper() == "INSERT")
{
if (terminalManager.InsertTerminalCarrier(terminal) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("输入的设备编码不能重复");
return(-1);
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
MessageBox.Show("保存成功");
}
else if (inputType.ToString().ToUpper() == "UPDATE")
{
if (terminalManager.UpdateTerminalCarrier(terminal) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("输入的设备编码不能重复");
return(-1);
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
MessageBox.Show("保存成功");
}
this.Close();
return(1);
}
/// <summary>
/// 根据实体信息获取Insert或Update语句参数数组
/// </summary>
/// <param name="terminalCarrier"></param>
/// <returns></returns>
private string[] GetTerminalCarrierParam(Neusoft.HISFC.Models.Terminal.TerminalCarrier terminalCarrier)
{
string[] strParam = new string[] {
terminalCarrier.Dept.ID,
terminalCarrier.CarrierCode,
terminalCarrier.CarrierName,
terminalCarrier.CarrierType,
terminalCarrier.CarrierMemo,
terminalCarrier.SpellCode,
terminalCarrier.WBCode,
terminalCarrier.UserCode,
terminalCarrier.Model,
terminalCarrier.IsDisengaged,
terminalCarrier.DisengagedTime.ToString(),
terminalCarrier.DayQuota.ToString(),
terminalCarrier.DoctorQuota.ToString(),
terminalCarrier.SelfQuota.ToString(),
terminalCarrier.WebQuota.ToString(),
terminalCarrier.Building,
terminalCarrier.Floor,
terminalCarrier.Room,
terminalCarrier.SortId.ToString(),
terminalCarrier.IsPrestopTime.ToString(),
terminalCarrier.PreStopTime.ToString(),
terminalCarrier.PreStartTime.ToString(),
terminalCarrier.AvgTurnoverTime.ToString(),
terminalCarrier.CreateOper.ToString(),
terminalCarrier.CreateTime.ToString(),
terminalCarrier.IsValid,
terminalCarrier.InvalidOper.ID,
terminalCarrier.InvalidOper.OperTime.ToString(),
terminalCarrier.ValidOper.ID,
terminalCarrier.ValidOper.OperTime.ToString(),
terminalCarrier.DeviceType
};
return(strParam);
}
/// <summary>
/// 插入医技设备信息
/// </summary>
/// <param name="terminalCarrier"></param>
/// <returns></returns>
public int InsertTerminalCarrier(Neusoft.HISFC.Models.Terminal.TerminalCarrier terminalCarrier)
{
string strSQL = "";
if (this.Sql.GetSql("Met.InsertMedTerminalCarrier", ref strSQL) == -1)
{
return(-1);
}
try
{
string[] strParm = this.GetTerminalCarrierParam(terminalCarrier); //取参数列表
strSQL = string.Format(strSQL, strParm); //替换SQL语句中的参数。
}
catch (Exception ex)
{
this.Err = "付数值时候出错！" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.ExecNoQuery(strSQL));
}
/// <summary>
/// 更新医技设备信息
/// </summary>
/// <param name="terminalCarrier"></param>
/// <returns></returns>
public int UpdateTerminalCarrier(Neusoft.HISFC.Models.Terminal.TerminalCarrier terminalCarrier)
{
string strSQL = "";
//更新取药科室信息
if (this.Sql.GetSql("Met.UpdateMedTerminalCarrier", ref strSQL) == -1)
{
this.Err = "找不到SQL语句！Met.UpdateMedTerminalCarrier";
return(-1);
}
try
{
string[] strParm = this.GetTerminalCarrierParam2(terminalCarrier); //取参数列表
strSQL = string.Format(strSQL, strParm); //替换SQL语句中的参数。
}
catch (Exception ex)
{
this.Err = "更新出库记录的SQl参数赋值时出错！Met.UpdateMedTerminalCarrier" + ex.Message;
this.WriteErr();
return(-1);
}
return(this.ExecNoQuery(strSQL));
}
/// <summary>
/// 从控件中取数据，保存在item中
/// </summary>
private Neusoft.HISFC.Models.Terminal.TerminalCarrier GetItem()
{
if (this.terminal == null)
{
terminal = new Neusoft.HISFC.Models.Terminal.TerminalCarrier();
}
this.terminal.Dept.ID = ((Neusoft.HISFC.Models.Base.Employee) this.terminalManager.Operator).Dept.ID;
this.terminal.CarrierCode = this.txtDesignCode.Text;
this.terminal.CarrierName = this.txtName.Text;
this.terminal.CarrierType = this.txtDesignType.Text;
this.terminal.CarrierMemo = this.txtMemo.Text;
this.spell.SpellCode = this.txtSpellCode.Text;
this.spell.WBCode = this.txtWbCode.Text;
this.terminal.UserCode = this.txtUserCode.Text;
this.terminal.Model = this.txtModel.Text;
if (this.chbIsFree.Checked)
{
this.terminal.IsDisengaged = "1";
}
else
{
this.terminal.IsDisengaged = "0";
}
this.terminal.DisengagedTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.dtbFreeDate.Text);
this.terminal.DoctorQuota = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.txtDoc.Text);
this.terminal.SelfQuota = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.txtSelfQuota.Text);
this.terminal.WebQuota = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.txtWebQuota.Text);
this.terminal.DayQuota = this.terminal.DoctorQuota + this.terminal.SelfQuota + this.terminal.WebQuota;
this.terminal.Building = this.txtBuilding.Text;
this.terminal.Floor = this.txtFloor.Text;
this.terminal.Room = this.txtRoom.Text;
this.terminal.SortId = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.txtSortId.Text);
if (this.chbIsprestoptime.Checked)
{
this.terminal.IsPrestopTime = "1";
}
else
{
this.terminal.IsPrestopTime = "0";
}
this.terminal.PreStopTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.dtbPreStopTime.Text);
this.terminal.PreStartTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.dtbPreStartTime.Text);
this.terminal.AvgTurnoverTime = Neusoft.FrameWork.Function.NConvert.ToDecimal(this.txtAvgTime.Text);
this.terminal.CreateOper = this.txtCreateOper.Text;
this.terminal.CreateTime = terminalManager.GetDateTimeFromSysDateTime();
if (this.chbIsValid.Checked)
{
this.terminal.IsValid = "1";
this.terminal.ValidOper.ID = this.terminalManager.Operator.ID;
this.terminal.ValidOper.OperTime = this.terminalManager.GetDateTimeFromSysDateTime();
}
else
{
this.terminal.IsValid = "0";
this.terminal.InvalidOper.ID = this.terminalManager.Operator.ID;
this.terminal.InvalidOper.OperTime = this.terminalManager.GetDateTimeFromSysDateTime();
}
this.terminal.DeviceType = this.cmbDeviceType.Text;
return(terminal);
}
