/// <summary>
/// m_lngFindQCRule
/// </summary>
/// <param name="p_intSeq"></param>
/// <param name="p_objRule"></param>
/// <returns></returns>
public long m_lngFindQCRule(int p_intSeq, out clsLisQCRuleVO p_objRule)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngFindQCRule(this.objPrincipal, p_intSeq, out p_objRule));
}
}
/// <summary>
/// 控件赋值给Vo
/// </summary>
/// <param name="objRule">赋值的实例</param>
private void m_mthBindControlValueToObj(clsLisQCRuleVO objRule)
{
objRule.m_strName = this.m_txtRuleName.Text.Trim();
objRule.m_strAlias = this.m_txtRuleAliasName.Text.Trim();
objRule.m_strDesc = this.m_txtRuleDesc.Text.Trim();
objRule.m_strFormula = this.m_txtFormula.Text.Trim();
objRule.m_strSummary = this.m_txtSummary.Text.Trim();
objRule.m_enmDefaultflag = (enmQCRuleDefault)Convert.ToInt32(this.m_chkDefaultFlag.Checked);
objRule.m_enmWarnType = m_cboTypeFlag.SelectedIndex == 0 ? enmQCRuleWarnLevel.Error : enmQCRuleWarnLevel.Warning;
}
/// <summary>
/// ListView中的ListViewItem中展示
/// VO
/// </summary>
/// <param name="item"></param>
/// <param name="objRule"></param>
private void m_mthlsvItemDisplayObject(ListViewItem item, clsLisQCRuleVO objRule)
{
item.Text = objRule.m_strName;
item.SubItems[1].Text = objRule.m_strAlias;
item.SubItems[2].Text = objRule.m_strDesc;
item.SubItems[3].Text = objRule.m_strFormula;
item.SubItems[4].Text = objRule.m_strSummary;
item.SubItems[5].Text = objRule.m_enmDefaultflag == enmQCRuleDefault.YEA ? "是" : "否";
item.SubItems[6].Text = objRule.m_enmWarnType == enmQCRuleWarnLevel.Error ? "失控" : "警告";
}
/// <summary>
/// 控件展示VO中的值
/// </summary>
/// <param name="objRule">一个VO的实例</param>
private void m_mthControlsDisplayVOValue(clsLisQCRuleVO objRule)
{
this.m_txtRuleName.Text = objRule.m_strName;
this.m_txtRuleAliasName.Text = objRule.m_strAlias;
this.m_txtRuleDesc.Text = objRule.m_strDesc;
this.m_txtFormula.Text = objRule.m_strFormula;
this.m_txtSummary.Text = objRule.m_strSummary;
this.m_chkDefaultFlag.Checked = objRule.m_enmDefaultflag == enmQCRuleDefault.YEA ? true : false;
this.m_cboTypeFlag.SelectedIndex = objRule.m_enmWarnType == enmQCRuleWarnLevel.Error ? 0 : 1;
}
public long m_lngUpdate(clsLisQCRuleVO p_objRecord)
{
long lngRes = 0;
try
{
lngRes = m_objSvc.m_lngUpdate(m_objPrincipal, p_objRecord);
}
catch { lngRes = 0; }
return(lngRes);
}
public void ConstructVO(DataRow p_dtrSource, ref clsLisQCRuleVO p_objRule)
{
p_objRule.m_intSeq = p_dtrSource["RULE_SEQ_INT"] == System.DBNull.Value?0:int.Parse(p_dtrSource["RULE_SEQ_INT"].ToString().Trim());
p_objRule.m_strName = p_dtrSource["RULE_NAME_VCHR"].ToString().Trim();
p_objRule.m_strAlias = p_dtrSource["RULE_ALIAS_VCHR"].ToString().Trim();
p_objRule.m_strDesc = p_dtrSource["RULE_DESC_VCHR"].ToString().Trim();
p_objRule.m_strFormula = p_dtrSource["RULE_FORMULA_VCHR"].ToString().Trim();
p_objRule.m_strSummary = p_dtrSource["RULE_SUMMARY_VCHR"].ToString().Trim();
p_objRule.m_enmDefaultflag = (enmQCRuleDefault)(p_dtrSource["RULE_DEFAULTFLAG_INT"] == DBNull.Value?0:int.Parse(p_dtrSource["RULE_DEFAULTFLAG_INT"].ToString().Trim()));
p_objRule.m_enmWarnType = (enmQCRuleWarnLevel)(p_dtrSource["RULE_TYPEFLAG_INT"] == DBNull.Value?0:int.Parse(p_dtrSource["RULE_TYPEFLAG_INT"].ToString().Trim()));
}
/// <summary>
/// listView中的子项展示VO
/// </summary>
/// <param name="rule">一个规则实例</param>
/// <returns></returns>
private static ListViewItem m_mthlsvItemAddObject(clsLisQCRuleVO rule)
{
ListViewItem item = new ListViewItem(rule.m_strName);
item.SubItems.Add(rule.m_strAlias);
item.SubItems.Add(rule.m_strDesc);
item.SubItems.Add(rule.m_strFormula);
item.SubItems.Add(rule.m_strSummary);
item.SubItems.Add(rule.m_enmDefaultflag == enmQCRuleDefault.YEA ? "是" : "否");
item.SubItems.Add(rule.m_enmWarnType == enmQCRuleWarnLevel.Error ? "失控" : "警告");
return(item);
}
public long m_lngFind(int p_intID, out clsLisQCRuleVO 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_lsvRules_Click(object sender, EventArgs e)
{
if (this.m_lsvRules.FocusedItem == null)
{
return;
}
//变更状态标志
this.m_blnNewRule = false;
clsLisQCRuleVO objRule = (clsLisQCRuleVO)this.m_lsvRules.FocusedItem.Tag;
m_mthControlsDisplayVOValue(objRule);
}
public long m_lngInsert(clsLisQCRuleVO 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 long m_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCRuleVO p_objRule)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCRulesSvc", "m_lngInsert");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"UPDATE T_BSE_LIS_QCRULES SET
RULE_NAME_VCHR=?,
RULE_ALIAS_VCHR=?,
RULE_DESC_VCHR=?,
RULE_FORMULA_VCHR=?,
RULE_SUMMARY_VCHR=?,
RULE_DEFAULTFLAG_INT=?,
RULE_TYPEFLAG_INT=?
WHERE RULE_SEQ_INT=?
" ;
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_objRule.m_strName,
p_objRule.m_strAlias,
p_objRule.m_strDesc,
p_objRule.m_strFormula,
p_objRule.m_strSummary,
(int)p_objRule.m_enmDefaultflag,
(int)p_objRule.m_enmWarnType,
p_objRule.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);
}
//加载数据和填充列表
private void m_mthLoadRules()
{
Cursor.Current = Cursors.WaitCursor;
//加载数据
clsLisQCRuleVO[] objRulesArr = null;
clsTmdQCRulesSmp.s_object.m_lngFind(out objRulesArr);
if (objRulesArr == null)
{
objRulesArr = new clsLisQCRuleVO[0];
}
m_lsvRules.Tag = objRulesArr;
//填充列表
m_mthShowRulesList(objRulesArr);
Cursor.Current = Cursors.Default;
}
private void m_btnDelete_Click(object sender, EventArgs e)
{
if (this.m_lsvRules.FocusedItem == null)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
this.m_lsvRules.Enabled = false;
clsLisQCRuleVO objRule = (clsLisQCRuleVO)this.m_lsvRules.FocusedItem.Tag;
long lngRes = clsTmdQCRulesSmp.s_object.m_lngDelete(objRule.m_intSeq);
if (lngRes > 0)
{//成功
int intIdx = this.m_lsvRules.FocusedItem.Index;
this.m_lsvRules.FocusedItem.Remove();
//设置新的具有焦点的 ListView 项
if (intIdx < this.m_lsvRules.Items.Count)
{
this.m_lsvRules.Items[intIdx].Selected = true;
this.m_lsvRules.Items[intIdx].Focused = true;
this.m_lsvRules_Click(null, null);
}
else if (intIdx - 1 >= 0)
{
this.m_lsvRules.Items[intIdx - 1].Selected = true;
this.m_lsvRules.Items[intIdx - 1].Focused = true;
this.m_lsvRules_Click(null, null);
}
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
//m_mthLoadRules();
this.m_lsvRules.Enabled = true;
Cursor.Current = Cursors.Default;
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisQCRuleVO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCRulesSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
string strSQL = @"SELECT * FROM T_BSE_LIS_QCRULES ";
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 clsLisQCRuleVO[dtbResult.Rows.Count];
for (int i = 0; i < p_objResultArr.Length; i++)
{
p_objResultArr[i] = new clsLisQCRuleVO();
this.ConstructVO(dtbResult.Rows[i], ref p_objResultArr[i]);
}
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisQCRuleVO p_objRule)
{
long lngRes = 0;
p_objRule = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCRulesSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"SELECT * FROM T_BSE_LIS_QCRULES WHERE RULE_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_objRule = new clsLisQCRuleVO();
this.ConstructVO(dtbResult.Rows[0], ref p_objRule);
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCRuleVO p_objRule, 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.clsTmdQCRulesSvc", "m_lngInsert");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"
INSERT INTO T_BSE_LIS_QCRULES (
RULE_SEQ_INT,
RULE_NAME_VCHR,
RULE_ALIAS_VCHR,
RULE_DESC_VCHR,
RULE_FORMULA_VCHR,
RULE_SUMMARY_VCHR,
RULE_DEFAULTFLAG_INT,
RULE_TYPEFLAG_INT
)
VALUES
( ?, ? ,? , ?, ?, ?, ?, ?)";
try
{
lngRes = 0;
lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_QCRULES", "RULE_SEQ_INT", out p_intSeq);
if (lngRes <= 0)
{
return(-1);
}
lngRes = 0;
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_intSeq,
p_objRule.m_strName,
p_objRule.m_strAlias,
p_objRule.m_strDesc,
p_objRule.m_strFormula,
p_objRule.m_strSummary,
(int)p_objRule.m_enmDefaultflag,
(int)p_objRule.m_enmWarnType
);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
if (lngRes > 0)
{
p_objRule.m_intSeq = p_intSeq;//给VO赋值ID
}
else
{
p_intSeq = -1;
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
private void m_btnSave_Click(object sender, EventArgs e)
{
if (this.m_lsvRules.FocusedItem == null &&
!this.m_blnNewRule)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
this.m_btnNew.Enabled = false;
if (this.m_blnNewRule)
{//新增的保存
clsLisQCRuleVO objRule = new clsLisQCRuleVO();
m_mthBindControlValueToObj(objRule);
long lngRes = clsTmdQCRulesSmp.s_object.m_lngInsert(objRule);
if (lngRes > 0)
{//成功
//更新状态标志
this.m_blnNewRule = false;
//加入到集合
clsLisQCRuleVO[] objRuleArr = (clsLisQCRuleVO[])this.m_lsvRules.Tag;
clsLisQCRuleVO[] objRuleNewArr = new clsLisQCRuleVO[objRuleArr.Length + 1];
objRuleArr.CopyTo(objRuleNewArr, 0);
objRuleNewArr[objRuleNewArr.Length - 1] = objRule;
this.m_lsvRules.Tag = objRuleNewArr;
//添加新项
ListViewItem item = new ListViewItem(objRule.m_strName);
//item中展示
item = m_mthlsvItemAddObject(objRule);
item.Tag = objRule;
this.m_lsvRules.Items.Add(item);
item.Selected = true;
item.Focused = true;
this.m_lsvRules_Click(null, null);
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
this.m_btnNew.Enabled = true;
}
else
{//修改的保存
clsLisQCRuleVO objRule = (clsLisQCRuleVO)this.m_lsvRules.FocusedItem.Tag;
clsLisQCRuleVO objNewRule = new clsLisQCRuleVO();
objRule.m_mthCopyTo(objNewRule);
//Vo获取控件的值
m_mthBindControlValueToObj(objNewRule);
long lngRes = clsTmdQCRulesSmp.s_object.m_lngUpdate(objNewRule);
if (lngRes > 0)
{//成功
objNewRule.m_mthCopyTo(objRule);
m_mthlsvItemDisplayObject(this.m_lsvRules.FocusedItem, objRule);
}
else
{//失败
clsCommonDialog.m_mthShowDBError();
}
}
this.m_btnNew.Enabled = true;
this.m_btnSave.Enabled = true;
Cursor.Current = Cursors.Default;
}
