public String WBSEventMInsert(WBSEvent.Models.WBSEvent Object) { string SqlStr = ""; String result; AdoSql.AdoSql adosql = new AdoSql.AdoSql(); //string SelectUnit = DropDownList1.Text; string WBSCaseNumberM = Object.WBSCaseNumberM; string WBSCaseNumberC = Object.WBSCaseNumberC; SqlStr = "SELECT * FROM WBSEvent where WBSCaseNumberM = '" + WBSCaseNumberM + "'"; DataTable UnitDT = adosql.Grid_Select(SqlStr); if (UnitDT.Rows.Count > 0) { adosql.conn.Close(); return "母單重複"; //母單重複 } AdoSql.AdoSql adosql2 = new AdoSql.AdoSql(); SqlStr = String.Format(@"insert into WBSEventM(RB_CasseDate,RB_CasseNumber,WBSCaseNumberM, CustomerGroupSW,CustomerID,CustomerGroupID,CustomerBranchID,CustomerUserID, CustomerUserName,CustomerUserPhone1,CustomerUserPhone2) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", Object.RB_CasseDate, Object.RB_CasseNumber, Object.WBSCaseNumberM, Object.CustomerGroupSW, Object.CustomerID, Object.CustomerGroupID, Object.CustomerBranchID, Object.CustomerUserID, Object.CustomerUserName, Object.CustomerUserPhone1, Object.CustomerUserPhone2); result = adosql2.Sql_Execute(SqlStr, "A"); adosql2.conn.Close(); adosql.conn.Close(); if (!result.Equals("1")) return result; return "True"; }
public Boolean Insert(WBSEvent.Models.WBSEvent Object) { string SqlStr = ""; AdoSql.AdoSql adosql = new AdoSql.AdoSql(); //string SelectUnit = DropDownList1.Text; string WBSCaseNumberM = Object.WBSCaseNumberM; string WBSCaseNumberC = Object.WBSCaseNumberC; SqlStr = "SELECT * FROM WBSEvent where WBSCaseNumberM = '" + WBSCaseNumberM + "' and WBSCaseNumberC = '" + WBSCaseNumberC + "'"; DataTable UnitDT = adosql.Grid_Select(SqlStr); if (UnitDT.Rows.Count > 0) { return false; //母單與子單皆重複 } //insert AdoSql.AdoSql adosql2 = new AdoSql.AdoSql(); SqlStr = String.Format(@"insert into WBSEvent(RB_CasseDate,RB_CasseNumber,WBSCaseNumberM,WBSCaseNumberC,EventClassCode, CustomerGroupSW,CustomerID,CustomerGroupID,CustomerBranchID,CustomerUserID, CustomerUserName,CustomerUserPhone1,CustomerUserPhone2,ItemClassCode,QuestionClassCode, QuestionGrade,QuestionDescription,QuestionActtachment1,QuestionActtachment2,QuestionActtachment3, QuestionActtachment4,QuestionActtachment5,QuestionActtachment6,QuestionCreateUserID,QuestionCreateDateTime, ExpectArriveDateTime,ExpectFinishDateTime,ExpectArriveSW,DeleteMarkSW,DeleteReason, DeleteMarkUserID,DeleteMarkDateTime,CreateDateTime,CreateUserID,ModifyDateTime,ModifyUserID) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}', '{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}', '{30}','{31}','{32}','{33}','{34}','{35}')", Object.RB_CasseDate, Object.RB_CasseNumber, Object.WBSCaseNumberM, Object.WBSCaseNumberC, Object.EventClassCode, Object.CustomerGroupSW, Object.CustomerID, Object.CustomerGroupID, Object.CustomerBranchID, Object.CustomerUserID, Object.CustomerUserName, Object.CustomerUserPhone1, Object.CustomerUserPhone2, Object.ItemClassCode, Object.QuestionClassCode, Object.QuestionGrade, Object.QuestionDescription, Object.QuestionActtachment1, Object.QuestionActtachment2, Object.QuestionActtachment3, Object.QuestionActtachment4, Object.QuestionActtachment5, Object.QuestionActtachment6, Object.QuestionCreateUserID, Object.QuestionCreateDateTime, Object.ExpectArriveDateTime, Object.ExpectFinishDateTime, Object.ExpectArriveSW, Object.DeleteMarkSW, Object.DeleteReason, Object.DeleteMarkUserID, Object.DeleteMarkDateTime, Object.CreateDateTime, Object.CreateUserID, Object.ModifyDateTime, Object.ModifyUserID); adosql2.Sql_Execute(SqlStr, "A"); adosql2.conn.Close(); adosql.conn.Close(); return true; }
public String WBSEventCInsert(WBSEvent.Models.WBSEvent Object) { string SqlStr = ""; String result; AdoSql.AdoSql adosql = new AdoSql.AdoSql(); //string SelectUnit = DropDownList1.Text; string WBSCaseNumberM = Object.WBSCaseNumberM; string WBSCaseNumberC = Object.WBSCaseNumberC; SqlStr = "SELECT * FROM WBSEvent where WBSCaseNumberM = '" + WBSCaseNumberM + "' and WBSCaseNumberC = '" + WBSCaseNumberC + "'"; DataTable UnitDT = adosql.Grid_Select(SqlStr); if (UnitDT.Rows.Count > 0) { adosql.conn.Close(); return "母單與子單重複"; //母單與子單皆重複 } //insert AdoSql.AdoSql adosql2 = new AdoSql.AdoSql(); SqlStr = String.Format(@"insert into WBSEventC(WBSCaseNumberM,WBSCaseNumberC,EventClassCode,ItemClassCode,QuestionClassCode, QuestionGrade,QuestionDescription,QuestionActtachment1,QuestionActtachment2,QuestionActtachment3, QuestionActtachment4,QuestionActtachment5,QuestionActtachment6,QuestionCreateUserID,QuestionCreateDateTime, ExpectArriveDateTime,ExpectFinishDateTime,ExpectArriveSW,DeleteMarkSW,DeleteReason, DeleteMarkUserID,DeleteMarkDateTime,CreateDateTime,CreateUserID,ModifyDateTime,ModifyUserID) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}', '{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}')", Object.WBSCaseNumberM, Object.WBSCaseNumberC, Object.EventClassCode, Object.ItemClassCode, Object.QuestionClassCode, Object.QuestionGrade, Object.QuestionDescription, Object.QuestionActtachment1, Object.QuestionActtachment2, Object.QuestionActtachment3, Object.QuestionActtachment4, Object.QuestionActtachment5, Object.QuestionActtachment6, Object.QuestionCreateUserID, Object.QuestionCreateDateTime, Object.ExpectArriveDateTime, Object.ExpectFinishDateTime, Object.ExpectArriveSW, Object.DeleteMarkSW, Object.DeleteReason, Object.DeleteMarkUserID, Object.DeleteMarkDateTime, Object.CreateDateTime, Object.CreateUserID, Object.ModifyDateTime, Object.ModifyUserID); result = adosql2.Sql_Execute(SqlStr, "A"); adosql2.conn.Close(); adosql.conn.Close(); if (!result.Equals("1")) return result; return "True"; }
public String WBSEventInsert(WBSEvent.Models.WBSEvent Object) { String result; result = WBSEventMInsert(Object); if (!result.Equals("True")) return result; result = WBSEventCInsert(Object); if (!result.Equals("True")) return result; return "True"; }