public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckMethodVO p_objCheckMethod, 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.clsTmdCheckMethodSvc", "m_lngInsert");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"INSERT INTO T_BSE_LIS_CHECKMETHOD(
METHOD_SEQ_INT,
CHECKMETHOD_NAME_VCHR,
PYCODE_VCHR,
WBCODE_VCHR
)
VALUES
( ?, ? ,? ,?)";
try
{
lngRes = 0;
lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_CHECKMETHOD", "METHOD_SEQ_INT", out p_intSeq);
if (lngRes <= 0)
{
return(-1);
}
lngRes = 0;
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_intSeq,
p_objCheckMethod.m_strName,
p_objCheckMethod.m_strPycode,
p_objCheckMethod.m_strWbcode
);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
if (lngRes > 0)
{
p_objCheckMethod.m_intSeq = p_intSeq;//给VO赋值ID
}
else
{
p_intSeq = -1;
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisCheckMethodVO p_objCheckMethod)
{
p_objCheckMethod.m_intSeq = DBAssist.ToInt32(p_dtrSource["METHOD_SEQ_INT"]);
p_objCheckMethod.m_strName = p_dtrSource["CHECKMETHOD_NAME_VCHR"].ToString();
p_objCheckMethod.m_strPycode = p_dtrSource["PYCODE_VCHR"].ToString();
p_objCheckMethod.m_strWbcode = p_dtrSource["WBCODE_VCHR"].ToString();
}
public long m_lngUpdate(clsLisCheckMethodVO 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 clsLisCheckMethodVO 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);
}
private void m_lsvCheckMethod_Click(object sender, EventArgs e)
{
if (this.m_lsvCheckMethod.FocusedItem == null)
{
return;
}
//变更状态标志
this.m_blnNewCheckMethod = false;
clsLisCheckMethodVO objCheckMethod = (clsLisCheckMethodVO)this.m_lsvCheckMethod.FocusedItem.Tag;
this.m_txtCMName.Text = objCheckMethod.m_strName;
this.m_txtCMPYCode.Text = objCheckMethod.m_strPycode;
this.m_txtCMWBCode.Text = objCheckMethod.m_strWbcode;
}
public long m_lngInsert(clsLisCheckMethodVO 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);
}
public void m_mthLoadData()
{
//加入空项
clsLisCheckMethodVO obj = new clsLisCheckMethodVO();
obj.m_strName = string.Empty;
obj.m_intSeq = DBAssist.NullInt;
this.Items.Add(obj);
//加载数据
clsLisCheckMethodVO[] objCheckMethodArr = null;
long lngRes = clsTmdCheckMethodSmp.s_object.m_lngFind(out objCheckMethodArr);
if (lngRes > 0 && objCheckMethodArr != null)
{
this.Items.AddRange(objCheckMethodArr);
}
}
private void m_mthLoadCheckMethod()
{
Cursor.Current = Cursors.WaitCursor;
//加载数据
clsLisCheckMethodVO[] objMethodsArr = null;
clsTmdCheckMethodSmp.s_object.m_lngFind(out objMethodsArr);
if (objMethodsArr == null)
{
objMethodsArr = new clsLisCheckMethodVO[0];
}
m_lsvCheckMethod.Tag = objMethodsArr;
//填充列表
m_mthShowCheckMethodList(objMethodsArr);
Cursor.Current = Cursors.Default;
}
private void m_cmdCMDelete_Click(object sender, EventArgs e)
{
if (this.m_lsvCheckMethod.FocusedItem == null)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
this.m_cmdCMDelete.Enabled = false;
clsLisCheckMethodVO objMethod = (clsLisCheckMethodVO)this.m_lsvCheckMethod.FocusedItem.Tag;
clsLisCheckMethodVO objCopy = new clsLisCheckMethodVO();
objMethod.m_mthCopyTo(objCopy);
long lngRes = clsTmdCheckMethodSmp.s_object.m_lngDelete(objCopy.m_intSeq);
if (lngRes > 0)
{//成功
int intIdx = this.m_lsvCheckMethod.FocusedItem.Index;
this.m_lsvCheckMethod.FocusedItem.Remove();
//设置新的具有焦点的 ListView 项
if (intIdx < this.m_lsvCheckMethod.Items.Count)
{
this.m_lsvCheckMethod.Items[intIdx].Selected = true;
this.m_lsvCheckMethod.Items[intIdx].Focused = true;
this.m_lsvCheckMethod_Click(null, null);
}
else if (intIdx - 1 >= 0)
{
this.m_lsvCheckMethod.Items[intIdx - 1].Selected = true;
this.m_lsvCheckMethod.Items[intIdx - 1].Focused = true;
this.m_lsvCheckMethod_Click(null, null);
}
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
this.m_cmdCMDelete.Enabled = true;
Cursor.Current = Cursors.Default;
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisCheckMethodVO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
string strSQL = @"SELECT * FROM T_BSE_LIS_CHECKMETHOD ";
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 clsLisCheckMethodVO[dtbResult.Rows.Count];
for (int i = 0; i < p_objResultArr.Length; i++)
{
p_objResultArr[i] = new clsLisCheckMethodVO();
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_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckMethodVO p_objCheckMethod)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngUpdate");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"UPDATE T_BSE_LIS_CHECKMETHOD SET
CHECKMETHOD_NAME_VCHR=?,
PYCODE_VCHR=?,
WBCODE_VCHR=?
WHERE METHOD_SEQ_INT=?
" ;
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_objCheckMethod.m_strName,
p_objCheckMethod.m_strPycode,
p_objCheckMethod.m_strWbcode,
p_objCheckMethod.m_intSeq
);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisCheckMethodVO p_objCheckMethod)
{
long lngRes = 0;
p_objCheckMethod = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"SELECT * FROM T_BSE_LIS_CHECKMETHOD WHERE METHOD_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_objCheckMethod = new clsLisCheckMethodVO();
this.ConstructVO(dtbResult.Rows[0], ref p_objCheckMethod);
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
private void m_cmdCMSave_Click(object sender, EventArgs e)
{
if (this.m_lsvCheckMethod.FocusedItem == null &&
!this.m_blnNewCheckMethod)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
this.m_cmdCMSave.Enabled = false;
if (this.m_blnNewCheckMethod)
{//新增的保存
clsLisCheckMethodVO objMethod = new clsLisCheckMethodVO();
objMethod.m_strName = this.m_txtCMName.Text.Trim();
objMethod.m_strPycode = this.m_txtCMPYCode.Text.Trim();
objMethod.m_strWbcode = this.m_txtCMWBCode.Text.Trim();
long lngRes = clsTmdCheckMethodSmp.s_object.m_lngInsert(objMethod);
if (lngRes > 0)
{//成功
//更新状态标志
this.m_blnNewCheckMethod = false;
//加入到集合
clsLisCheckMethodVO[] objMethods = (clsLisCheckMethodVO[])this.m_lsvCheckMethod.Tag;
clsLisCheckMethodVO[] objMethodsNewArr = new clsLisCheckMethodVO[objMethods.Length + 1];
objMethods.CopyTo(objMethodsNewArr, 0);
objMethodsNewArr[objMethodsNewArr.Length - 1] = objMethod;
this.m_lsvCheckMethod.Tag = objMethodsNewArr;
//添加新项
ListViewItem item = new ListViewItem(objMethod.m_strName);
item.SubItems.Add(objMethod.m_strPycode);
item.SubItems.Add(objMethod.m_strWbcode);
item.Tag = objMethod;
this.m_lsvCheckMethod.Items.Add(item);
item.Selected = true;
item.Focused = true;
this.m_lsvCheckMethod_Click(null, null);
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
}
else
{//修改的保存
clsLisCheckMethodVO objMethod = (clsLisCheckMethodVO)this.m_lsvCheckMethod.FocusedItem.Tag;
clsLisCheckMethodVO objNewMethod = new clsLisCheckMethodVO();
objMethod.m_mthCopyTo(objNewMethod);
objNewMethod.m_strName = this.m_txtCMName.Text.Trim();
objNewMethod.m_strPycode = this.m_txtCMPYCode.Text.Trim();
objNewMethod.m_strWbcode = this.m_txtCMWBCode.Text.Trim();
long lngRes = clsTmdCheckMethodSmp.s_object.m_lngUpdate(objNewMethod);
if (lngRes > 0)
{//成功
objNewMethod.m_mthCopyTo(objMethod);
this.m_lsvCheckMethod.FocusedItem.Text = objMethod.m_strName;
this.m_lsvCheckMethod.FocusedItem.SubItems[1].Text = objMethod.m_strPycode;
this.m_lsvCheckMethod.FocusedItem.SubItems[2].Text = objMethod.m_strWbcode;
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
}
this.m_cmdCMSave.Enabled = true;
Cursor.Current = Cursors.Default;
}
