public static void CreatSupplyPlanMain(SupplyPlanMain oneplan)
{
string sqlString = string.Format("insert into EPM_Stuff_SupplyPlan_Main(SupplyPlanCode,PlanCreatTime,LimitDate,PlanMaker,HasCheck,SupplyReason,Remark,SupplyType,ContractCode,AuditResult) values('{0}',{1},'{2}','{3}',{4},'{5}','{6}','{7}','{8}','{9}')", new object[] { oneplan.PlanCode, "getdate()", oneplan.SupplyDate.ToString(), oneplan.PlanMaker, oneplan.IsChecked, oneplan.Reason, oneplan.Remark, oneplan.Type, oneplan.ContractCode, oneplan.AuditResult });
try
{
publicDbOpClass.NonQuerySqlString(sqlString);
}
catch (Exception exception)
{
throw exception;
}
}
public static void EditSupplyPlanMain(SupplyPlanMain oneplan)
{
string sqlString = string.Format("update EPM_Stuff_SupplyPlan_Main set SupplyPlanCode='{0}',LimitDate='{1}',PlanMaker='{2}',SupplyReason='{3}',Remark='{4}',SupplyType='{5}',ContractCode='{6}' where ItemID={7}", new object[] { oneplan.PlanCode, oneplan.SupplyDate.ToString(), oneplan.PlanMaker, oneplan.Reason, oneplan.Remark, oneplan.Type, oneplan.ContractCode, oneplan.PlanID });
try
{
publicDbOpClass.NonQuerySqlString(sqlString);
}
catch (Exception exception)
{
throw exception;
}
}
private static SupplyPlanMainCollection CreatMainBillCollectionFromTable(DataTable tbl)
{
SupplyPlanMainCollection mains = new SupplyPlanMainCollection();
if (tbl != null)
{
foreach (DataRow row in tbl.Rows)
{
SupplyPlanMain main = new SupplyPlanMain {
PlanID = Convert.ToInt32(row["ItemID"]),
PlanCode = row["SupplyPlanCode"].ToString(),
PlanMaker = row["PlanMaker"].ToString(),
IsChecked = Convert.ToInt32(row["HasCheck"]),
Reason = row["SupplyReason"].ToString(),
Remark = row["Remark"].ToString(),
SupplyDate = Convert.ToDateTime(row["LimitDate"]),
CreateDate = Convert.ToDateTime(row["PlanCreatTime"]),
Type = row["SupplyType"].ToString(),
ContractCode = row["ContractCode"].ToString(),
AuditInfo = row["AuditInfo"].ToString(),
AuditMan = row["AuditMan"].ToString()
};
try
{
main.FlowGuid = (Guid)row["FlowGuid"];
}
catch
{
main.FlowGuid = Guid.Empty;
}
if (row["AuditResult"].ToString().Length != 0)
{
main.AuditResult = Convert.ToInt32((row["AuditResult"].ToString().Length == 0) ? "0" : row["AuditResult"]);
main.AuditDate = Convert.ToDateTime((row["AuditDate"] == DBNull.Value) ? "1900-01-01" : row["AuditDate"]);
}
else
{
main.AuditResult = 3;
main.AuditDate = DateTime.Now;
}
mains.Add(main);
}
}
return(mains);
}
public static int SupplyPlanAdulit(int itemid, SupplyPlanMain spmc)
{
object obj2 = " update EPM_Stuff_SupplyPlan_Main set AuditInfo = '" + spmc.AuditInfo + "' ,AuditMan='" + spmc.AuditMan + "',";
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, " AuditDate = '", spmc.AuditDate, "',AuditResult='", spmc.AuditResult, "' where ItemID =", itemid })));
}
