/// <summary> 创建出入库单配件信息
/// </summary>
/// <param name="stock_inout_id">出入库单ID</param>
/// <param name="parts_model">采购开单配件信息</param>
bool CreateIntoPartsStock(string stock_inout_id, tb_parts_purchase_billing_p parts_model, string billid, string billno)
{
tb_parts_stock_inout_p PartsInoutModel = new tb_parts_stock_inout_p();
Dictionary<string, string> dicParam = new Dictionary<string, string>();//参数
PartsInoutModel.stock_inout_parts_id = Guid.NewGuid().ToString();
PartsInoutModel.stock_inout_id = stock_inout_id;
if (!string.IsNullOrEmpty(parts_model.wh_id))
{
PartsInoutModel.wh_id = parts_model.wh_id;
PartsInoutModel.wh_name = parts_model.wh_name;
}
PartsInoutModel.num = parts_model.num;
PartsInoutModel.parts_code = parts_model.parts_code;
PartsInoutModel.parts_name = parts_model.parts_name;
PartsInoutModel.drawing_num = parts_model.drawing_num;
if (!string.IsNullOrEmpty(parts_model.unit_id))
{
PartsInoutModel.unit = parts_model.unit_id;
PartsInoutModel.unit_name = parts_model.unit_name;
}
PartsInoutModel.parts_brand = parts_model.parts_brand;
PartsInoutModel.counts = parts_model.business_counts;//业务数量
PartsInoutModel.parts_barcode = parts_model.parts_barcode;//条码
PartsInoutModel.car_parts_code = parts_model.car_factory_code;//车厂编码
if(parts_model.make_date>0)
{
PartsInoutModel.make_date = parts_model.make_date;//生产日期
}
if (parts_model.arrival_date > 0)
{
PartsInoutModel.validity_date = parts_model.arrival_date;//到期、有效日期
}
PartsInoutModel.is_gift = parts_model.is_gift;
PartsInoutModel.remark = parts_model.remark;
PartsInoutModel.create_by = GlobalStaticObj.UserID;
PartsInoutModel.create_name = GlobalStaticObj.UserName;
PartsInoutModel.create_time = Common.LocalDateTimeToUtcLong(DateTime.Now);
PartsInoutModel.reference_billid = billid;
PartsInoutModel.reference_billno = billno;
PartsInoutModel.model = parts_model.model;
foreach (PropertyInfo info in PartsInoutModel.GetType().GetProperties())
{
string name = info.Name;
object value = info.GetValue(PartsInoutModel, null);
dicParam.Add(name, value == null ? "" : value.ToString());
}
return DBHelper.Submit_AddOrEdit("出入库配件表添加信息", "tb_parts_stock_inout_p", "stock_inout_parts_id", "", dicParam);
}
/// <summary> 创建出入库单配件信息
/// </summary>
/// <param name="stock_inout_id">出入库单ID</param>
/// <param name="parts_model">采购开单配件信息</param>
bool CreateIntoPartsStock(string stock_inout_id, tb_parts_sale_billing_p parts_model)
{
tb_parts_stock_inout_p PartsInoutModel = new tb_parts_stock_inout_p();
Dictionary<string, string> dicParam = new Dictionary<string, string>();//参数
PartsInoutModel.stock_inout_parts_id = Guid.NewGuid().ToString();
PartsInoutModel.stock_inout_id = stock_inout_id;
PartsInoutModel.wh_id = parts_model.wh_id;
PartsInoutModel.num = parts_model.num;
PartsInoutModel.parts_num = parts_model.parts_code;
PartsInoutModel.parts_name = parts_model.parts_name;
PartsInoutModel.drawing_num = parts_model.drawing_num;
PartsInoutModel.unit = parts_model.unit_id;
PartsInoutModel.unit_name = parts_model.unit_name;
PartsInoutModel.parts_brand = parts_model.parts_brand;
PartsInoutModel.count = parts_model.library_count;//出库数量
PartsInoutModel.is_gift = parts_model.is_gift;
PartsInoutModel.remark = parts_model.remark;
PartsInoutModel.create_by = GlobalStaticObj.UserID;
PartsInoutModel.create_name = GlobalStaticObj.UserName;
PartsInoutModel.create_time = Common.LocalDateTimeToUtcLong(DateTime.Now);
foreach (PropertyInfo info in PartsInoutModel.GetType().GetProperties())
{
string name = info.Name;
object value = info.GetValue(PartsInoutModel, null);
dicParam.Add(name, value == null ? "" : value.ToString());
}
return DBHelper.Submit_AddOrEdit("出入库配件表添加信息", "tb_parts_stock_inout_p", "stock_inout_parts_id", "", dicParam);
}