public long m_lngSaveOutPatientDefaultAddItem(ArrayList RecordsArr, int Flag, string PayTypeID)
{
long lngRes = 0, lngAffects = 0;
//执行SQL
string SQL = "";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
if (PayTypeID != "")
{
SQL = @"delete from t_aid_outpatientdefaultadditem where paytypeid_chr = ?";
objHRPSvc.CreateDatabaseParameter(1, out ParamArr);
ParamArr[0].Value = PayTypeID;
lngRes = objHRPSvc.lngExecuteParameterSQL(SQL, ref lngAffects, ParamArr);
if (Flag == -1)
{
return(lngRes);
}
}
for (int i = 0; i < RecordsArr.Count; i++)
{
clsOutPatientDefaultAddItem_VO DefaultAddItem_VO = RecordsArr[i] as clsOutPatientDefaultAddItem_VO;
SQL = @"insert into t_aid_outpatientdefaultadditem (paytypeid_chr, itemid_chr, qty_dec, regflag_int, recflag_int, dutyname_vchr, begintime_chr, endtime_chr,deptid_chr)
values (?, ?, ?, ?, ?, ?, ?, ?,?)";
objHRPSvc.CreateDatabaseParameter(9, out ParamArr);
ParamArr[0].Value = DefaultAddItem_VO.PayTypeID;
ParamArr[1].Value = DefaultAddItem_VO.ItemID;
ParamArr[2].Value = DefaultAddItem_VO.Qty;
ParamArr[3].Value = DefaultAddItem_VO.RegFlag;
ParamArr[4].Value = DefaultAddItem_VO.RecFlag;
ParamArr[5].Value = DefaultAddItem_VO.DutyID;
ParamArr[6].Value = DefaultAddItem_VO.BeginTime;
ParamArr[7].Value = DefaultAddItem_VO.EndTime;
ParamArr[8].Value = DefaultAddItem_VO.DeptID;
lngRes = objHRPSvc.lngExecuteParameterSQL(SQL, ref lngAffects, ParamArr);
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
public bool m_blnSave()
{
bool ret = false;
if (this.m_objViewer.dtgItem.Rows.Count == 0)
{
return(ret);
}
if (this.m_objViewer.PayTypeID.Trim() == "")
{
return(ret);
}
RecordID = this.m_objViewer.btnSave.Tag.ToString().Trim();
if (RecordID == "" && this.m_objViewer.dtgItem.Rows.Count == 0)
{
return(ret);
}
ArrayList RecordsArr = new ArrayList();
int SaveFlag = 0;
if (RecordID != "" && this.m_objViewer.dtgItem.Rows.Count == 0)
{
SaveFlag = -1;
}
else
{
string RegFlag = "";
string RecFlag = "";
string DutyName = "";
string TimeScpe = "";
DataRow dr;
for (int i = 0; i < this.m_objViewer.dtgItem.Rows.Count; i++)
{
dr = this.m_objViewer.dtgItem.Rows[i].Tag as DataRow;
clsOutPatientDefaultAddItem_VO DefaultAddItem_VO = new clsOutPatientDefaultAddItem_VO();
DefaultAddItem_VO.Sid = RecordID;
DefaultAddItem_VO.PayTypeID = this.m_objViewer.PayTypeID;
DefaultAddItem_VO.ItemID = dr["itemid_chr"].ToString();
DefaultAddItem_VO.Qty = clsPublic.ConvertObjToDecimal(this.m_objViewer.dtgItem.Rows[i].Cells["sl"].Value);
RegFlag = this.m_objViewer.dtgItem.Rows[i].Cells["ghzt"].Value.ToString().Trim();
RecFlag = this.m_objViewer.dtgItem.Rows[i].Cells["cflx"].Value.ToString().Trim();
DutyName = this.m_objViewer.dtgItem.Rows[i].Cells["yszc"].Value.ToString().Trim();
TimeScpe = this.m_objViewer.dtgItem.Rows[i].Cells["sjfw"].Value.ToString().Trim();
if (RegFlag == "全部")
{
RegFlag = "0";
}
else if (RegFlag == "已挂号")
{
RegFlag = "1";
}
else if (RegFlag == "未挂号")
{
RegFlag = "2";
}
DefaultAddItem_VO.RegFlag = int.Parse(RegFlag);
if (RecFlag == "全部")
{
RecFlag = "0";
}
else if (RecFlag == "正方")
{
RecFlag = "1";
}
else if (RecFlag == "副方")
{
RecFlag = "2";
}
DefaultAddItem_VO.RecFlag = int.Parse(RecFlag);
if (DutyName.Trim() == "")
{
MessageBox.Show("职称不能为空。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
DefaultAddItem_VO.DutyID = DutyName;
DefaultAddItem_VO.BeginTime = TimeScpe.Substring(0, 5);
DefaultAddItem_VO.EndTime = TimeScpe.Substring(6, 5);
DefaultAddItem_VO.DeptID = this.m_objViewer.dtgItem.Rows[i].Cells["ksid"].Value.ToString().Trim();
RecordsArr.Add(DefaultAddItem_VO);
}
}
long l = this.objSvc.m_lngSaveOutPatientDefaultAddItem(RecordsArr, SaveFlag, RecordID);
if (l > 0)
{
MessageBox.Show("数据保存成功！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.m_objViewer.btnSave.Tag = this.m_objViewer.PayTypeID;
ret = true;
}
else
{
MessageBox.Show("数据保存失败。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(ret);
}
