private void SelectInputGroup()
{
#region 新增组保存
if (this.trvList.SelectedNode.Tag == null)
{
return;
}
#endregion
this.ClearInfo();
this.pnlGroupInfo.Visible = true;
this.btnSave.Visible = true;
this.btnDelete.Visible = true;
this.btnDelete.Enabled = true;
this.btnNew.Visible = false;
clsInputGroupBaseInfo_VO objBaseInfo = null;
clsInputGroupDetail_VO[] objDetailVOArr = null;
long lngRes = this.objDomain.m_lngGetInputGroupInfo(this.trvList.SelectedNode.Tag.ToString(), out objBaseInfo, out objDetailVOArr);
if (lngRes <= 0)
{
MessageBox.Show(strDBErr, strMessageBoxTitle);
return;
}
this.ShowInputGroupInfo(objBaseInfo, objDetailVOArr);
FillApplyUnitItem(objBaseInfo.m_strAPPLY_UNIT_ID_CHR);
}
private void ShowInputGroupInfo(clsInputGroupBaseInfo_VO objBaseInfo, clsInputGroupDetail_VO[] objDetailVOArr)
{
if (objBaseInfo != null)
{
this.txtASCode.Text = objBaseInfo.m_strASCODE_VCHR;
this.txtGroupID.Text = objBaseInfo.m_strINPUT_GROUP_ID_CHR;
this.txtGroupName.Text = objBaseInfo.m_strINPUT_GROUP_NAME_VCHR;
this.txtPYCode.Text = objBaseInfo.m_strPYCODE_VCHR;
this.txtSummary.Text = objBaseInfo.m_strSUMMARY_VCHR;
this.txtWBCode.Text = objBaseInfo.m_strWBCODE_VCHR;
if (objBaseInfo.m_intINUSEFLAG_NUM == 0)
{
this.chkStopUse.Checked = true;
}
else
{
this.chkStopUse.Checked = false;
}
}
if (objDetailVOArr != null)
{
foreach (clsInputGroupDetail_VO objDetail in objDetailVOArr)
{
ListViewItem lvi = new ListViewItem(objDetail.m_strCHECK_ITEM_ID_CHR);
lvi.SubItems.Add(objDetail.m_strCHECK_ITEM_NAME_CHR);
this.lsvGroupItem.Items.Add(lvi);
}
}
}
public long m_lngUpdateInputGroup(clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc objSvc =
(com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc));
try
{
lngRes = objSvc.m_lngUpdateInputGroup(this.objPrincipal, p_objBaseInfo, p_objResults);
}
catch
{
}
return(lngRes);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckDataFull())
{
MessageBox.Show("请将资料填写完整！", this.strMessageBoxTitle);
return;
}
clsInputGroupBaseInfo_VO objBaseInfo = null;
clsInputGroupDetail_VO[] objDetailVOArr = null;
this.ConstructSaveVO(out objBaseInfo, out objDetailVOArr);
long lngRes = 0;
string strID = null;
if (this.blnNew)
{
lngRes = this.objDomain.m_lngAddNewInputGroup(objBaseInfo, objDetailVOArr, out strID);
}
else
{
lngRes = this.objDomain.m_lngUpdateInputGroup(objBaseInfo, objDetailVOArr);
}
if (lngRes <= 0)
{
MessageBox.Show(this.strDBErr, this.strMessageBoxTitle);
return;
}
if (blnNew)
{
this.txtGroupID.Text = strID;
TreeNode node = new TreeNode();
node.Text = objBaseInfo.m_strINPUT_GROUP_NAME_VCHR;
this.trvList.SelectedNode.Nodes.Add(node);
this.trvList.SelectedNode = node;
node.Tag = strID;
}
if (this.chkStopUse.Checked)
{
this.trvList.SelectedNode.ForeColor = this.notInuseColor;
}
else
{
this.trvList.SelectedNode.ForeColor = this.inuseColor;
}
this.btnDelete.Enabled = true;
}
public long m_lngGetInputGroupInfo(string p_strInputGroupID, out clsInputGroupBaseInfo_VO p_objBaseInfo, out clsInputGroupDetail_VO[] p_objResults)
{
long lngRes = 0;
p_objResults = null;
p_objBaseInfo = null;
com.digitalwave.iCare.middletier.LIS.clsQueryInputGroupSvc objSvc =
(com.digitalwave.iCare.middletier.LIS.clsQueryInputGroupSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.LIS.clsQueryInputGroupSvc));
try
{
lngRes = objSvc.m_lngGetInputGroupInfo(this.objPrincipal, p_strInputGroupID, out p_objBaseInfo, out p_objResults);
}
catch
{
}
return(lngRes);
}
private void ConstructSaveVO(out clsInputGroupBaseInfo_VO objBaseInfo, out clsInputGroupDetail_VO[] objDetailVOArr)
{
objBaseInfo = new clsInputGroupBaseInfo_VO();
if (this.chkStopUse.Checked)
{
objBaseInfo.m_intINUSEFLAG_NUM = 0;
}
else
{
objBaseInfo.m_intINUSEFLAG_NUM = 1;
}
objBaseInfo.m_intSEQUENCE_NUM = 0;
if (this.blnNew)
{
objBaseInfo.m_strAPPLY_UNIT_ID_CHR = this.trvList.SelectedNode.Tag.ToString();
}
else
{
objBaseInfo.m_strAPPLY_UNIT_ID_CHR = this.trvList.SelectedNode.Parent.Tag.ToString();
}
objBaseInfo.m_strASCODE_VCHR = this.txtASCode.Text.Trim();
objBaseInfo.m_strINPUT_GROUP_ID_CHR = this.txtGroupID.Text.Trim();
objBaseInfo.m_strINPUT_GROUP_NAME_VCHR = this.txtGroupName.Text.Trim();
objBaseInfo.m_strPYCODE_VCHR = this.txtPYCode.Text.Trim();
objBaseInfo.m_strSUMMARY_VCHR = this.txtSummary.Text.Trim();
objBaseInfo.m_strWBCODE_VCHR = this.txtWBCode.Text.Trim();
objDetailVOArr = new clsInputGroupDetail_VO[this.lsvGroupItem.Items.Count];
for (int i = 0; i < objDetailVOArr.Length; i++)
{
objDetailVOArr[i] = new clsInputGroupDetail_VO();
objDetailVOArr[i].m_strINPUT_GROUP_ID_CHR = objBaseInfo.m_strINPUT_GROUP_ID_CHR;
objDetailVOArr[i].m_strCHECK_ITEM_ID_CHR = this.lsvGroupItem.Items[i].Text;
objDetailVOArr[i].m_strCHECK_ITEM_NAME_CHR = this.lsvGroupItem.Items[i].SubItems[1].Text;
objDetailVOArr[i].m_intSEQUENCE_NUM = i;
}
}
private void ConstructInputGroupBaseInfoVO(DataRow dtr, clsInputGroupBaseInfo_VO vo)
{
if (dtr != null && vo != null)
{
try
{
vo.m_intINUSEFLAG_NUM = int.Parse(dtr["INUSEFLAG_NUM"].ToString());
}
catch { }
try
{
vo.m_intSEQUENCE_NUM = int.Parse(dtr["SEQUENCE_NUM"].ToString());
}
catch { }
vo.m_strAPPLY_UNIT_ID_CHR = dtr["APPLY_UNIT_ID_CHR"].ToString();
vo.m_strASCODE_VCHR = dtr["ASCODE_VCHR"].ToString();
vo.m_strINPUT_GROUP_ID_CHR = dtr["INPUT_GROUP_ID_CHR"].ToString();
vo.m_strINPUT_GROUP_NAME_VCHR = dtr["INPUT_GROUP_NAME_VCHR"].ToString();
vo.m_strPYCODE_VCHR = dtr["PYCODE_VCHR"].ToString();
vo.m_strSUMMARY_VCHR = dtr["SUMMARY_VCHR"].ToString();
vo.m_strWBCODE_VCHR = dtr["WBCODE_VCHR"].ToString();
}
}
public long m_lngGetInputGroupInfo(System.Security.Principal.IPrincipal p_objPrincipal,
string p_strInputGroupID, out clsInputGroupBaseInfo_VO p_objBaseInfo, out clsInputGroupDetail_VO[] p_objResults)
{
long lngRes = 0;
p_objResults = null;
p_objBaseInfo = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngGetInputGroupInfo");
if (lngRes < 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL1 = @"SELECT *
FROM t_bse_lis_input_group a
WHERE a.input_group_id_chr = ?";
string strSQL2 = @"SELECT a.*, b.check_item_name_vchr
FROM t_bse_lis_input_group_detail a, t_bse_lis_check_item b
WHERE a.check_item_id_chr = b.check_item_id_chr
AND a.input_group_id_chr = ?
ORDER BY a.sequence_num";
DataTable tableResult = new DataTable();
try
{
IDataParameter[] objParamArr = null;
objHRPSvc.CreateDatabaseParameter(1, out objParamArr);
objParamArr[0].Value = p_strInputGroupID;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL1, ref tableResult, objParamArr);
if (lngRes > 0 && tableResult != null && tableResult.Rows.Count > 0)
{
p_objBaseInfo = new clsInputGroupBaseInfo_VO();
ConstructInputGroupBaseInfoVO(tableResult.Rows[0], p_objBaseInfo);
objHRPSvc.CreateDatabaseParameter(1, out objParamArr);
objParamArr[0].Value = p_strInputGroupID;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL2, ref tableResult, objParamArr);
if (lngRes > 0 && tableResult != null)
{
p_objResults = new clsInputGroupDetail_VO[tableResult.Rows.Count];
for (int i = 0; i < p_objResults.Length; i++)
{
p_objResults[i] = new clsInputGroupDetail_VO();
ConstructInputGroupDetailVO(tableResult.Rows[i], p_objResults[i]);
}
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
lngRes = 0;
}
return(lngRes);
}
public long m_lngUpdateInputGroup(System.Security.Principal.IPrincipal p_objPrincipal,
clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults)
{
long lngRes = 0;
if (p_objBaseInfo == null)
{
return(lngRes);
}
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngUpdateInputGroup");
if (lngRes < 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL1 = @"UPDATE t_bse_lis_input_group a
SET apply_unit_id_chr = ?,
input_group_name_vchr = ?,
summary_vchr = ?,
pycode_vchr = ?,
wbcode_vchr = ?,
ascode_vchr = ?,
sequence_num = ?,
inuseflag_num = ?
WHERE input_group_id_chr = ?";
string strSQL2 = @"DELETE FROM t_bse_lis_input_group_detail
WHERE input_group_id_chr = ?";
string strSQL3 = @"INSERT INTO t_bse_lis_input_group_detail
VALUES (?, ?, ?)";
try
{
IDataParameter[] objParamArr1 = null;
objHRPSvc.CreateDatabaseParameter(9, out objParamArr1);
objParamArr1[0].Value = p_objBaseInfo.m_strAPPLY_UNIT_ID_CHR;
objParamArr1[1].Value = p_objBaseInfo.m_strINPUT_GROUP_NAME_VCHR;
objParamArr1[2].Value = p_objBaseInfo.m_strSUMMARY_VCHR;
objParamArr1[3].Value = p_objBaseInfo.m_strPYCODE_VCHR;
objParamArr1[4].Value = p_objBaseInfo.m_strWBCODE_VCHR;
objParamArr1[5].Value = p_objBaseInfo.m_strASCODE_VCHR;
objParamArr1[6].Value = p_objBaseInfo.m_intSEQUENCE_NUM;
objParamArr1[7].Value = p_objBaseInfo.m_intINUSEFLAG_NUM;
objParamArr1[8].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR;
long lngEff = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL1, ref lngEff, objParamArr1);
if (lngRes > 0)
{
IDataParameter[] objParamArr2 = null;
objHRPSvc.CreateDatabaseParameter(1, out objParamArr2);
objParamArr2[0].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR;
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL2, ref lngEff, objParamArr2);
if (lngRes > 0 && p_objResults != null)
{
for (int i = 0; i < p_objResults.Length; i++)
{
IDataParameter[] objParamArr3 = null;
objHRPSvc.CreateDatabaseParameter(3, out objParamArr3);
objParamArr3[0].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR;
objParamArr3[1].Value = p_objResults[i].m_strCHECK_ITEM_ID_CHR;
objParamArr3[2].Value = p_objResults[i].m_intSEQUENCE_NUM;
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL3, ref lngEff, objParamArr3);
if (lngRes <= 0)
{
break;
}
}
}
}
if (lngRes <= 0)
{
System.EnterpriseServices.ContextUtil.SetAbort();
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
lngRes = 0;
}
return(lngRes);
}
public long m_lngAddNewInputGroup(System.Security.Principal.IPrincipal p_objPrincipal,
clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults, out string strID)
{
long lngRes = 0;
strID = null;
if (p_objBaseInfo == null)
{
return(lngRes);
}
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngAddNewInputGroup");
if (lngRes < 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL1 = @"INSERT INTO t_bse_lis_input_group
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
string strSQL2 = @"INSERT INTO t_bse_lis_input_group_detail
VALUES (?, ?, ?)";
try
{
objHRPSvc.m_lngGenerateNewID("t_bse_lis_input_group", "input_group_id_chr", out strID);
if (strID == null || strID.Trim() == "")
{
return(-1);
}
p_objBaseInfo.m_strINPUT_GROUP_ID_CHR = strID;
IDataParameter[] objParamArr1 = null;
objHRPSvc.CreateDatabaseParameter(9, out objParamArr1);
objParamArr1[0].Value = p_objBaseInfo.m_strAPPLY_UNIT_ID_CHR;
objParamArr1[1].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR;
objParamArr1[2].Value = p_objBaseInfo.m_strINPUT_GROUP_NAME_VCHR;
objParamArr1[3].Value = p_objBaseInfo.m_strSUMMARY_VCHR;
objParamArr1[4].Value = p_objBaseInfo.m_strPYCODE_VCHR;
objParamArr1[5].Value = p_objBaseInfo.m_strWBCODE_VCHR;
objParamArr1[6].Value = p_objBaseInfo.m_strASCODE_VCHR;
objParamArr1[7].Value = p_objBaseInfo.m_intSEQUENCE_NUM;
objParamArr1[8].Value = p_objBaseInfo.m_intINUSEFLAG_NUM;
long lngEff = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL1, ref lngEff, objParamArr1);
if (lngRes > 0 && p_objResults != null)
{
for (int i = 0; i < p_objResults.Length; i++)
{
IDataParameter[] objParamArr2 = null;
objHRPSvc.CreateDatabaseParameter(3, out objParamArr2);
objParamArr2[0].Value = strID;
objParamArr2[1].Value = p_objResults[i].m_strCHECK_ITEM_ID_CHR;
objParamArr2[2].Value = p_objResults[i].m_intSEQUENCE_NUM;
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL2, ref lngEff, objParamArr2);
if (lngRes <= 0)
{
break;
}
}
}
if (lngRes <= 0)
{
System.EnterpriseServices.ContextUtil.SetAbort();
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
lngRes = 0;
}
return(lngRes);
}
