/// <summary>
/// 对象JD_IcItemPlanBGApply_log明细
/// 编写人：ywk
/// 编写日期：2018/9/26 星期三
/// </summary>
public JD_IcItemPlanBGApply_log Detail(int ItemID)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("SELECT * FROM JD_IcItemPlanBGApply_log WHERE ItemID = @m_ItemID", con);
con.Open();
cmd.Parameters.Add(new SqlParameter("@m_ItemID", SqlDbType.Int, 0)).Value = ItemID;
JD_IcItemPlanBGApply_log myDetail = new JD_IcItemPlanBGApply_log();
SqlDataReader myReader = cmd.ExecuteReader();
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["ItemID"]))
{
myDetail.ItemID = Convert.ToInt32(myReader["ItemID"]);
}
if (!Convert.IsDBNull(myReader["TaskID"]))
{
myDetail.TaskID = Convert.ToInt32(myReader["TaskID"]);
}
if (!Convert.IsDBNull(myReader["FItemID"]))
{
myDetail.FItemID = Convert.ToInt32(myReader["FItemID"]);
}
if (!Convert.IsDBNull(myReader["FNumber"]))
{
myDetail.FNumber = Convert.ToString(myReader["FNumber"]);
}
if (!Convert.IsDBNull(myReader["FModel"]))
{
myDetail.FModel = Convert.ToString(myReader["FModel"]);
}
if (!Convert.IsDBNull(myReader["SNumber"]))
{
myDetail.SNumber = Convert.ToString(myReader["SNumber"]);
}
if (!Convert.IsDBNull(myReader["Requester"]))
{
myDetail.Requester = Convert.ToString(myReader["Requester"]);
}
if (!Convert.IsDBNull(myReader["RequestDate"]))
{
myDetail.RequestDate = Convert.ToDateTime(myReader["RequestDate"]);
}
if (!Convert.IsDBNull(myReader["fqtymin"]))
{
myDetail.fqtymin = Convert.ToDecimal(myReader["fqtymin"]);
}
if (!Convert.IsDBNull(myReader["fqtyminnew"]))
{
myDetail.fqtyminnew = Convert.ToDecimal(myReader["fqtyminnew"]);
}
if (!Convert.IsDBNull(myReader["FBatchAppendQty"]))
{
myDetail.FBatchAppendQty = Convert.ToDecimal(myReader["FBatchAppendQty"]);
}
if (!Convert.IsDBNull(myReader["FBatchAppendQtynew"]))
{
myDetail.FBatchAppendQtynew = Convert.ToDecimal(myReader["FBatchAppendQtynew"]);
}
if (!Convert.IsDBNull(myReader["FFixLeadTime"]))
{
myDetail.FFixLeadTime = Convert.ToInt32(myReader["FFixLeadTime"]);
}
if (!Convert.IsDBNull(myReader["FFixLeadTimenew"]))
{
myDetail.FFixLeadTimenew = Convert.ToInt32(myReader["FFixLeadTimenew"]);
}
if (!Convert.IsDBNull(myReader["Fsecinv"]))
{
myDetail.Fsecinv = Convert.ToDecimal(myReader["Fsecinv"]);
}
if (!Convert.IsDBNull(myReader["FsecinvNew"]))
{
myDetail.FsecinvNew = Convert.ToDecimal(myReader["FsecinvNew"]);
}
if (!Convert.IsDBNull(myReader["ProductLT"]))
{
myDetail.ProductLT = Convert.ToInt32(myReader["ProductLT"]);
}
if (!Convert.IsDBNull(myReader["ProductLTnew"]))
{
myDetail.ProductLTnew = Convert.ToInt32(myReader["ProductLTnew"]);
}
if (!Convert.IsDBNull(myReader["PPQ"]))
{
myDetail.PPQ = Convert.ToDouble(myReader["PPQ"]);
}
if (!Convert.IsDBNull(myReader["PPQnew"]))
{
myDetail.PPQnew = Convert.ToDouble(myReader["PPQnew"]);
}
if (!Convert.IsDBNull(myReader["PlanRemarks"]))
{
myDetail.PlanRemarks = Convert.ToString(myReader["PlanRemarks"]);
}
if (!Convert.IsDBNull(myReader["PlanRemarksnew"]))
{
myDetail.PlanRemarksnew = Convert.ToString(myReader["PlanRemarksnew"]);
}
if (!Convert.IsDBNull(myReader["MOQ"]))
{
myDetail.MOQ = Convert.ToInt32(myReader["MOQ"]);
}
if (!Convert.IsDBNull(myReader["MOQnew"]))
{
myDetail.MOQnew = Convert.ToInt32(myReader["MOQnew"]);
}
if (!Convert.IsDBNull(myReader["IsSMI"]))
{
myDetail.IsSMI = Convert.ToInt32(myReader["IsSMI"]);
}
if (!Convert.IsDBNull(myReader["Ferpclsid"]))
{
myDetail.Ferpclsid = Convert.ToInt32(myReader["Ferpclsid"]);
}
if (!Convert.IsDBNull(myReader["UpdateTime"]))
{
myDetail.UpdateTime = Convert.ToDateTime(myReader["UpdateTime"]);
}
if (!Convert.IsDBNull(myReader["IsUpdate"]))
{
myDetail.IsUpdate = Convert.ToInt32(myReader["IsUpdate"]);
}
}
myReader.Close();
cmd.Dispose();
con.Close();
con.Dispose();
return(myDetail);
}
/// <summary>
/// 更新JD_IcItemPlanBGApply_log对象
/// 编写人：ywk
/// 编写日期：2018/9/26 星期三
/// </summary>
public void Update(JD_IcItemPlanBGApply_log model)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("UPDATE JD_IcItemPlanBGApply_log SET TaskID = @m_TaskID,FItemID = @m_FItemID,FNumber = @m_FNumber,FModel = @m_FModel,SNumber = @m_SNumber,Requester = @m_Requester,RequestDate = @m_RequestDate,fqtymin = @m_fqtymin,fqtyminnew = @m_fqtyminnew,FBatchAppendQty = @m_FBatchAppendQty,FBatchAppendQtynew = @m_FBatchAppendQtynew,FFixLeadTime = @m_FFixLeadTime,FFixLeadTimenew = @m_FFixLeadTimenew,Fsecinv = @m_Fsecinv,FsecinvNew = @m_FsecinvNew,ProductLT = @m_ProductLT,ProductLTnew = @m_ProductLTnew,PPQ = @m_PPQ,PPQnew = @m_PPQnew,PlanRemarks = @m_PlanRemarks,PlanRemarksnew = @m_PlanRemarksnew,MOQ = @m_MOQ,MOQnew = @m_MOQnew,IsSMI = @m_IsSMI,Ferpclsid = @m_Ferpclsid,UpdateTime = @m_UpdateTime,IsUpdate = @m_IsUpdate WHERE ItemID = @m_ItemID", con);
con.Open();
if (model.TaskID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_TaskID", SqlDbType.Int, 0)).Value = model.TaskID;
}
if (model.FItemID == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FItemID", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FItemID", SqlDbType.Int, 0)).Value = model.FItemID;
}
if (model.FNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FNumber", SqlDbType.NVarChar, 50)).Value = model.FNumber;
}
if (model.FModel == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FModel", SqlDbType.NText, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FModel", SqlDbType.NText, 0)).Value = model.FModel;
}
if (model.SNumber == null)
{
cmd.Parameters.Add(new SqlParameter("@m_SNumber", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_SNumber", SqlDbType.NVarChar, 50)).Value = model.SNumber;
}
if (model.Requester == null)
{
cmd.Parameters.Add(new SqlParameter("@m_Requester", SqlDbType.NVarChar, 50)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_Requester", SqlDbType.NVarChar, 50)).Value = model.Requester;
}
if (model.RequestDate == new DateTime())
{
cmd.Parameters.Add(new SqlParameter("@m_RequestDate", SqlDbType.DateTime, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_RequestDate", SqlDbType.DateTime, 0)).Value = model.RequestDate;
}
if (model.fqtymin == null)
{
cmd.Parameters.Add(new SqlParameter("@m_fqtymin", SqlDbType.Decimal, 18)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_fqtymin", SqlDbType.Decimal, 18)).Value = model.fqtymin;
}
if (model.fqtyminnew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_fqtyminnew", SqlDbType.Decimal, 18)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_fqtyminnew", SqlDbType.Decimal, 18)).Value = model.fqtyminnew;
}
if (model.FBatchAppendQty == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FBatchAppendQty", SqlDbType.Decimal, 18)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FBatchAppendQty", SqlDbType.Decimal, 18)).Value = model.FBatchAppendQty;
}
if (model.FBatchAppendQtynew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FBatchAppendQtynew", SqlDbType.Decimal, 18)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FBatchAppendQtynew", SqlDbType.Decimal, 18)).Value = model.FBatchAppendQtynew;
}
if (model.FFixLeadTime == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FFixLeadTime", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FFixLeadTime", SqlDbType.Int, 0)).Value = model.FFixLeadTime;
}
if (model.FFixLeadTimenew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FFixLeadTimenew", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FFixLeadTimenew", SqlDbType.Int, 0)).Value = model.FFixLeadTimenew;
}
if (model.Fsecinv == null)
{
cmd.Parameters.Add(new SqlParameter("@m_Fsecinv", SqlDbType.Decimal, 18)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_Fsecinv", SqlDbType.Decimal, 18)).Value = model.Fsecinv;
}
if (model.FsecinvNew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_FsecinvNew", SqlDbType.Decimal, 18)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_FsecinvNew", SqlDbType.Decimal, 18)).Value = model.FsecinvNew;
}
if (model.ProductLT == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ProductLT", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ProductLT", SqlDbType.Int, 0)).Value = model.ProductLT;
}
if (model.ProductLTnew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_ProductLTnew", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_ProductLTnew", SqlDbType.Int, 0)).Value = model.ProductLTnew;
}
if (model.PPQ == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PPQ", SqlDbType.Float, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PPQ", SqlDbType.Float, 0)).Value = model.PPQ;
}
if (model.PPQnew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PPQnew", SqlDbType.Float, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PPQnew", SqlDbType.Float, 0)).Value = model.PPQnew;
}
if (model.PlanRemarks == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PlanRemarks", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PlanRemarks", SqlDbType.NVarChar, 100)).Value = model.PlanRemarks;
}
if (model.PlanRemarksnew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_PlanRemarksnew", SqlDbType.NVarChar, 100)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_PlanRemarksnew", SqlDbType.NVarChar, 100)).Value = model.PlanRemarksnew;
}
if (model.MOQ == null)
{
cmd.Parameters.Add(new SqlParameter("@m_MOQ", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_MOQ", SqlDbType.Int, 0)).Value = model.MOQ;
}
if (model.MOQnew == null)
{
cmd.Parameters.Add(new SqlParameter("@m_MOQnew", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_MOQnew", SqlDbType.Int, 0)).Value = model.MOQnew;
}
if (model.IsSMI == null)
{
cmd.Parameters.Add(new SqlParameter("@m_IsSMI", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_IsSMI", SqlDbType.Int, 0)).Value = model.IsSMI;
}
if (model.Ferpclsid == null)
{
cmd.Parameters.Add(new SqlParameter("@m_Ferpclsid", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_Ferpclsid", SqlDbType.Int, 0)).Value = model.Ferpclsid;
}
if (model.UpdateTime == new DateTime())
{
cmd.Parameters.Add(new SqlParameter("@m_UpdateTime", SqlDbType.DateTime, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_UpdateTime", SqlDbType.DateTime, 0)).Value = model.UpdateTime;
}
if (model.IsUpdate == null)
{
cmd.Parameters.Add(new SqlParameter("@m_IsUpdate", SqlDbType.Int, 0)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@m_IsUpdate", SqlDbType.Int, 0)).Value = model.IsUpdate;
}
cmd.Parameters.Add(new SqlParameter("@m_ItemID", SqlDbType.Int, 0)).Value = model.ItemID;
try { cmd.ExecuteNonQuery(); }
catch (Exception e) { throw new Exception(e.ToString()); }
cmd.Dispose();
con.Close();
con.Dispose();
}
