public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisConcentrationVO p_objConcentration)
{
long lngRes = 0;
p_objConcentration = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(p_intSeq);
DataTable dtbResult = null;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithParameters(m_strFindSql, ref dtbResult, objODPArr);
objHRPSvc.Dispose();
if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0)
{
p_objConcentration = new clsLisConcentrationVO();
this.ConstructVO(dtbResult.Rows[0], ref p_objConcentration);
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisConcentrationVO QCBatch)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngUpdate");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr = GetUpdateDataParameterArr(QCBatch);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(m_strUpdateSql, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
private System.Data.IDataParameter[] GetUpdateDataParameterArr(clsLisConcentrationVO p_objConcentration)
{
System.Data.IDataParameter[] objODPArr = null;
objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_objConcentration.m_strConcentration,
(int)p_objConcentration.m_enmStatus,
p_objConcentration.m_intSeq
);
return(objODPArr);
}
/// <summary>
/// insert的参数组
/// </summary>
/// <param name="p_objConcentration"></param>
/// <param name="p_intSeq"></param>
/// <returns></returns>
private System.Data.IDataParameter[] GetInsertDataParameterArr(clsLisConcentrationVO p_objConcentration, int p_intSeq)
{
// CONCENTRATION_SEQ_INT, CONCENTRATION_VCHR, STATUS_INT
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr
(
p_intSeq,
p_objConcentration.m_strConcentration,
(int)p_objConcentration.m_enmStatus
);
return(objODPArr);
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisConcentrationVO p_objConcentration)
{
// CONCENTRATION_SEQ_INT, CONCENTRATION_VCHR, STATUS_INT
p_objConcentration.m_intSeq = DBAssist.ToInt32(p_dtrSource["CONCENTRATION_SEQ_INT"]);
p_objConcentration.m_strConcentration = p_dtrSource["CONCENTRATION_VCHR"].ToString();
try
{
p_objConcentration.m_enmStatus = (enmQCStatus)DBAssist.ToInt32(p_dtrSource["STATUS_INT"]);
}
catch { }
}
public long m_lngUpdate(clsLisConcentrationVO 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 clsLisConcentrationVO 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_lsvConcentration_Click(object sender, EventArgs e)
{
if (this.m_lsvConcentration.FocusedItem == null)
{
return;
}
//变更状态标志
this.m_blnNewConcentration = false;
clsLisConcentrationVO objConcentration = (clsLisConcentrationVO)this.m_lsvConcentration.FocusedItem.Tag;
this.m_txtConcentration.Text = objConcentration.m_strConcentration;
}
private void m_cmdCCancelDelete_Click(object sender, EventArgs e)
{
if (this.m_lsvConcentration.FocusedItem == null ||
this.m_lsvConcentration.FocusedItem.Tag == null)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
m_cmdCCancelDelete.Enabled = false;
clsLisConcentrationVO objconcentration = (clsLisConcentrationVO)this.m_lsvConcentration.FocusedItem.Tag;
clsLisConcentrationVO objCopy = new clsLisConcentrationVO();
objconcentration.m_mthCopyTo(objCopy);//拷贝到另一个对象
objCopy.m_enmStatus = enmQCStatus.Natrural;
//更新到数据库
long lngRes = clsTmdConcentrationSmp.s_object.m_lngUpdate(objCopy);
if (lngRes > 0)
{//更新成功
objconcentration.m_enmStatus = enmQCStatus.Natrural;
int intIdx = this.m_lsvConcentration.FocusedItem.Index;
this.m_lsvConcentration.FocusedItem.Remove();
//设置新的具有焦点的 ListView 项
if (intIdx < this.m_lsvConcentration.Items.Count)
{
this.m_lsvConcentration.Items[intIdx].Selected = true;
this.m_lsvConcentration.Items[intIdx].Focused = true;
this.m_lsvConcentration_Click(null, null);
}
else if (intIdx - 1 >= 0)
{
this.m_lsvConcentration.Items[intIdx - 1].Selected = true;
this.m_lsvConcentration.Items[intIdx - 1].Focused = true;
this.m_lsvConcentration_Click(null, null);
}
}
else
{//更新失败
clsCommonDialog.m_mthShowDBError();
}
m_cmdCCancelDelete.Enabled = true;
Cursor.Current = Cursors.Default;
}
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisConcentrationVO p_objConcentration, out int p_intSeq)
{
long lngRes = 0;
p_intSeq = -1;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
lngRes = 0;
lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq);
if (lngRes <= 0)
{
return(-1);
}
lngRes = 0;
System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objConcentration, p_intSeq);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
if (lngRes > 0)
{
p_objConcentration.m_intSeq = p_intSeq;//给VO赋值ID
}
else
{
p_intSeq = -1;
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngInsert(clsLisConcentrationVO 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_mthLoadConcentration()
{
Cursor.Current = Cursors.WaitCursor;
//加载数据
clsLisConcentrationVO[] objconcentrationArr = null;
clsTmdConcentrationSmp.s_object.m_lngFind(out objconcentrationArr);
if (objconcentrationArr == null)
{
objconcentrationArr = new clsLisConcentrationVO[0];
}
m_lsvConcentration.Tag = objconcentrationArr;
//填充列表
m_mthShowConcentrationList(objconcentrationArr, this.m_chkCShowDeleted.Checked);
Cursor.Current = Cursors.Default;
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisConcentrationVO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
string strSQL = @"SELECT * FROM T_BSE_LIS_CONCENTRATION ";
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 clsLisConcentrationVO[dtbResult.Rows.Count];
for (int i = 0; i < p_objResultArr.Length; i++)
{
p_objResultArr[i] = new clsLisConcentrationVO();
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);
}
private void m_mthLoadData()
{
//加入空项
clsLisConcentrationVO obj = new clsLisConcentrationVO();
obj.m_strConcentration = string.Empty;
obj.m_intSeq = DBAssist.NullInt;
obj.m_enmStatus = enmQCStatus.Natrural;
this.Items.Add(obj);
//加载数据
clsLisConcentrationVO[] objConcentrationArr = null;
long lngRes = clsTmdConcentrationSmp.s_object.m_lngFind(out objConcentrationArr);
if (lngRes > 0 && objConcentrationArr != null)
{
foreach (clsLisConcentrationVO objConcentration in objConcentrationArr)
{
if (objConcentration.m_enmStatus == enmQCStatus.Natrural)
{
this.Items.Add(objConcentration);
}
}
}
}
private void m_cmdCSave_Click(object sender, EventArgs e)
{
if (this.m_lsvConcentration.FocusedItem == null &&
!this.m_blnNewConcentration)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
this.m_cmdCSave.Enabled = false;
if (this.m_blnNewConcentration)
{//新增的保存
clsLisConcentrationVO objConentration = new clsLisConcentrationVO();
objConentration.m_enmStatus = enmQCStatus.Natrural;
objConentration.m_strConcentration = this.m_txtConcentration.Text.Trim();
long lngRes = clsTmdConcentrationSmp.s_object.m_lngInsert(objConentration);
if (lngRes > 0)
{//成功
//更新状态标志
this.m_blnNewConcentration = false;
//加入到集合
clsLisConcentrationVO[] objconcentrationArr = (clsLisConcentrationVO[])this.m_lsvConcentration.Tag;
clsLisConcentrationVO[] objconcentrationNewArr = new clsLisConcentrationVO[objconcentrationArr.Length + 1];
objconcentrationArr.CopyTo(objconcentrationNewArr, 0);
objconcentrationNewArr[objconcentrationNewArr.Length - 1] = objConentration;
this.m_lsvConcentration.Tag = objconcentrationNewArr;
//添加新项
ListViewItem item = new ListViewItem(objConentration.m_strConcentration);
item.Text = objConentration.m_intSeq.ToString();
item.SubItems.Add(objConentration.m_strConcentration);
item.Tag = objConentration;
this.m_lsvConcentration.Items.Add(item);
item.Selected = true;
item.Focused = true;
this.m_lsvConcentration_Click(null, null);
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
}
else
{//修改的保存
clsLisConcentrationVO objConcentration = (clsLisConcentrationVO)this.m_lsvConcentration.FocusedItem.Tag;
clsLisConcentrationVO objNewConcentration = new clsLisConcentrationVO();
objConcentration.m_mthCopyTo(objNewConcentration);
objNewConcentration.m_strConcentration = this.m_txtConcentration.Text.Trim();
long lngRes = clsTmdConcentrationSmp.s_object.m_lngUpdate(objNewConcentration);
if (lngRes > 0)
{//成功
objNewConcentration.m_mthCopyTo(objConcentration);
this.m_lsvConcentration.FocusedItem.Text = objConcentration.m_intSeq.ToString();
this.m_lsvConcentration.FocusedItem.SubItems[1].Text = objConcentration.m_strConcentration;
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
}
this.m_cmdCSave.Enabled = true;
Cursor.Current = Cursors.Default;
}
