/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.BPM_Order DataRowToModel(DataRow row)
{
MES.Server.Model.BPM_Order model = new MES.Server.Model.BPM_Order();
if (row != null)
{
if (row["OrderID"] != null)
{
model.OrderID = row["OrderID"].ToString();
}
if (row["ClientName"] != null)
{
model.ClientName = row["ClientName"].ToString();
}
if (row["ProductID"] != null)
{
model.ProductID = row["ProductID"].ToString();
}
if (row["ProductName"] != null)
{
model.ProductName = row["ProductName"].ToString();
}
if (row["Spec"] != null)
{
model.Spec = row["Spec"].ToString();
}
if (row["Count"] != null && row["Count"].ToString() != "")
{
model.Count = double.Parse(row["Count"].ToString());
}
if (row["TotalWorkHoursStandard"] != null && row["TotalWorkHoursStandard"].ToString() != "")
{
model.TotalWorkHoursStandard = double.Parse(row["TotalWorkHoursStandard"].ToString());
}
if (row["StartDate"] != null)
{
model.StartDate = row["StartDate"].ToString();
}
if (row["EndDate"] != null)
{
model.EndDate = row["EndDate"].ToString();
}
if (row["ActualStartDate"] != null)
{
model.ActualStartDate = row["ActualStartDate"].ToString();
}
if (row["ActualEndDate"] != null)
{
model.ActualEndDate = row["ActualEndDate"].ToString();
}
if (row["DeliveryDate"] != null && row["DeliveryDate"].ToString() != "")
{
model.DeliveryDate = DateTime.Parse(row["DeliveryDate"].ToString());
}
if (row["Qty"] != null)
{
model.Qty = row["Qty"].ToString();
}
if (row["PN"] != null)
{
model.PN = row["PN"].ToString();
}
if (row["PO"] != null)
{
model.PO = row["PO"].ToString();
}
if (row["WorkDepartment"] != null)
{
model.WorkDepartment = row["WorkDepartment"].ToString();
}
if (row["WorkShop"] != null)
{
model.WorkShop = row["WorkShop"].ToString();
}
if (row["State"] != null)
{
model.State = row["State"].ToString();
}
if (row["Relax"] != null && row["Relax"].ToString() != "")
{
model.Relax = double.Parse(row["Relax"].ToString());
}
if (row["IsRemind"] != null && row["IsRemind"].ToString() != "")
{
if ((row["IsRemind"].ToString() == "1") || (row["IsRemind"].ToString().ToLower() == "true"))
{
model.IsRemind = true;
}
else
{
model.IsRemind = false;
}
}
if (row["ID_Key"] != null && row["ID_Key"].ToString() != "")
{
model.ID_Key = decimal.Parse(row["ID_Key"].ToString());
}
}
BPM_Product product = new BPM_Product();
model.Product = product.GetModel(model.ProductID); //产品信息
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MES.Server.Model.BPM_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BPM_Order(");
strSql.Append("OrderID,ClientName,ProductID,ProductName,Spec,Count,TotalWorkHoursStandard,StartDate,EndDate,ActualStartDate,ActualEndDate,DeliveryDate,Qty,PN,PO,WorkDepartment,WorkShop,State,Relax,IsRemind)");
strSql.Append(" values (");
strSql.Append("@OrderID,@ClientName,@ProductID,@ProductName,@Spec,@Count,@TotalWorkHoursStandard,@StartDate,@EndDate,@ActualStartDate,@ActualEndDate,@DeliveryDate,@Qty,@PN,@PO,@WorkDepartment,@WorkShop,@State,@Relax,@IsRemind)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.VarChar, 50),
new SqlParameter("@ClientName", SqlDbType.VarChar, 50),
new SqlParameter("@ProductID", SqlDbType.VarChar, 50),
new SqlParameter("@ProductName", SqlDbType.VarChar, 100),
new SqlParameter("@Spec", SqlDbType.VarChar, 300),
new SqlParameter("@Count", SqlDbType.Float, 8),
new SqlParameter("@TotalWorkHoursStandard", SqlDbType.Float, 8),
new SqlParameter("@StartDate", SqlDbType.VarChar, 50),
new SqlParameter("@EndDate", SqlDbType.VarChar, 50),
new SqlParameter("@ActualStartDate", SqlDbType.Char, 8),
new SqlParameter("@ActualEndDate", SqlDbType.Char, 8),
new SqlParameter("@DeliveryDate", SqlDbType.DateTime),
new SqlParameter("@Qty", SqlDbType.VarChar, 50),
new SqlParameter("@PN", SqlDbType.VarChar, 50),
new SqlParameter("@PO", SqlDbType.VarChar, 50),
new SqlParameter("@WorkDepartment", SqlDbType.VarChar, 50),
new SqlParameter("@WorkShop", SqlDbType.VarChar, 50),
new SqlParameter("@State", SqlDbType.VarChar, 50),
new SqlParameter("@Relax", SqlDbType.Decimal, 9),
new SqlParameter("@IsRemind", SqlDbType.Bit, 1)
};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.ClientName;
parameters[2].Value = model.ProductID;
parameters[3].Value = model.ProductName;
parameters[4].Value = model.Spec;
parameters[5].Value = model.Count;
parameters[6].Value = model.TotalWorkHoursStandard;
parameters[7].Value = model.StartDate;
parameters[8].Value = model.EndDate;
parameters[9].Value = model.ActualStartDate;
parameters[10].Value = model.ActualEndDate;
parameters[11].Value = model.DeliveryDate;
parameters[12].Value = model.Qty;
parameters[13].Value = model.PN;
parameters[14].Value = model.PO;
parameters[15].Value = model.WorkDepartment;
parameters[16].Value = model.WorkShop;
parameters[17].Value = model.State;
parameters[18].Value = model.Relax;
parameters[19].Value = model.IsRemind;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MES.Server.Model.BPM_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BPM_Order set ");
strSql.Append("ClientName=@ClientName,");
strSql.Append("ProductID=@ProductID,");
strSql.Append("ProductName=@ProductName,");
strSql.Append("Spec=@Spec,");
strSql.Append("Count=@Count,");
strSql.Append("TotalWorkHoursStandard=@TotalWorkHoursStandard,");
strSql.Append("StartDate=@StartDate,");
strSql.Append("EndDate=@EndDate,");
strSql.Append("ActualStartDate=@ActualStartDate,");
strSql.Append("ActualEndDate=@ActualEndDate,");
strSql.Append("DeliveryDate=@DeliveryDate,");
strSql.Append("Qty=@Qty,");
strSql.Append("PN=@PN,");
strSql.Append("PO=@PO,");
strSql.Append("WorkDepartment=@WorkDepartment,");
strSql.Append("WorkShop=@WorkShop,");
strSql.Append("State=@State,");
strSql.Append("Relax=@Relax,");
strSql.Append("IsRemind=@IsRemind");
strSql.Append(" where OrderID=@OrderID");
SqlParameter[] parameters =
{
new SqlParameter("@ClientName", SqlDbType.VarChar, 50),
new SqlParameter("@ProductID", SqlDbType.VarChar, 50),
new SqlParameter("@ProductName", SqlDbType.VarChar, 100),
new SqlParameter("@Spec", SqlDbType.VarChar, 300),
new SqlParameter("@Count", SqlDbType.Float, 8),
new SqlParameter("@TotalWorkHoursStandard", SqlDbType.Float, 8),
new SqlParameter("@StartDate", SqlDbType.VarChar, 50),
new SqlParameter("@EndDate", SqlDbType.VarChar, 50),
new SqlParameter("@ActualStartDate", SqlDbType.Char, 8),
new SqlParameter("@ActualEndDate", SqlDbType.Char, 8),
new SqlParameter("@DeliveryDate", SqlDbType.DateTime),
new SqlParameter("@Qty", SqlDbType.VarChar, 50),
new SqlParameter("@PN", SqlDbType.VarChar, 50),
new SqlParameter("@PO", SqlDbType.VarChar, 50),
new SqlParameter("@WorkDepartment", SqlDbType.VarChar, 50),
new SqlParameter("@WorkShop", SqlDbType.VarChar, 50),
new SqlParameter("@State", SqlDbType.VarChar, 50),
new SqlParameter("@Relax", SqlDbType.Decimal, 9),
new SqlParameter("@IsRemind", SqlDbType.Bit, 1),
new SqlParameter("@OrderID", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.ClientName;
parameters[1].Value = model.ProductID;
parameters[2].Value = model.ProductName;
parameters[3].Value = model.Spec;
parameters[4].Value = model.Count;
parameters[5].Value = model.TotalWorkHoursStandard;
parameters[6].Value = model.StartDate;
parameters[7].Value = model.EndDate;
parameters[8].Value = model.ActualStartDate;
parameters[9].Value = model.ActualEndDate;
parameters[10].Value = model.DeliveryDate;
parameters[11].Value = model.Qty;
parameters[12].Value = model.PN;
parameters[13].Value = model.PO;
parameters[14].Value = model.WorkDepartment;
parameters[15].Value = model.WorkShop;
parameters[16].Value = model.State;
parameters[17].Value = model.Relax;
parameters[18].Value = model.IsRemind;
parameters[19].Value = model.OrderID;
parameters[20].Value = model.ID_Key;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
