/// <summary>
/// 编辑原材料供应商属性
/// </summary>
/// <param name="user"></param>
/// <param name="error"></param>
/// <returns></returns>
public static bool EditMaterialSupplierProperty(MaterialSupplierProperty materialsupplierproperty, ref string error)
{
sql = string.Format(@" update MaterialSupplierProperty set SupplierMaterialNumber='{0}',SupplierId='{1}',
MinOrderQty='{2}',Remark='{3}' where MaterialNumber='{4}'", materialsupplierproperty.SupplierMaterialNumber,
materialsupplierproperty.SupplierId, materialsupplierproperty.MinOrderQty, materialsupplierproperty.Remark,
materialsupplierproperty.MaterialNumber
);
return(SqlHelper.ExecuteSql(sql, ref error));
}
/// <summary>
/// DataTable 转对象
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static MaterialSupplierProperty ConvertDataTableToModel(string sql)
{
error = string.Empty;
DataTable dt = SqlHelper.GetTable(sql, ref error);
DataRow dr = dt.Rows[0];
MaterialSupplierProperty materialsupplierproperty = new MaterialSupplierProperty();
materialsupplierproperty.MaterialNumber = dr["MaterialNumber"] == null ? "" : dr["MaterialNumber"].ToString();
materialsupplierproperty.SupplierMaterialNumber = dr["SupplierMaterialNumber"] == null ? "" : dr["SupplierMaterialNumber"].ToString();
materialsupplierproperty.SupplierId = dr["SupplierId"] == null ? "" : dr["SupplierId"].ToString();
materialsupplierproperty.MinOrderQty = dr["MinOrderQty"] == null ? "" : dr["MinOrderQty"].ToString();
materialsupplierproperty.Remark = dr["Remark"] == null ? "" : dr["Remark"].ToString();
return(materialsupplierproperty);
}
