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