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); } } }