/// <summary>
/// 编辑原材料报废上报表
/// </summary>
/// <param name="user"></param>
/// <param name="error"></param>
/// <returns></returns>
public static bool EditMarerialScrapLog(MarerialScrapLog marerialscraplog, ref string error)
{
sql = string.Format(@" update MarerialScrapLog set CreateTime ='{0}',ProductNumber ='{1}',ScrapDate ='{2}',Team ='{3}',Count ='{4}',
ResponsiblePerson='{5}',ScrapReason ='{6}',Remark ='{7}',MaterialNumber ='{8}' where Id='{9}' ",
marerialscraplog.CreateTime, marerialscraplog.ProductNumber, marerialscraplog.ScrapDate, marerialscraplog.Team,
marerialscraplog.Count, marerialscraplog.ResponsiblePerson, marerialscraplog.ScrapReason, marerialscraplog.Remark, marerialscraplog.MaterialNumber, marerialscraplog.Id);
return(SqlHelper.ExecuteSql(sql, ref error));
}
/// <summary>
/// DataTable 转对象
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static MarerialScrapLog ConvertDataTableToModel(string sql)
{
error = string.Empty;
DataTable dt = SqlHelper.GetTable(sql, ref error);
DataRow dr = dt.Rows[0];
MarerialScrapLog marerialscraplog = new MarerialScrapLog();
marerialscraplog.Id = dr["Id"] == null ? "" : dr["Id"].ToString();
marerialscraplog.CreateTime = dr["CreateTime"] == null ? "" : dr["CreateTime"].ToString();
marerialscraplog.ProductNumber = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString();
marerialscraplog.MaterialNumber = dr["MaterialNumber"] == null ? "" : dr["MaterialNumber"].ToString();
marerialscraplog.ScrapDate = dr["ScrapDate"] == null ? "" : dr["ScrapDate"].ToString();
marerialscraplog.Team = dr["Team"] == null ? "" : dr["Team"].ToString();
marerialscraplog.Count = dr["Count"] == null ? "" : dr["Count"].ToString();
marerialscraplog.ResponsiblePerson = dr["ResponsiblePerson"] == null ? "" : dr["ResponsiblePerson"].ToString();
marerialscraplog.ScrapReason = dr["ScrapReason"] == null ? "" : dr["ScrapReason"].ToString();
marerialscraplog.Remark = dr["Remark"] == null ? "" : dr["Remark"].ToString();
return(marerialscraplog);
}
