protected void BtnSave_Click(object sender, EventArgs e) { string ErrorString = ""; if (!SystemSet.IsNatural_Number(TxSubNum.Text) && TxSubNum.Text == "") { ErrorString += "分包合約編號請填英文+數字!!!!\\n"; } if (TxSubName.Text == "") { ErrorString += "分包合約名稱請填入!!!!\\n"; } //if (!SystemSet.IsDate1(TxBookInTime.Text) || TxBookInTime.Text =="") //{ // ErrorString += "預定進場日期請填日期!!!!\\n"; //} // if (DDL_ContractType.SelectedValue=="0") //{ // ErrorString += "合約種類請選擇!!!!\\n"; //} if (!SystemSet.IsNumber(TxSubmitPercent.Text) && TxSubmitPercent.Text != "") { ErrorString += "出廠證明提送請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxRequestNum.Text) && TxRequestNum.Text != "") { ErrorString += "請款次數請填數字!!!!\\n"; } if (TxRequestDate.Text == "" && TxRequestDate.Text != "") { ErrorString += "請款日請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxPayDate.Text) && TxPayDate.Text != "") { ErrorString += "付款日請填數字!!!!\\n"; } if (RadioButton1.Checked == true) { if (!SystemSet.IsNumber(TxPType1.Text) || TxPType1.Text == "") { ErrorString += "逾罰請填數字!!!!\\n"; } } if (RadioButton2.Checked) { if (!SystemSet.IsNumber(TxPType2.Text) || TxPType2.Text == "") { ErrorString += "逾罰請填數字!!!!\\n"; } } if (!SystemSet.IsNumber(TxWarrantyYear.Text) && TxWarrantyYear.Text != "") { ErrorString += "保固年限請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxTaxPercent.Text) && TxTaxPercent.Text != "") { ErrorString += "稅額百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxPrepayPercent.Text) && TxPrepayPercent.Text != "") { ErrorString += "預付款百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxPrepayCash.Text) && TxPrepayCash.Text != "") { ErrorString += "預付款現金百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxPrepayCheckDay.Text) && TxPrepayCheckDay.Text != "") { ErrorString += "預付款期票天數請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxFundCash.Text) && TxFundCash.Text != "") { ErrorString += "工程款現金百分比請填數字!!!!\\n"; } //if (!SystemSet.IsNumber(TxFundCheckDay.Text) || TxFundCheckDay.Text == "") //{ // ErrorString += "工程款期票天數請填數字!!!!\\n"; //} if (!SystemSet.IsNumber(TxRetentionPercent.Text) && TxRetentionPercent.Text != "") { ErrorString += "保留款百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxRetentionCash.Text) && TxRetentionCash.Text != "") { ErrorString += "保留款現金百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxRetentionCheckDay.Text) && TxRetentionCheckDay.Text != "") { ErrorString += "保留款期票天數請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxWarrantyPercent.Text) && TxWarrantyPercent.Text != "") { ErrorString += "保固金百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxWarrantyCash.Text) && TxWarrantyCash.Text != "") { ErrorString += "保固金現金百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxWarrantyCheckDay.Text) && TxWarrantyCheckDay.Text != "") { ErrorString += "保固金期票天數請填數字!!!!\\n"; } if (ErrorString == "") { string database = Session["DatabaseName"].ToString(); bool result = WebModel.EditAction_Anyid(database, "SubContract_Main", "SCID", SCID.Text, GetDataBox()); //bool edit = WebModel.EditAction(database, "SubRFQ_Firm", LbSBID.Text, GetDataBox()); if (result) { Response.Write("<script>alert('已存檔!!');</script>"); } else { Response.Write("<script>alert('存檔失敗!!');</script>"); } } else { ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('" + ErrorString + "');", true); } }
//取得建入資料 protected DataTable GetDataBox1() { string ErrorString = ""; string SQLString = "Name,EIN,Type,SupportItem,Owner,OwnerMobile,Capital,StaffAmount,Location,Tel1,Tel2,Fax1,Fax2,Email,ContectAddress,RegisteredAddress,Notes"; DataTable DataTableBox = new DataTable(); foreach (string DataName in SQLString.Split(',')) { DataTableBox.Columns.Add(DataName, typeof(string)); } //後台功能,必需要有的欄位名稱 DataRow DataTableDr = DataTableBox.NewRow(); string FirmName = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_FirmName.Text)); string SupportItem = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_SupportItem.Text)); string EIN = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_EIN.Text)); string Owner = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Owner.Text)); string OwnerMobile = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_OwnerMobile.Text)); bool Capital = SystemSet.Float(TBE_Capital.Text); bool Staff = SystemSet.IsNumber(TBE_Staff.Text); string Tel1 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Tel1.Text)); string Tel2 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Tel2.Text)); string Fax1 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Fax1.Text)); string Fax2 = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Fax2.Text)); string Email = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Email.Text)); string Caddress = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_CAddress.Text)); string Notes = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_Notes.Text)); string RAddress = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TBE_RAddress.Text)); ErrorString += (DDL_Select7.SelectedValue) == "0" ? "請輸入廠商類型!!\\n" : ""; ErrorString += (DDL_Select8.SelectedValue) == "0" ? "請輸入所在縣市!!\\n" : ""; ErrorString += (Capital) != true ? "請輸入數字!!\\n" : ""; ErrorString += (Staff) != true ? "請輸入數字!!\\n" : ""; #region 內容設定 if (ErrorString == "") { DataTableDr["Name"] = FirmName; DataTableDr["SupportItem"] = SupportItem; DataTableDr["EIN"] = EIN; DataTableDr["Type"] = DDL_Select5.SelectedValue; DataTableDr["Owner"] = Owner; DataTableDr["OwnerMobile"] = OwnerMobile; DataTableDr["Capital"] = TBE_Capital.Text != "" ? decimal.Parse(TBE_Capital.Text) : 0; DataTableDr["StaffAmount"] = TBE_Staff.Text != "" ? decimal.Parse(TBE_Staff.Text) : 0; DataTableDr["Location"] = DDL_Select6.SelectedValue; DataTableDr["Tel1"] = Tel1; DataTableDr["Tel2"] = Tel2; DataTableDr["Fax1"] = Fax1; DataTableDr["Fax2"] = Fax2; DataTableDr["Email"] = Email; DataTableDr["ContectAddress"] = Caddress; DataTableDr["RegisteredAddress"] = RAddress; DataTableDr["Notes"] = Notes; DataTableDr["Type"] = DDL_Select7.SelectedValue; DataTableDr["Location"] = DDL_Select8.SelectedValue; DataTableBox.Rows.Add(DataTableDr); #endregion } else { ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('" + ErrorString + "');", true); } return(DataTableBox); }
protected void BtnAddSubC_Click(object sender, EventArgs e) { //bool SubNum = SystemSet.IsNumberLetter(TxSubNum.Text); string ErrorString = ""; string Update = ""; if (!SystemSet.IsNatural_Number(TxSubNum.Text) && TxSubNum.Text == "") { ErrorString += "分包合約編號請填英文+數字!!!!\\n"; } if (TxSubName.Text == "") { ErrorString += "分包合約名稱請填入!!!!\\n"; } //if (!SystemSet.IsDate1(TxBookInTime.Text) || TxBookInTime.Text =="") //{ // ErrorString += "預定進場日期請填日期!!!!\\n"; //} // if (DDL_ContractType.SelectedValue=="0") //{ // ErrorString += "合約種類請選擇!!!!\\n"; //} if (!SystemSet.IsNumber(TxSubmitPercent.Text) && TxSubmitPercent.Text != "") { ErrorString += "出廠證明提送請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxRequestNum.Text) && TxRequestNum.Text != "") { ErrorString += "請款次數請填數字!!!!\\n"; } if (TxRequestDate.Text == "" && TxRequestDate.Text != "") { ErrorString += "請款日請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxPayDate.Text) && TxPayDate.Text != "") { ErrorString += "付款日請填數字!!!!\\n"; } if (RadioButton1.Checked == true) { if (!SystemSet.IsNumber(TxPType1.Text) || TxPType1.Text == "") { ErrorString += "逾罰請填數字!!!!\\n"; } } if (RadioButton2.Checked) { if (!SystemSet.IsNumber(TxPType2.Text) || TxPType2.Text == "") { ErrorString += "逾罰請填數字!!!!\\n"; } } if (!SystemSet.IsNumber(TxWarrantyYear.Text) && TxWarrantyYear.Text != "") { ErrorString += "保固年限請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxTaxPercent.Text) && TxTaxPercent.Text != "") { ErrorString += "稅額百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxPrepayPercent.Text) && TxPrepayPercent.Text != "") { ErrorString += "預付款百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxPrepayCash.Text) && TxPrepayCash.Text != "") { ErrorString += "預付款現金百分比請填數字!!!!\\n"; } //if (!SystemSet.IsNumber(TxPrepayCheck.Text) || TxPrepayCheck.Text == "") //{ // ErrorString += "預付款期票百分比請填數字!!!!\\n"; //} if (!SystemSet.IsNumber(TxPrepayCheckDay.Text) && TxPrepayCheckDay.Text != "") { ErrorString += "預付款期票天數請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxFundCash.Text) && TxFundCash.Text != "") { ErrorString += "工程款現金百分比請填數字!!!!\\n"; } //if (!SystemSet.IsNumber(TxFundCheckDay.Text) || TxFundCheckDay.Text == "") //{ // ErrorString += "工程款期票天數請填數字!!!!\\n"; //} if (!SystemSet.IsNumber(TxRetentionPercent.Text) && TxRetentionPercent.Text != "") { ErrorString += "保留款百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxRetentionCash.Text) && TxRetentionCash.Text != "") { ErrorString += "保留款現金百分比請填數字!!!!\\n"; } //if (!SystemSet.IsNumber(TxRetentionCheck.Text) || TxRetentionCheck.Text == "") //{ // ErrorString += "保留款期票百分比請填數字!!!!\\n"; //} if (!SystemSet.IsNumber(TxRetentionCheckDay.Text) && TxRetentionCheckDay.Text != "") { ErrorString += "保留款期票天數請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxWarrantyPercent.Text) && TxWarrantyPercent.Text != "") { ErrorString += "保固金百分比請填數字!!!!\\n"; } if (!SystemSet.IsNumber(TxWarrantyCash.Text) && TxWarrantyCash.Text != "") { ErrorString += "保固金現金百分比請填數字!!!!\\n"; } //if (!SystemSet.IsNumber(TxWarrantyCheck.Text) || TxWarrantyCheck.Text == "") //{ // ErrorString += "保固金期票百分比請填數字!!!!\\n"; //} if (!SystemSet.IsNumber(TxWarrantyCheckDay.Text) && TxWarrantyCheckDay.Text != "") { ErrorString += "保固金期票天數請填數字!!!!\\n"; } if (ErrorString == "") { string database = Session["DatabaseName"].ToString(); string SQLString = "SCID,ItemName,Unit,BelongEWID,BelongItem,SCNumber,UnitPrice,ComplexPrice,Explan,ClearWay,Note"; DataTable DataTable = new DataTable(); foreach (string DataName in SQLString.Split(',')) { DataTable.Columns.Add(DataName, typeof(string)); } DataRow DataTableDr = DataTable.NewRow(); string SQLSItem = "select * from SubBudget_Item a left join SubRFQ_Material b on a.SBID=b.SBID and a.SB_MID=b.SB_MID where a.SBID=" + LbSBID.Text + " and b.FirmID=" + LbFirmID.Text; DataTable DataTableBox = WebModel.LoadSetContentData(database, SQLSItem); if (DataTableBox != null && DataTableBox.Rows.Count > 0) { foreach (DataRow row in DataTableBox.Rows) { //string SB_MID = row["SB_MID"].ToString(); int SCID = WebModel.MaxID(database, "SubContract_Main"); string ItemName = row["ItemName"].ToString(); string Unit = row["Unit"].ToString(); string BelongEWID = row["BelongEWID"].ToString(); string BelongItem = row["BelongItem"].ToString(); string SCNumber = row["SCNumber"].ToString(); string UnitPrice = row["UnitPrice"].ToString(); string ComplexPrice = row["ComplexPrice"].ToString(); string Explan = row["Explan"].ToString(); string Note = row["Note"].ToString(); DataTableDr["SCID"] = SCID; DataTableDr["ItemName"] = ItemName; DataTableDr["Unit"] = Unit; DataTableDr["BelongEWID"] = BelongEWID != ""?int.Parse(BelongEWID):0; DataTableDr["BelongItem"] = BelongItem; DataTableDr["SCNumber"] = SCNumber != "" ? decimal.Parse(SCNumber) : 0; //DataTableDr["LastSCNumber"] = SCNumber != "" ? decimal.Parse(SCNumber) : 0; DataTableDr["UnitPrice"] = UnitPrice != "" ? decimal.Parse(UnitPrice) : 0; DataTableDr["ComplexPrice"] = ComplexPrice != "" ? decimal.Parse(ComplexPrice) : 0; //DataTableDr["LastComplexPrice"] = ComplexPrice != "" ? decimal.Parse(ComplexPrice) : 0; DataTableDr["Explan"] = Explan; DataTableDr["Note"] = Note; DataTable.Rows.Add(DataTableDr); WebModel.SaveAction(database, "SubContract_Item", DataTable); DataTable.Rows.Clear(); Update = "Update SubBudgetList Set SCID='" + SCID + "' where SBID=" + LbSBID.Text; } } bool result1 = WebModel.SQLAction(database, Update); string result = WebModel.SaveAction(database, "SubContract_Main", GetDataBox()); //bool edit = WebModel.EditAction(database, "SubRFQ_Firm", LbSBID.Text, GetDataBox()); if (result == "1") { Response.Write("<script>alert('已存檔!!');</script>"); } else { Response.Write("<script>alert('存檔失敗!!');</script>"); } } else { ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('" + ErrorString + "');", true); } }