public long m_lngUpdate(clsLisWorkGroupVO p_objRecord)
{
long lngRes = 0;
try
{
lngRes = m_objSvc.m_lngUpdate(m_objPrincipal, p_objRecord);
}
catch { lngRes = 0; }
return(lngRes);
}
public long m_lngFind(int p_intID, out clsLisWorkGroupVO p_objRecord)
{
long lngRes = 0;
p_objRecord = null;
try
{
lngRes = m_objSvc.m_lngFind(m_objPrincipal, p_intID, out p_objRecord);
}
catch { lngRes = 0; }
return(lngRes);
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisWorkGroupVO p_objWorkGroup)
{
p_objWorkGroup.m_intSeq = p_dtrSource["WORKGROUP_SEQ_INT"] == System.DBNull.Value ? 0 : int.Parse(p_dtrSource["WORKGROUP_SEQ_INT"].ToString().Trim());
p_objWorkGroup.m_strName = p_dtrSource["WORKGROUP_NAME_VCHR"].ToString().Trim();
p_objWorkGroup.m_strSummary = p_dtrSource["SUMMARY_VCHR"].ToString().Trim();
try
{
p_objWorkGroup.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]);
}
catch
{
}
}
//列表选定项变更
private void m_lsvWorkGroup_Click(object sender, EventArgs e)
{
if (this.m_lsvWorkGroup.FocusedItem == null)
{
return;
}
//变更状态标志
this.m_blnNewWorkGroup = false;
clsLisWorkGroupVO objWorkGroup = (clsLisWorkGroupVO)this.m_lsvWorkGroup.FocusedItem.Tag;
this.m_txtWGName.Text = objWorkGroup.m_strName;
this.m_txtWGSummary.Text = objWorkGroup.m_strSummary;
}
//恢复
private void m_cmdWGCancelDelete_Click(object sender, EventArgs e)
{
if (this.m_lsvWorkGroup.FocusedItem == null ||
this.m_lsvWorkGroup.FocusedItem.Tag == null)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
m_cmdWGCancelDelete.Enabled = false;
clsLisWorkGroupVO objGroup = (clsLisWorkGroupVO)this.m_lsvWorkGroup.FocusedItem.Tag;
clsLisWorkGroupVO objCopy = new clsLisWorkGroupVO();
objGroup.m_mthCopyTo(objCopy);//拷贝到另一个对象
objCopy.m_enmStatus = enmQCStatus.Natrural;
//更新到数据库
long lngRes = clsTmdWorkGroupSmp.s_object.m_lngUpdate(objCopy);
if (lngRes > 0)
{//更新成功
objGroup.m_enmStatus = enmQCStatus.Natrural;
int intIdx = this.m_lsvWorkGroup.FocusedItem.Index;
this.m_lsvWorkGroup.FocusedItem.Remove();
//设置新的具有焦点的 ListView 项
if (intIdx < this.m_lsvWorkGroup.Items.Count)
{
this.m_lsvWorkGroup.Items[intIdx].Selected = true;
this.m_lsvWorkGroup.Items[intIdx].Focused = true;
this.m_lsvWorkGroup_Click(null, null);
}
else if (intIdx - 1 >= 0)
{
this.m_lsvWorkGroup.Items[intIdx - 1].Selected = true;
this.m_lsvWorkGroup.Items[intIdx - 1].Focused = true;
this.m_lsvWorkGroup_Click(null, null);
}
}
else
{//更新失败
clsCommonDialog.m_mthShowDBError();
}
m_cmdWGCancelDelete.Enabled = true;
Cursor.Current = Cursors.Default;
}
public long m_lngInsert(clsLisWorkGroupVO p_objRecord)
{
int intID = -1;
long lngRes = 0;
try
{
lngRes = m_objSvc.m_lngInsert(m_objPrincipal, p_objRecord, out intID);
}
catch { lngRes = 0; }
if (lngRes > 0)
{
p_objRecord.m_intSeq = intID;
}
return(lngRes);
}
//加载数据和填充列表
private void m_mthLoadWorkGroup()
{
Cursor.Current = Cursors.WaitCursor;
//加载数据
clsLisWorkGroupVO[] objGroupArr = null;
clsTmdWorkGroupSmp.s_object.m_lngFind(out objGroupArr);
if (objGroupArr == null)
{
objGroupArr = new clsLisWorkGroupVO[0];
}
m_lsvWorkGroup.Tag = objGroupArr;
//填充列表
m_mthShowWorkGroupList(objGroupArr, this.m_chkWGShowDeleted.Checked);
Cursor.Current = Cursors.Default;
}
public long m_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisWorkGroupVO p_objWorkGroup)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngUpdate");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"UPDATE T_BSE_LIS_WORKGROUP SET
WORKGROUP_NAME_VCHR=?,
SUMMARY_VCHR=?,
STATUS_INT=?
WHERE WORKGROUP_SEQ_INT=?
" ;
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_objWorkGroup.m_strName,
p_objWorkGroup.m_strSummary,
(int)p_objWorkGroup.m_enmStatus,
p_objWorkGroup.m_intSeq
);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisWorkGroupVO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
string strSQL = @"SELECT * FROM T_BSE_LIS_WORKGROUP ";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
DataTable dtbResult = null;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
objHRPSvc.Dispose();
if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0)
{
p_objResultArr = new clsLisWorkGroupVO[dtbResult.Rows.Count];
for (int i = 0; i < p_objResultArr.Length; i++)
{
p_objResultArr[i] = new clsLisWorkGroupVO();
this.ConstructVO(dtbResult.Rows[i], ref p_objResultArr[i]);
}
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisWorkGroupVO p_objWorkGroup)
{
long lngRes = 0;
p_objWorkGroup = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"SELECT * FROM T_BSE_LIS_WORKGROUP WHERE WORKGROUP_SEQ_INT = ?";
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_intSeq);
DataTable dtbResult = null;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objODPArr);
objHRPSvc.Dispose();
if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0)
{
p_objWorkGroup = new clsLisWorkGroupVO();
this.ConstructVO(dtbResult.Rows[0], ref p_objWorkGroup);
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
private void m_mthLoadData()
{
//加入空项
clsLisWorkGroupVO obj = new clsLisWorkGroupVO();
obj.m_strName = string.Empty;
obj.m_intSeq = DBAssist.NullInt;
obj.m_enmStatus = enmQCStatus.Natrural;
this.Items.Add(obj);
//加载数据
clsLisWorkGroupVO[] objGroupArr = null;
long lngRes = clsTmdWorkGroupSmp.s_object.m_lngFind(out objGroupArr);
if (lngRes > 0 && objGroupArr != null)
{
foreach (clsLisWorkGroupVO objGroup in objGroupArr)
{
if (objGroup.m_enmStatus == enmQCStatus.Natrural)
{
this.Items.Add(objGroup);
}
}
}
}
//保存
private void m_cmdWGSave_Click(object sender, EventArgs e)
{
if (this.m_lsvWorkGroup.FocusedItem == null &&
!this.m_blnNewWorkGroup)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
this.m_cmdWGSave.Enabled = false;
if (this.m_blnNewWorkGroup)
{//新增的保存
clsLisWorkGroupVO objGroup = new clsLisWorkGroupVO();
objGroup.m_enmStatus = enmQCStatus.Natrural;
objGroup.m_strName = this.m_txtWGName.Text.Trim();
objGroup.m_strSummary = this.m_txtWGSummary.Text;
long lngRes = clsTmdWorkGroupSmp.s_object.m_lngInsert(objGroup);
if (lngRes > 0)
{//成功
//更新状态标志
this.m_blnNewWorkGroup = false;
//加入到集合
clsLisWorkGroupVO[] objGroupArr = (clsLisWorkGroupVO[])this.m_lsvWorkGroup.Tag;
clsLisWorkGroupVO[] objGroupNewArr = new clsLisWorkGroupVO[objGroupArr.Length + 1];
objGroupArr.CopyTo(objGroupNewArr, 0);
objGroupNewArr[objGroupNewArr.Length - 1] = objGroup;
this.m_lsvWorkGroup.Tag = objGroupNewArr;
//添加新项
ListViewItem item = new ListViewItem(objGroup.m_strName);
item.SubItems.Add(objGroup.m_strSummary);
item.Tag = objGroup;
this.m_lsvWorkGroup.Items.Add(item);
item.Selected = true;
item.Focused = true;
this.m_lsvWorkGroup_Click(null, null);
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
}
else
{//修改的保存
clsLisWorkGroupVO objWorkGroup = (clsLisWorkGroupVO)this.m_lsvWorkGroup.FocusedItem.Tag;
clsLisWorkGroupVO objGroup = new clsLisWorkGroupVO();
objWorkGroup.m_mthCopyTo(objGroup);
objGroup.m_strName = this.m_txtWGName.Text.Trim();
objGroup.m_strSummary = this.m_txtWGSummary.Text;
long lngRes = clsTmdWorkGroupSmp.s_object.m_lngUpdate(objGroup);
if (lngRes > 0)
{//成功
objGroup.m_mthCopyTo(objWorkGroup);
this.m_lsvWorkGroup.FocusedItem.Text = objWorkGroup.m_strName;
this.m_lsvWorkGroup.FocusedItem.SubItems[1].Text = objWorkGroup.m_strSummary;
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
}
this.m_cmdWGSave.Enabled = true;
Cursor.Current = Cursors.Default;
}
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisWorkGroupVO p_objWorkGroup, out int p_intSeq)
{
long lngRes = 0;
p_intSeq = -1;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngInsert");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"
INSERT INTO T_BSE_LIS_WORKGROUP (
WORKGROUP_SEQ_INT,
WORKGROUP_NAME_VCHR,
SUMMARY_VCHR,
STATUS_INT
)
VALUES
( ?, ? ,? , ?)";
try
{
lngRes = 0;
lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_WORKGROUP", "WORKGROUP_SEQ_INT", out p_intSeq);
if (lngRes <= 0)
{
return(-1);
}
lngRes = 0;
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_intSeq,
p_objWorkGroup.m_strName,
p_objWorkGroup.m_strSummary,
(int)p_objWorkGroup.m_enmStatus
);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
if (lngRes > 0)
{
p_objWorkGroup.m_intSeq = p_intSeq;//给VO赋值ID
}
else
{
p_intSeq = -1;
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
