private bool pmValidVatSeq()
{
string strErrorMsg = "";
string strRefNo = "";
bool bllResult = true;
if (this.mstrVatSeq.TrimEnd() != string.Empty)
{
if (this.mFormEditMode == UIHelper.AppFormState.Insert || this.mstrOldVatSeq != this.mstrVatSeq)
{
string strMthYr = BizRule.GetVatSeqPrefix(mdttVatDue);
WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
object[] pAPara = new object[] { App.ActiveCorp.RowID, this.mstrBranchID, this.mstrVatType, this.mstrVatSeq };
if (BizRule.ChkDupVatSeq(pobjSQLUtil, pAPara, ref strRefNo))
{
strErrorMsg = "";
pAPara = new object[] { App.ActiveCorp.RowID, this.mstrBranchID, this.mstrVatType };
string strNewVatSeq = BizRule.RunVatSeq(pobjSQLUtil, pAPara, strMthYr, ref strErrorMsg);
strErrorMsg = "ÅӴѺ·Õè [" + this.mstrVatSeq + "] à¾×èÍÍÍ¡ÃÒ§ҹÀÒÉÕ«×éÍ\n";
strErrorMsg += "«éӡѺ¢Í§àÍ¡ÊÒÃãºÍ×è¹\n";
strErrorMsg += "à»ÅÕè¹à»ç¹ÅӴѺ·Õè [" + strNewVatSeq.Substring(strMthYr.Length, 5) + "]";
MessageBox.Show(strErrorMsg, "Application Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.mstrVatSeq = strNewVatSeq;
bllResult = false;
}
}
}
return(bllResult);
}
public ActionResult Edit()
{
BizRule bizRule = new BizRule();
bool result = false;
AspectF.Define
.Log(log, "RuleController-Edit[post]开始", "RuleController-Edit[post]结束")
.HowLong(log)
.Retry(log)
.Do(() =>
{
var reader = new StreamReader(Request.InputStream).ReadToEnd();
var model = JsonConvert.DeserializeObject <ViewRule>(reader);
ViewToDBForModel(bizRule, model);
if (string.IsNullOrEmpty(model.id))
{
result = ruleService.Add(bizRule);
}
else
{
bizRule.UpdateTime = DateTime.Now;
result = ruleService.Update(bizRule);
}
});
if (result)
{
return(Json(new { status = "y" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "n" }, JsonRequestBehavior.AllowGet));
}
}
private bool pmChkVatSeq(ref string ioErrorMsg)
{
bool bllResult = true;
string strRefNo = "";
string strMthYr = BizRule.GetVatSeqPrefix(this.txtVatDue.DateTime);
string strVatSeq = strMthYr + this.txtVatSeq.Text.TrimEnd();
if (this.mFormEditMode == UIHelper.AppFormState.Insert || this.mstrOldVatSeq != strVatSeq)
{
WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
object[] pAPara = new object[] { App.ActiveCorp.RowID, this.mstrBranchID, this.mstrVatType, strVatSeq };
if (BizRule.ChkDupVatSeq(pobjSQLUtil, pAPara, ref strRefNo))
{
ioErrorMsg = "ÅӴѺ·Õè [" + this.txtVatSeq.Text.TrimEnd() + "] à¾×èÍÍÍ¡ÃÒ§ҹÀÒÉÕ«×éÍ\n";
ioErrorMsg += "«éӡѺ¢Í§àÍ¡ÊÒÃàÅ¢·Õè " + strRefNo + "\n";
//MessageBox.Show(strErrorMsg, "Application Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
bllResult = false;
}
}
else
{
bllResult = true;
this.mstrVatSeq = strMthYr + this.txtVatSeq.Text.TrimEnd();
}
return(bllResult);
}
private void btnOK_Click(object sender, System.EventArgs e)
{
string strErrorMsg = "";
if (this.ofrmParent != null)
{
string lcOUm = this.mdtrActiveRow["cUOM"].ToString();
string lcOQnUm = this.mdtrActiveRow["cQnUOm"].ToString();
decimal lnOUmQty = Convert.ToDecimal(this.mdtrActiveRow["nUOMQty"]);
decimal lnOQty = Convert.ToDecimal(this.mdtrActiveRow["nQty"].ToString());
string lcOStUm = this.mdtrActiveRow["cStUOM"].ToString();
string lcOStQnUm = this.mdtrActiveRow["cStQnUOM"].ToString();
decimal lnOStUmQty = Convert.ToDecimal(this.mdtrActiveRow["nStUOMQty"]);
decimal lnOStQty = Convert.ToDecimal(this.mdtrActiveRow["nStQty"].ToString());
decimal lnOPrice = Convert.ToDecimal(this.mdtrActiveRow["nPrice"].ToString());
decimal lnODiscAmt = Convert.ToDecimal(this.mdtrActiveRow["nDiscAmt"].ToString());
this.txtUMQty.Value = (Convert.ToDecimal(this.txtUMQty.Value) == 0 ? 1 : Convert.ToDecimal(this.txtUMQty.Value));
this.txtStUMQty.Value = (Convert.ToDecimal(this.txtStUMQty.Value) == 0 ? 1 : Convert.ToDecimal(this.txtStUMQty.Value));
BizRule.GetQtyPriceInUm2(Convert.ToDecimal(this.mdtrActiveRow["nPrice"]), Convert.ToDecimal(this.mdtrActiveRow["nUOMQty"]), Convert.ToDecimal(this.txtUMQty.Value));
this.mdtrActiveRow["nQty"] = Convert.ToDecimal(this.txtQty.Value);
this.mdtrActiveRow["cUOM"] = this.txtQnUM.Tag.ToString();
this.mdtrActiveRow["cQnUom"] = this.txtQnUM.Text.TrimEnd();
this.mdtrActiveRow["nUOMQty"] = Convert.ToDecimal(this.txtUMQty.Value);
this.mdtrActiveRow["nStQty"] = Convert.ToDecimal(this.txtStQty.Value);
this.mdtrActiveRow["cStUOM"] = this.txtQnStUM.Tag.ToString();
this.mdtrActiveRow["nStUOMQty"] = Convert.ToDecimal(this.txtStUMQty.Value);
bool bllSucc = false;
if (this.ofrmParent != null)
{
bllSucc = this.ofrmParent.ValidateQty(true, ref strErrorMsg);
}
if (bllSucc)
{
this.DialogResult = DialogResult.OK;
}
else
{
this.mdtrActiveRow["cUOM"] = lcOUm;
this.mdtrActiveRow["cQnUom"] = lcOQnUm;
this.mdtrActiveRow["nUOMQty"] = lnOUmQty;
this.mdtrActiveRow["nQty"] = lnOQty;
this.mdtrActiveRow["nPrice"] = lnOPrice;
this.mdtrActiveRow["nDiscAmt"] = lnODiscAmt;
this.mdtrActiveRow["cStUOM"] = lcOStUm;
this.mdtrActiveRow["cStQnUOM"] = lcOStQnUm;
this.mdtrActiveRow["nStUOMQty"] = lnOStUmQty;
this.mdtrActiveRow["nStQty"] = lnOStQty;
}
}
else
{
this.DialogResult = DialogResult.OK;
}
}
private void pmLoadFormData()
{
DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);
if (dtrBrow != null)
{
this.mstrEditRowID = dtrBrow["fcSkid"].ToString();
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
pobjSQLUtil.SetPara(new object[] { this.mstrEditRowID });
if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, this.mstrRefTable, this.mstrRefTable, "select * from " + this.mstrRefTable + " where fcSkid = ?", ref strErrorMsg))
{
DataRow dtrLoadForm = this.dtsDataEnv.Tables[this.mstrRefTable].Rows[0];
this.txtCode.Text = dtrLoadForm["fcCode"].ToString().TrimEnd();
this.txtName.Text = dtrLoadForm["fcName"].ToString().TrimEnd();
this.txtSName.Text = dtrLoadForm["fcSName"].ToString().TrimEnd();
this.txtName2.Text = dtrLoadForm["fcName2"].ToString().TrimEnd();
this.txtSName2.Text = dtrLoadForm["fcSName2"].ToString().TrimEnd();
//this.txtAddr11.Text = dtrLoadForm[QCoorInfo.Field.Addr1].ToString().TrimEnd();
//this.txtAddr12.Text = dtrLoadForm[QCoorInfo.Field.Addr2].ToString().TrimEnd();
//this.txtAddr21.Text = dtrLoadForm[QCoorInfo.Field.Addr12].ToString().TrimEnd();
//this.txtAddr22.Text = dtrLoadForm[QCoorInfo.Field.Addr22].ToString().TrimEnd();
this.txtTel.Text = dtrLoadForm[QCoorInfo.Field.TelNo].ToString().TrimEnd();
//this.txtFax.Text = dtrLoadForm[QCoorInfo.Field.FaxNo].ToString().TrimEnd();
string gcTemStr01 = (Convert.IsDBNull(dtrLoadForm["fmMemData"]) ? "" : dtrLoadForm["fmMemData"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData2"]) ? "" : dtrLoadForm["fmMemData2"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData3"]) ? "" : dtrLoadForm["fmMemData3"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData4"]) ? "" : dtrLoadForm["fmMemData4"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrLoadForm["fmMemData5"]) ? "" : dtrLoadForm["fmMemData5"].ToString().TrimEnd());
this.txtAddr11.Text = BizRule.GetMemData(gcTemStr01, x_CMAd11);
this.txtAddr21.Text = BizRule.GetMemData(gcTemStr01, x_CMAd21);
//this.txtAddr31.Text = BizRule.GetMemData(gcTemStr01, x_CMAd31);
this.txtAddr12.Text = BizRule.GetMemData(gcTemStr01, x_CMAd12);
this.txtAddr22.Text = BizRule.GetMemData(gcTemStr01, x_CMAd22);
//this.txtAddr32.Text = BizRule.GetMemData(gcTemStr01, x_CMAd32);
this.txtFax.Text = BizRule.GetMemData(gcTemStr01, x_CMFax);
this.txtZip.Text = dtrLoadForm["fcZip"].ToString().TrimEnd();
this.txtTel.Text = BizRule.GetMemData(gcTemStr01, x_CMTel);
this.txtTaxID.Text = BizRule.GetMemData(gcTemStr01, x_CMTaxId);
}
this.pmLoadOldVar();
}
}
private void txtVatDue_Validating(object sender, CancelEventArgs e)
{
if (this.mdttLastVatDue.CompareTo(this.txtVatDue.DateTime) != 0)
{
this.mdttLastVatDue = this.txtVatDue.DateTime;
string strVatSeq = this.mstrVatSeq;
DateTime dttDate = this.mdttVatDue;
this.mstrVatSeq = BizRule.GetVatSeqPrefix(this.txtVatDue.DateTime) + this.txtVatSeq.Text;
this.pmValidVatSeq();
this.txtVatSeq.Text = this.mstrVatSeq.Substring(6, 5);
this.mstrVatSeq = strVatSeq;
this.mdttVatDue = dttDate;
}
}
public ActionResult Index(BizRule bizRule, int page = 1)
{
Page <BizRule> ruleList = new Page <BizRule>();
Page <ViewRule> viewlist = new Page <ViewRule>();
AspectF.Define
.Log(log, "RuleController-Index[post]开始", "RuleController-Index[post]结束")
.HowLong(log)
.Retry(log)
.Do(() =>
{
ruleList = ruleService.PageList(bizRule, PageHelper.PageSize, page);
ViewPageList(ruleList, viewlist);
});
return(new JsonResultPro(viewlist, JsonRequestBehavior.AllowGet, "yyyy-MM-dd HH:mm:ss"));
}
public ActionResult Edit(string id)
{
ViewRule viewmodel = new ViewRule();
AspectF.Define
.Log(log, "RuleController-Edit[get]开始", "RuleController-Edit[get]结束")
.HowLong(log)
.Retry(log)
.Do(() =>
{
BizRule bizRule = new BizRule();
bizRule.RuleID = id;
bizRule = ruleService.Single(bizRule);
DBToViewForModel(bizRule, viewmodel);
});
return(new JsonResultPro(viewmodel, JsonRequestBehavior.AllowGet, "yyyy-MM-dd HH:mm:ss"));
}
private void ReadAllRules(ExcelWorksheet schemaWorksheet, int row, BizRuleSet bizRuleSet)
{
List <string> bizRuleRow;
List <BizRule> bizRules;
BizRule bizRule;
string segmentPathKey;
int columnCount = bizRuleSet.MessageDomainIds.Count + 2; // +2 => Name and rule matching option
try
{
while ((bizRuleRow = ReadBizRuleRow(schemaWorksheet, columnCount, ref row)) != null)
{
if (bizRuleRow.Count != 0)
{
try
{
bizRule = new BizRule(bizRuleRow);
segmentPathKey = bizRuleRow[2].Substring(0, bizRuleRow[2].LastIndexOf("->"));
if (bizRuleSet.BizRules.TryGetValue(segmentPathKey, out bizRules) == false)
{
bizRules = new List <BizRule>();
bizRuleSet.BizRules.Add(segmentPathKey, bizRules);
}
bizRules.Add(bizRule);
}
catch (Exception ex)
{
AddValidationResult(ResultType.Error, row, "N/A", ex.Message);
}
}
row++;
}
}
catch (Exception ex)
{
AddValidationResult(ResultType.Error, row, "N/A", "Error occurred reading rules: " + ex.Message);
}
}
private void pmLoadRemark(string inProd)
{
this.mstrRemark1 = "";
this.mstrRemark2 = "";
this.mstrRemark3 = "";
this.mstrRemark4 = "";
this.mstrRemark5 = "";
this.mstrRemark6 = "";
this.mstrRemark7 = "";
this.mstrRemark8 = "";
this.mstrRemark9 = "";
this.mstrRemark10 = "";
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
pobjSQLUtil.SetPara(new object[] { inProd });
if (pobjSQLUtil.SQLExec(ref this.dtsDataEnv, "QProdX4", "PRODX4", "select * from ProdX4 where fcProd = ?", ref strErrorMsg))
{
DataRow dtrProdX4 = this.dtsDataEnv.Tables["QProdX4"].Rows[0];
string gcTemStr01 = (Convert.IsDBNull(dtrProdX4["fmMemData"]) ? "" : dtrProdX4["fmMemData"].ToString().TrimEnd());
string gcTemStr02 = (Convert.IsDBNull(dtrProdX4["fmMemData2"]) ? "" : dtrProdX4["fmMemData2"].ToString().TrimEnd());
string gcTemStr03 = (Convert.IsDBNull(dtrProdX4["fmMemData3"]) ? "" : dtrProdX4["fmMemData3"].ToString().TrimEnd());
string gcTemStr04 = (Convert.IsDBNull(dtrProdX4["fmMemData4"]) ? "" : dtrProdX4["fmMemData4"].ToString().TrimEnd());
string gcTemStr05 = (Convert.IsDBNull(dtrProdX4["fmMemData5"]) ? "" : dtrProdX4["fmMemData5"].ToString().TrimEnd());
this.mstrRemark1 = BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem);
this.mstrRemark2 = BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem2);
this.mstrRemark3 = BizRule.GetMemData(gcTemStr02, frmProd.xdCMRem3);
this.mstrRemark4 = BizRule.GetMemData(gcTemStr02, frmProd.xdCMRem4);
this.mstrRemark5 = BizRule.GetMemData(gcTemStr03, frmProd.xdCMRem5);
this.mstrRemark6 = BizRule.GetMemData(gcTemStr03, frmProd.xdCMRem6);
this.mstrRemark7 = BizRule.GetMemData(gcTemStr04, frmProd.xdCMRem7);
this.mstrRemark8 = BizRule.GetMemData(gcTemStr04, frmProd.xdCMRem8);
this.mstrRemark9 = BizRule.GetMemData(gcTemStr05, frmProd.xdCMRem9);
this.mstrRemark10 = BizRule.GetMemData(gcTemStr05, frmProd.xdCMRem10);
}
}
static void LamdaSample()
{
BizRule simpleRule = (h, r) => h * r;
BizRule fineRule = (h, r) => h * r - 100;
var processor = new ProcessData();
processor.Process(4, 150, simpleRule);
processor.Process(4, 150, fineRule);
Action <int, int> bizAction = ShowHoursAndRate;
Action <int, int> bizAction2 = (x, y) => Console.WriteLine(x + " " + y);
processor.ProcessAction(12, 3, bizAction);
processor.ProcessAction(12, 3, bizAction2);
Func <int, int, bool> fileLogger = (a, b) =>
{
Console.WriteLine("Logger: " + a + " " + b);
return(true);
};
processor.LogMessage(12, 3, fileLogger);
}
private void pmUpdateRecord()
{
string strErrorMsg = "";
bool bllIsNewRow = false;
bool bllIsCommit = false;
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
DataRow dtrSaveInfo = this.dtsDataEnv.Tables[this.mstrRefTable].NewRow();
if (this.mFormEditMode == UIHelper.AppFormState.Insert ||
(objSQLHelper.SetPara(new object[] { this.mstrEditRowID }) &&
!objSQLHelper.SQLExec(ref this.dtsDataEnv, "QChkRow", this.mstrRefTable, "select fcSkid from " + this.mstrRefTable + " where fcSkid = ?", ref strErrorMsg)))
{
bllIsNewRow = true;
if (this.mstrEditRowID == string.Empty)
{
WS.Data.Agents.cConn objConn = WS.Data.Agents.cConn.GetInStance();
this.mstrEditRowID = objConn.RunRowID(this.mstrRefTable);
}
//dtrSaveInfo[MapTable.ShareField.CreateBy] = App.FMAppUserID;
//dtrSaveInfo[MapTable.ShareField.CreateDate] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo["FTDATETIME"] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo["FTLASTUPD"] = objSQLHelper.GetDBServerDateTime();
}
// Control Field ที่ทุก Form ต้องมี
//dtrSaveInfo[MapTable.ShareField.RowID] = this.mstrEditRowID;
//dtrSaveInfo[MapTable.ShareField.LastUpdateBy] = App.FMAppUserID;
//dtrSaveInfo[MapTable.ShareField.LastUpdate] = objSQLHelper.GetDBServerDateTime();
dtrSaveInfo[MapTable.ShareField.fcSkid] = this.mstrEditRowID;
dtrSaveInfo["FTLASTUPD"] = objSQLHelper.GetDBServerDateTime();
// Control Field ที่ทุก Form ต้องมี
dtrSaveInfo[QCoorInfo.Field.CorpID] = App.ActiveCorp.RowID;
dtrSaveInfo[QCoorInfo.Field.Code] = this.txtCode.Text.TrimEnd();
dtrSaveInfo[QCoorInfo.Field.Name] = this.txtName.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr1] = this.txtAddr11.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr2] = this.txtAddr12.Text.TrimEnd();
dtrSaveInfo[QCoorInfo.Field.Name2] = this.txtName2.Text.TrimEnd();
dtrSaveInfo["fcSName"] = this.txtSName.Text.TrimEnd();
dtrSaveInfo["fcSName2"] = this.txtSName2.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr12] = this.txtAddr21.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.Addr22] = this.txtAddr22.Text.TrimEnd();
dtrSaveInfo[QCoorInfo.Field.TelNo] = this.txtTel.Text.TrimEnd();
//dtrSaveInfo[QCoorInfo.Field.FaxNo] = this.txtFax.Text.TrimEnd();
string gcTemStr01 = BizRule.SetMemData(this.txtAddr11.Text.Trim(), x_CMAd11);
gcTemStr01 += BizRule.SetMemData(this.txtAddr21.Text.Trim(), x_CMAd21);
//gcTemStr01 += BizRule.SetMemData(this.txtAddr31.Text.Trim(), x_CMAd31);
gcTemStr01 += BizRule.SetMemData(this.txtAddr12.Text.Trim(), x_CMAd12);
gcTemStr01 += BizRule.SetMemData(this.txtAddr22.Text.Trim(), x_CMAd22);
//gcTemStr01 += BizRule.SetMemData(this.txtAddr32.Text.Trim(), x_CMAd32);
gcTemStr01 += BizRule.SetMemData(this.txtTel.Text.Trim(), x_CMTel);
gcTemStr01 += BizRule.SetMemData(this.txtFax.Text.Trim(), x_CMFax);
gcTemStr01 += BizRule.SetMemData(this.txtTaxID.Text.Trim(), x_CMTaxId);
string gcTemStr02, gcTemStr03, gcTemStr04, gcTemStr05, gcTemStr06;
int intVarCharLen = 500;
gcTemStr02 = (gcTemStr01.Length > 0 ? StringHelper.SubStr(gcTemStr01, 1, intVarCharLen) : DBEnum.NullString);
gcTemStr03 = (gcTemStr01.Length > intVarCharLen ? StringHelper.SubStr(gcTemStr01, intVarCharLen + 1, intVarCharLen) : DBEnum.NullString);
gcTemStr04 = (gcTemStr01.Length > intVarCharLen * 2 ? StringHelper.SubStr(gcTemStr01, intVarCharLen * 2 + 1, intVarCharLen) : DBEnum.NullString);
gcTemStr05 = (gcTemStr01.Length > intVarCharLen * 3 ? StringHelper.SubStr(gcTemStr01, intVarCharLen * 3 + 1, intVarCharLen) : DBEnum.NullString);
gcTemStr06 = (gcTemStr01.Length > intVarCharLen * 4 ? StringHelper.SubStr(gcTemStr01, intVarCharLen * 4 + 1, intVarCharLen) : DBEnum.NullString);
dtrSaveInfo["fmMemData"] = gcTemStr02;
dtrSaveInfo["fmMemData2"] = gcTemStr03;
dtrSaveInfo["fmMemData3"] = gcTemStr04;
dtrSaveInfo["fmMemData4"] = gcTemStr05;
dtrSaveInfo["fmMemData5"] = gcTemStr06;
dtrSaveInfo["fcIsSupp"] = "Y";
dtrSaveInfo["fcZip"] = this.txtZip.Text.TrimEnd();
this.mSaveDBAgent = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.mSaveDBAgent.AppID = App.AppID;
this.mdbConn = this.mSaveDBAgent.GetDBConnection();
try
{
this.mdbConn.Open();
this.mdbTran = this.mdbConn.BeginTransaction(IsolationLevel.ReadUncommitted);
string strSQLUpdateStr = "";
object[] pAPara = null;
cDBMSAgent.GenUpdateSQLString(dtrSaveInfo, "fcSkid", bllIsNewRow, ref strSQLUpdateStr, ref pAPara);
this.mSaveDBAgent.BatchSQLExec(strSQLUpdateStr, pAPara, ref strErrorMsg, this.mdbConn, this.mdbTran);
this.mdbTran.Commit();
bllIsCommit = true;
if (this.mFormEditMode == UIHelper.AppFormState.Insert)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Insert, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else if (this.mFormEditMode == UIHelper.AppFormState.Edit)
{
if (this.mstrOldCode == this.txtCode.Text && this.mstrOldName == this.txtName.Text)
{
KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName);
}
else
{
KeepLogAgent.KeepLogChgValue(objSQLHelper, KeepLogType.Update, TASKNAME, this.txtCode.Text, this.txtName.Text, App.FMAppUserID, App.AppUserName, this.mstrOldCode, this.mstrOldName);
}
}
}
catch (Exception ex)
{
if (!bllIsCommit)
{
this.mdbTran.Rollback();
}
App.WriteEventsLog(ex);
#if xd_RUNMODE_DEBUG
MessageBox.Show("Message : " + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace);
#endif
}
finally
{
this.mdbConn.Close();
}
}
public void Process(int hours, int rate, BizRule ruleDelegate)
{
var result = ruleDelegate(hours, rate);
Console.WriteLine("Data Processed - Result: " + result);
}
public static void SetActiveCorp(DataRow inCorp)
{
App.gcCorp = inCorp["fcSkid"].ToString();
App.gcCorpName = inCorp["fcName"].ToString().TrimEnd();
App.gcCorpName2 = inCorp["fcName2"].ToString().TrimEnd();
App.gcCorpSaleVATType = (inCorp["fcVatType"].ToString() != string.Empty ? inCorp["fcVatType"].ToString() : "1");
App.gdStartCorpDate = Convert.ToDateTime(inCorp["fdCalDate"]);
BeSmartMRP.Business.Agents.KeepLogAgent.CORPID = inCorp["fcSkid"].ToString();
System.Data.DataSet dtsCorp = new System.Data.DataSet();
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
WS.Data.Agents.cDBMSAgent objSQLHelper2 = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
objSQLHelper2.SetPara(new object[] { App.AppUserID });
if (objSQLHelper2.SQLExec(ref dtsCorp, "QEmplR", "EMPLR", "select * from AppLogin where cRowID = ? ", ref strErrorMsg))
{
DataRow dtrEmpl = dtsCorp.Tables["QEmplR"].Rows[0];
App.mLocale_UI = UIHelper.AppEnum.GetLocaleEnum(dtrEmpl[QAppLogInInfo.Field.Locale_UI].ToString().TrimEnd());
App.mLocale_Report = UIHelper.AppEnum.GetLocaleEnum(dtrEmpl[QAppLogInInfo.Field.Locale_Report].ToString().TrimEnd());
string strLocale = "en-US";
switch (App.mLocale_UI)
{
case AppLocale.th_TH:
strLocale = "th-TH";
break;
case AppLocale.en_US:
strLocale = "en-US";
break;
}
pmSetAppCulture(strLocale);
}
ActiveCorp.RowID = inCorp["fcSkid"].ToString();
ActiveCorp.CorpChar = inCorp["fcCorpChar"].ToString();
ActiveCorp.Code = inCorp["fcCode"].ToString();
ActiveCorp.Name = inCorp["fcName"].ToString().TrimEnd();
ActiveCorp.Name2 = inCorp["fcName2"].ToString().TrimEnd();
ActiveCorp.StartAppDate = Convert.ToDateTime(inCorp["fdCalDate"]);
ActiveCorp.Address1 = inCorp["fcAddr1"].ToString().TrimEnd();
ActiveCorp.Address2 = inCorp["fcAddr2"].ToString().TrimEnd();
ActiveCorp.Address12 = inCorp["fcAddr12"].ToString().TrimEnd();
ActiveCorp.Address22 = inCorp["fcAddr22"].ToString().TrimEnd();
ActiveCorp.ShowFormulaCompo = (inCorp["fcShowComp"].ToString().TrimEnd() != string.Empty ? inCorp["fcShowComp"].ToString() : "1");
ActiveCorp.TelNo = inCorp["fcTel"].ToString().TrimEnd();
ActiveCorp.FaxNo = inCorp["fcFax"].ToString().TrimEnd();
//ActiveCorp.TaxID = inCorp["fcTaxID"].ToString().TrimEnd();
ActiveCorp.TaxID = inCorp["FCTRADENO"].ToString().TrimEnd();
ActiveCorp.SaleVATIsOut = (inCorp["fcVatIsOut"].ToString() != string.Empty ? inCorp["fcVatIsOut"].ToString() : "Y");
ActiveCorp.SaleVATType = (inCorp["fcVatType"].ToString() != string.Empty ? inCorp["fcVatType"].ToString() : "1");
ActiveCorp.SCtrlStock = (inCorp["fcCtrlStoc"].ToString().TrimEnd() != string.Empty ? inCorp["fcCtrlStoc"].ToString().TrimEnd() : "1");
ActiveCorp.CostMethod_Goods = (inCorp["fcGoodsCos"].ToString().TrimEnd() != string.Empty ? inCorp["fcGoodsCos"].ToString().TrimEnd() : "A");
ActiveCorp.CostMethod_Rawmat = (inCorp["fcRawCost"].ToString().TrimEnd() != string.Empty ? inCorp["fcRawCost"].ToString().TrimEnd() : "A");
objSQLHelper.SetPara(new object[1] {
inCorp["fcSect"].ToString()
});
if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Sect", "Sect", "select * from Sect where fcSkid = ? ", ref strErrorMsg))
{
App.ActiveCorp.DefaultSectID = dtsCorp.Tables["QVFLD_Sect"].Rows[0]["fcSkid"].ToString();
objSQLHelper.SetPara(new object[1] {
dtsCorp.Tables["QVFLD_Sect"].Rows[0]["fcDept"].ToString()
});
if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Dept", "Dept", "select * from Dept where fcSkid = ?", ref strErrorMsg))
{
App.ActiveCorp.DefaultDeptID = dtsCorp.Tables["QVFLD_Dept"].Rows[0]["fcSkid"].ToString();
}
}
objSQLHelper.SetPara(new object[1] {
inCorp["fcProj"].ToString()
});
if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Proj", "Proj", "select * from Proj where fcSkid = ? ", ref strErrorMsg))
{
App.ActiveCorp.DefaultProjectID = dtsCorp.Tables["QVFLD_Proj"].Rows[0]["fcSkid"].ToString();
}
objSQLHelper.SetPara(new object[1] {
inCorp["fcJob"].ToString()
});
if (objSQLHelper.SQLExec(ref dtsCorp, "QVFLD_Job", "Job", "select * from Job where fcSkid = ? ", ref strErrorMsg))
{
App.ActiveCorp.DefaultJobID = dtsCorp.Tables["QVFLD_Job"].Rows[0]["fcSkid"].ToString();
}
App.ActiveCorp.MMQtyFormatString = "#,###,###.0000";
App.ActiveCorp.PriceFormatString = "#,###,###.0000";
string strQtyPict = inCorp["fcQtyPict"].ToString();
string[] aText = strQtyPict.Split(".".ToCharArray());
if (aText.Length > 1)
{
App.ActiveCorp.QtyFormatString = AppUtil.StringHelper.ChrTran(aText[0].Trim(), "9", "#") + "." + AppUtil.StringHelper.ChrTran(aText[1].Trim(), "9", "0");
}
else
{
App.ActiveCorp.QtyFormatString = AppUtil.StringHelper.ChrTran(aText[0].Trim(), "9", "#");
}
string strRemark = (Convert.IsDBNull(inCorp["fmMemData"]) ? "" : inCorp["fmMemData"].ToString().TrimEnd());
strRemark += (Convert.IsDBNull(inCorp["fmMemData2"]) ? "" : inCorp["fmMemData2"].ToString().TrimEnd());
string strCorpVouCentMode = BizRule.GetMemData(strRemark, "VRM");
string strCorpVouRunLen = BizRule.GetMemData(strRemark, "VLN");
int intCorpVouRunLen = 4;
try
{
intCorpVouRunLen = Convert.ToInt32(strCorpVouRunLen);
}
catch { }
//App.ActiveCorp.CorpVouCentMode = (strCorpVouCentMode == "" ? "1" : strCorpVouCentMode);
//App.ActiveCorp.CorpVouRunLen = (intCorpVouRunLen < 4 ? 4 : intCorpVouRunLen);
}
private void pmPrintData()
{
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
App.MoreProcess = true;
App.AppMessage = "Start Extract Data...";
string strSQLStr = "select TRADETRM.FCCODE as QcTradeTrm,TRADETRM.FCNAME as QnTradeTrm";
strSQLStr = strSQLStr + " ,Coor.fcCode as QcCoor,Coor.fcName as QnCoor,Coor.fcPersonTy,COOR.FMMEMDATA as FMCMMEMDATA,COOR.FMMEMDATA2 as FMCMMEMDATA2,COOR.FMMEMDATA3 as FMCMMEMDATA3,COOR.FMMEMDATA4 as FMCMMEMDATA4,COOR.FMMEMDATA5 as FMCMMEMDATA5";
strSQLStr = strSQLStr + " ,GLRef.* from GLRef ";
strSQLStr = strSQLStr + " left join BOOK on Book.fcSkid = GLRef.fcBook ";
strSQLStr = strSQLStr + " left join COOR on COOR.FCSKID = GLREF.FCCOOR ";
strSQLStr = strSQLStr + " left join TRADETRM on GLREF.FCTRADETRM = TRADETRM.FCSKID ";
strSQLStr = strSQLStr + " where GLRef.fcCorp = ? ";
strSQLStr = strSQLStr + " and GLRef.fcBranch = ? ";
strSQLStr = strSQLStr + " and GLRef.fcVatType in ( select VatType.fcCode from VatType where VatType.fcCode between ? and ?) ";
strSQLStr = strSQLStr + " and GLRef.fdReceDate between ? and ? ";
strSQLStr = strSQLStr + " and GLRef.fcRfType in ('F', 'S', 'E', 'K')";
strSQLStr = strSQLStr + " and GLRef.fcVatDue = 'Y' ";
strSQLStr = strSQLStr + " and GLRef.FCISHOLD = '' ";
strSQLStr = strSQLStr + this.mstrBookPrefix;
strSQLStr = strSQLStr + " order by GLRef.fdDate, GLRef.fcRefNo";
Report.LocalDataSet.DTSPVAT dtsPrintPreview = new Report.LocalDataSet.DTSPVAT();
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
DateTime dttBegDate = new DateTime(this.txtBegDate.DateTime.Year, this.txtBegDate.DateTime.Month, 1);
//DateTime dttEndDate = new DateTime(this.txtEndDate.DateTime.Year, this.txtEndDate.DateTime.Month + 1, 1).AddDays(-1);
DateTime dttEndDate = new DateTime(this.txtEndDate.DateTime.Year, this.txtEndDate.DateTime.Month, 1).AddMonths(1).AddDays(-1);
//MessageBox.Show(dttEndDate.ToString("dd/MM/yyyy"));
objSQLHelper.SetPara(new object[] { App.ActiveCorp.RowID, this.txtQcBranch.Tag.ToString(), this.txtBegVat.Text, this.txtEndVat.Text, dttBegDate.Date, dttEndDate.Date });
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QGLRef", "GLRef", strSQLStr, ref strErrorMsg))
{
foreach (DataRow dtrGLRef in this.dtsDataEnv.Tables["QGLRef"].Rows)
{
DataRow dtrPreview = dtsPrintPreview.XRPVAT.NewRow();
string strDetail = "";
string strRemark = (Convert.IsDBNull(dtrGLRef["fmMemData"]) ? "" : dtrGLRef["fmMemData"].ToString().TrimEnd());
strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData2"]) ? "" : dtrGLRef["fmMemData2"].ToString().TrimEnd());
strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData3"]) ? "" : dtrGLRef["fmMemData3"].ToString().TrimEnd());
strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData4"]) ? "" : dtrGLRef["fmMemData4"].ToString().TrimEnd());
if (dtrGLRef["fmMemData5"] != null)
{
strRemark += (Convert.IsDBNull(dtrGLRef["fmMemData5"]) ? "" : dtrGLRef["fmMemData5"].ToString().TrimEnd());
}
//strDetail = BizRule.GetMemData(strRemark, "Det");
strDetail = dtrGLRef["QnCoor"].ToString().Trim();
string gcTemStr01 = (Convert.IsDBNull(dtrGLRef["fmCmMemData"]) ? "" : dtrGLRef["fmCmMemData"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData2"]) ? "" : dtrGLRef["fmCmMemData2"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData3"]) ? "" : dtrGLRef["fmCmMemData3"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData4"]) ? "" : dtrGLRef["fmCmMemData4"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrGLRef["fmCmMemData5"]) ? "" : dtrGLRef["fmCmMemData5"].ToString().TrimEnd());
string strMTaxID = BizRule.GetMemData(gcTemStr01, "MId");
string strTaxID = BizRule.GetMemData(gcTemStr01, "Tax");
string strBizType = BizRule.GetMemData(gcTemStr01, "TBu");
string strTax = "";
if (dtrGLRef["QcCoor"].ToString().Trim() == "-")
{
strTax = dtrGLRef["fcRecvMan"].ToString().Trim();
}
else
{
if (dtrGLRef["fcPersonTy"].ToString() == "Y")
{
strTax = strTaxID;
}
else
{
strTax = strMTaxID;
}
}
//App.WriteEventsLog2(dtrGLRef["fcRefNo"].ToString());
//decimal decAmt = Convert.ToDecimal(dtrGLRef["fnAmtKe"]) - Convert.ToDecimal(dtrGLRef["nCostAdj1"]) - Convert.ToDecimal(dtrGLRef["nCostAdj2"]);
decimal decAmt = Convert.ToDecimal(dtrGLRef["fnAmtKe"]);
//decimal decAmt = Convert.ToDecimal(dtrGLRef["fnAmtKe"]);
decimal decVATAmt = Convert.ToDecimal(dtrGLRef["fnVatAmt"]);
decAmt = decAmt * Convert.ToDecimal(dtrGLRef["fnXRate"]) * (dtrGLRef["fcRfType"].ToString() == "F" ? -1 : 1);
decVATAmt = decVATAmt * (dtrGLRef["fcRfType"].ToString() == "F" ? -1 : 1);
if (dtrGLRef["fcStat"].ToString() == "C")
{
decAmt = 0;
decVATAmt = 0;
}
dtrPreview["CSTAT"] = dtrGLRef["fcStat"].ToString();
dtrPreview["CVATTYPE"] = dtrGLRef["fcVatType"].ToString();
dtrPreview["DDATE"] = Convert.ToDateTime(dtrGLRef["fdDate"]);
dtrPreview["CREFTYPE"] = dtrGLRef["fcRefType"].ToString();
dtrPreview["CREFNO"] = dtrGLRef["fcRefNo"].ToString();
dtrPreview["CDETAIL"] = strDetail;
dtrPreview["NAMT"] = decAmt;
dtrPreview["NVATAMT"] = decVATAmt;
//fcRecvMan
dtrPreview["TaxID"] = strTax;
if (!Convert.IsDBNull(dtrGLRef["QCTradeTrm"]))
{
dtrPreview["QCTRADETRM"] = dtrGLRef["QcTradeTrm"].ToString().TrimEnd();
dtrPreview["QNTRADETRM"] = dtrGLRef["QnTradeTrm"].ToString().TrimEnd();
}
dtrPreview["BIZTYPE"] = strBizType;
dtsPrintPreview.XRPVAT.Rows.Add(dtrPreview);
}
this.pmPreviewReport(dtsPrintPreview);
}
else
{
//this.EndReport();
MessageBox.Show("ไม่มีข้อมูล");
}
}
private void pmPrintData()
{
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
string strCriteria = "";
string strOrderBy = "";
string strBegValue = ""; string strEndValue = "";
strOrderBy = "Master_Coor." + this.mstrOrderBy;
if (this.cmbWRng.SelectedIndex == 0)
{
strCriteria = strOrderBy + " between ? and ?";
objSQLHelper.SetPara(new object[] { this.txtBegCode.Text.TrimEnd(), this.txtEndCode.Text.TrimEnd() });
}
else
{
strCriteria = " Master_Coor.cCode in (" + this.pmGetRngCode() + ")";
}
Report.LocalDataSet.DTSPCOOR dtsPrintPreview = new Report.LocalDataSet.DTSPCOOR();
string strSQLStr = "select Master_Coor.* from " + MapTable.Table.MasterCoor;
strSQLStr += " where ";
strSQLStr += strCriteria + " order by " + strOrderBy;
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QCoor", "Coor", strSQLStr, ref strErrorMsg))
{
foreach (DataRow dtrPData in this.dtsDataEnv.Tables["QCoor"].Rows)
{
DataRow dtrPreview = dtsPrintPreview.XRPCOOR.NewRow();
dtrPreview["cCode"] = dtrPData["cCode"].ToString();
dtrPreview["cName"] = dtrPData["cName"].ToString();
dtrPreview["cName2"] = dtrPData["cName2"].ToString();
string gcTemStr01 = (Convert.IsDBNull(dtrPData["cMemData"]) ? "" : dtrPData["cMemData"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData2"]) ? "" : dtrPData["cMemData2"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData3"]) ? "" : dtrPData["cMemData3"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData4"]) ? "" : dtrPData["cMemData4"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData5"]) ? "" : dtrPData["cMemData5"].ToString().TrimEnd());
string strCTName = dtrPData["cContactN"].ToString().TrimEnd();
string strAddr11 = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMAd11);
string strAddr21 = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMAd21);
string strAddr31 = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMAd31);
string strZip = dtrPData["cZip"].ToString().TrimEnd();
string strTel = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMTel);
string strFax = BizRule.GetMemData(gcTemStr01, frmSuppl.x_CMFax);
decimal decCredTerm = Convert.ToInt32(dtrPData["nCredTerm"]);
decimal decCredLim = Convert.ToDecimal(dtrPData["nCredLim"]);
dtrPreview["cCtName"] = strCTName;
dtrPreview["cAddr"] = strAddr11 + " " + strAddr21 + " " + strAddr31 + " " + strZip;
dtrPreview["cTel"] = strTel;
dtrPreview["cFax"] = strFax;
dtrPreview["nCredTerm"] = decCredTerm;
dtrPreview["nCredLim"] = decCredLim;
dtsPrintPreview.XRPCOOR.Rows.Add(dtrPreview);
}
if (dtsPrintPreview.XRPCOOR.Rows.Count > 0)
{
this.pmPreviewReport(dtsPrintPreview);
}
}
}
public bool ValidateField(string inPdType, string inSearchStr, string inOrderBy, bool inForcePopUp)
{
bool bllIsVField = true;
this.mbllPopUpResult = false;
this.gridView1.OptionsView.ShowAutoFilterRow = true;
this.gridView1.OptionsView.ShowAutoFilterRow = false;
this.gridView1.OptionsView.ShowAutoFilterRow = true;
inOrderBy = inOrderBy.ToUpper();
if (inOrderBy.ToUpper() == "FCCODE")
{
inSearchStr = inSearchStr.PadRight(MAXLENGTH_CODE);
}
else
{
inSearchStr = inSearchStr.PadRight(MAXLENGTH_NAME);
}
//if (inOrderBy.ToUpper() == "FCCODE")
// inSearchStr = inSearchStr.TrimEnd();
//else
// inSearchStr = inSearchStr.TrimEnd();
if (this.mstrSortKey != inOrderBy)
{
this.mstrSortKey = inOrderBy;
this.pmSetSortKey(this.mstrSortKey, true);
}
if (this.mstrSearchStr != inSearchStr ||
inPdType != this.mstrPdType ||
this.mbllIsFormQuery == false)
{
string strSearch = inSearchStr.TrimEnd();
if (strSearch == SysDef.gc_DEFAULT_VALDATEKEY_PREFIX_STAR ||
strSearch == SysDef.gc_DEFAULT_VALDATEKEY_PREFIX_2SLASH)
{
strSearch = "";
}
//this.mstrSearchStr = "%" + strSearch + "%";
this.mstrSearchStr = strSearch;
this.mstrPdType = inPdType;
this.pmRefreshBrowView();
}
int intSeekVal = this.gridView1.LocateByValue(0, this.gridView1.Columns[this.mstrSortKey], inSearchStr);
bllIsVField = (intSeekVal < 0);
this.mbllIsShowDialog = false;
if (inForcePopUp || bllIsVField)
{
//this.gridView1.StartIncrementalSearch(inSearchStr.TrimEnd());
//this.ShowDialog();
//this.mbllIsShowDialog = true;
this.gridView1.FocusedColumn = this.gridView1.Columns[this.mstrSortKey];
this.gridView1.MoveLast();
this.gridView1.StartIncrementalSearch(inSearchStr.TrimEnd());
if (this.gridView1.FocusedRowHandle >= this.gridView1.RowCount - 1)
{
string strSeekNear = BizRule.GetNearString(this.dtsDataEnv.Tables[this.mstrBrowViewAlias], inSearchStr.Trim(), inOrderBy);
strSeekNear = strSeekNear.PadRight(inOrderBy.ToUpper() == QEMJobInfo.Field.Code ? MAXLENGTH_CODE : MAXLENGTH_NAME);
this.gridView1.StartIncrementalSearch(strSeekNear);
}
this.mintFocusRow = this.gridView1.FocusedRowHandle;
this.ShowDialog();
this.mbllIsShowDialog = true;
}
else
{
this.gridView1.FocusedRowHandle = intSeekVal;
this.mbllPopUpResult = true;
}
return(this.mbllPopUpResult);
}
public ActionResult GetAnswer(BizRule bizRule, string text)
{
RuleResult ruleResult = new RuleResult();
TuLingResult tuLingResult = new TuLingResult();
BizRecord bizRecord = new BizRecord();
List <BizRule> bizRules = new List <BizRule>();
AspectF.Define
.Log(log, "RuleController-QueryRule[post]开始", "RuleController-QueryRule[post]结束")
.HowLong(log)
.Retry(log)
.Do(() =>
{
text = RegularRemoveSign(text);
bizRules = ruleService.List(bizRule).ToList();
Dictionary <string, string> keyValues = new Dictionary <string, string>();
foreach (var item in bizRules)
{
//关键字一为Null
if (item.KeyWordOne == null)
{
if (text.Contains(item.KeyWordTwo))
{
text = text.Substring(0, text.IndexOf(item.KeyWordTwo) + item.KeyWordTwo.Length);
string keyWordTwo = item.KeyWordTwo;
text = text.Replace(keyWordTwo, "");
bizRule = ruleService.SingleTwo(keyWordTwo);
}
}
//关键字二为Null
else if (item.KeyWordTwo == null)
{
if (text.Contains(item.KeyWordOne))
{
text = text.Substring(text.IndexOf(item.KeyWordOne));
text = text.Replace(item.KeyWordOne, "");
bizRule = ruleService.SingleOne(item.KeyWordOne);
}
}
//关键字均不为空
else if (text.Contains(item.KeyWordOne))
{
if (text.Contains(item.KeyWordTwo))
{
text = text.Substring(text.IndexOf(item.KeyWordOne));
text = text.Substring(0, text.IndexOf(item.KeyWordTwo) + item.KeyWordTwo.Length);
text = text.Replace(item.KeyWordOne, "");
text = text.Replace(item.KeyWordTwo, "");
keyValues.Add(item.KeyWordOne, item.KeyWordTwo);
bizRule = ruleService.Single(keyValues.Keys.SingleOrDefault(), keyValues.Values.SingleOrDefault());
}
}
}
});
if (bizRule.RuleID == null)
{
//图灵机器人回复
ruleResult.text = ConnectTu(text).text;
bizRecord.QuestionContent = text;
recordService.Add(bizRecord);
}
else
{
ruleResult.text = bizRule.Answer;
ruleResult.url = bizRule.Website;
ruleResult.type = bizRule.AnswerTypes;
ruleResult.keyword = text;
}
return(new JsonResultPro(ruleResult, JsonRequestBehavior.AllowGet, "yyyy-MM-dd"));
}
public bool ValidateField(string inSearchStr, string inOrderBy, bool inForcePopUp)
{
bool bllIsVField = true;
this.mbllPopUpResult = false;
inOrderBy = inOrderBy.ToUpper();
if (inOrderBy.ToUpper() == QCoorInfo.Field.Code)
{
inSearchStr = inSearchStr.PadRight(this.txtCode.Properties.MaxLength);
}
else
{
inSearchStr = inSearchStr.PadRight(this.txtName.Properties.MaxLength);
}
if (this.mstrSortKey != inOrderBy)
{
this.mstrSortKey = inOrderBy;
this.pmSetSortKey(this.mstrSortKey, true);
}
if (this.mstrSearchStr != inSearchStr || this.mbllIsFormQuery == false)
{
string strSearch = inSearchStr.TrimEnd();
if (strSearch == SysDef.gc_DEFAULT_VALDATEKEY_PREFIX_STAR ||
strSearch == SysDef.gc_DEFAULT_VALDATEKEY_PREFIX_2SLASH)
{
strSearch = "";
}
this.mstrSearchStr = "%" + strSearch + "%";
this.pmRefreshBrowView();
}
int intSeekVal = this.gridView1.LocateByValue(0, this.gridView1.Columns[this.mstrSortKey], inSearchStr);
bllIsVField = (intSeekVal < 0);
this.mbllIsShowDialog = false;
if (inForcePopUp || bllIsVField)
{
this.gridView1.FocusedColumn = this.gridView1.Columns[this.mstrSortKey];
this.gridView1.MoveLast();
this.gridView1.StartIncrementalSearch(inSearchStr.TrimEnd());
if (this.gridView1.FocusedRowHandle >= this.gridView1.RowCount - 1)
{
string strSeekNear = BizRule.GetNearString(this.dtsDataEnv.Tables[this.mstrBrowViewAlias], inSearchStr.Trim(), inOrderBy);
strSeekNear = strSeekNear.PadRight(inOrderBy.ToUpper() == QCoorInfo.Field.Code ? this.txtCode.Properties.MaxLength : this.txtName.Properties.MaxLength);
this.gridView1.StartIncrementalSearch(strSeekNear);
}
this.ShowDialog();
this.mbllIsShowDialog = true;
}
else
{
this.gridView1.FocusedRowHandle = intSeekVal;
this.mbllPopUpResult = true;
}
return(this.mbllPopUpResult);
}
private void pmPrintData()
{
string strErrorMsg = "";
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
WS.Data.Agents.cDBMSAgent pobjSQLUtil2 = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
string strCriteria = "";
string strOrderBy = "";
string strBegValue = ""; string strEndValue = "";
strOrderBy = "Master_Prod." + this.mstrOrderBy;
string strOrderBy2 = "";
switch (this.cmbPOrderBy.SelectedIndex)
{
case 0:
strOrderBy2 = "Master_PdGrp.cCode, Master_Prod.cType, Master_Prod.cCode";
break;
case 1:
strOrderBy2 = "Master_PdGrp.cCode, Master_Prod.cType, Master_Prod.cName, Master_Prod.cCode";
break;
case 2:
strOrderBy2 = "Master_Prod.cCode";
break;
case 3:
strOrderBy2 = "Master_Prod.cName";
break;
}
strOrderBy = "Master_Prod." + this.mstrOrderBy;
if (this.cmbWRng.SelectedIndex == 0)
{
strCriteria = strOrderBy + " between ? and ?";
objSQLHelper.SetPara(new object[] { this.txtBegCode.Text.TrimEnd(), this.txtEndCode.Text.TrimEnd() });
}
else
{
strCriteria = " Master_Prod.cCode in (" + this.pmGetRngCode() + ")";
}
if (this.pATagPdType.Count > 0)
{
strCriteria += " and Master_Prod.cType in (" + this.pmGetRngCode2() + ")";
}
if (this.pATagPdGrp.Count > 0)
{
strCriteria += " and Master_PdGrp.cCode in (" + this.pmGetRngCode3() + ")";
}
Report.LocalDataSet.DTSPPROD dtsPrintPreview = new Report.LocalDataSet.DTSPPROD();
string strAcChartFld = " , AcChart1.cCode as QcAcChart, AcChart1.cName as QnAcChart ";
strAcChartFld += " , AcChart2.cCode as QcAcChart2, AcChart2.cName as QnAcChart2 ";
strAcChartFld += " , Master_PdGrp.cCode as QcPdGrp, Master_PdGrp.cName as QnPdGrp ";
strAcChartFld += " , Master_UM.cCode as QcUM, Master_UM.cName as QnUM ";
string strSQLStr = "select Master_Prod.* " + strAcChartFld + " from " + MapTable.Table.MasterProd;
strSQLStr += " left join Master_PdGrp on Master_PdGrp.cRowID = Master_Prod.cPdGrp ";
strSQLStr += " left join Master_UM on Master_UM.cRowID = Master_Prod.cUM ";
strSQLStr += " left join Master_AcChart AcChart1 on AcChart1.cRowID = Master_Prod.cAccBCash ";
strSQLStr += " left join Master_AcChart AcChart2 on AcChart2.cRowID = Master_Prod.cAccBCred ";
strSQLStr += " where ";
strSQLStr += strCriteria + " order by " + strOrderBy2;
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QProd", "Prod", strSQLStr, ref strErrorMsg))
{
foreach (DataRow dtrPData in this.dtsDataEnv.Tables["QProd"].Rows)
{
DataRow dtrPreview = dtsPrintPreview.XRPPROD.NewRow();
dtrPreview["cCode"] = dtrPData["cCode"].ToString();
dtrPreview["cName"] = dtrPData["cName"].ToString();
dtrPreview["cSName"] = dtrPData["cSName"].ToString();
dtrPreview["cName2"] = dtrPData["cName2"].ToString();
dtrPreview["cQcPdGrp"] = dtrPData["QcPdGrp"].ToString();
dtrPreview["cQnPdGrp"] = dtrPData["QnPdGrp"].ToString();
dtrPreview["cQcUM"] = dtrPData["QcUM"].ToString();
dtrPreview["cQnUM"] = dtrPData["QnUM"].ToString();
dtrPreview["cQcAcChart"] = dtrPData["QcAcChart"].ToString();
dtrPreview["cQnAcChart"] = dtrPData["QnAcChart"].ToString();
dtrPreview["cQcAcChart2"] = dtrPData["QcAcChart2"].ToString();
dtrPreview["cQnAcChart2"] = dtrPData["QnAcChart2"].ToString();
pobjSQLUtil2.SetPara(new object[] { dtrPData["cType"].ToString() });
if (pobjSQLUtil2.SQLExec(ref this.dtsDataEnv, "QPdType", "PDTYPE", "select * from PRODTYPE where FCCODE = ?", ref strErrorMsg))
{
DataRow dtrPdType = this.dtsDataEnv.Tables["QPdType"].Rows[0];
dtrPreview["cQcPdType"] = dtrPdType["fcCode"].ToString();
dtrPreview["cQnPdType"] = dtrPdType["fcName"].ToString();
}
dtrPreview["cVatIsOut"] = (dtrPData["cVatIsOut"].ToString() == "Y" ? "N" : "Y");
dtrPreview["cCtrlStock"] = dtrPData["cCtrlStoc"].ToString();
string gcTemStr01 = (Convert.IsDBNull(dtrPData["cMemData"]) ? "" : dtrPData["cMemData"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData2"]) ? "" : dtrPData["cMemData2"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData3"]) ? "" : dtrPData["cMemData3"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData4"]) ? "" : dtrPData["cMemData4"].ToString().TrimEnd());
gcTemStr01 += (Convert.IsDBNull(dtrPData["cMemData5"]) ? "" : dtrPData["cMemData5"].ToString().TrimEnd());
string strRemark1 = BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem2);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem3);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem4);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem5);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem6);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem7);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem8);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem9);
strRemark1 += " " + BizRule.GetMemData(gcTemStr01, frmProd.xdCMRem10);
dtrPreview["cRemark"] = strRemark1;
dtsPrintPreview.XRPPROD.Rows.Add(dtrPreview);
}
if (dtsPrintPreview.XRPPROD.Rows.Count > 0)
{
this.pmPreviewReport(dtsPrintPreview);
}
}
}
