/// <summary>
/// 视图类转实体类
/// </summary>
/// <param name="view">视图类</param>
/// <returns>实体类</returns>
private Model.TableModel.Mpo_item View2Model(ModelView.MpoItemView view)
{
Model.TableModel.Mpo_item model = new Model.TableModel.Mpo_item();
if (string.IsNullOrEmpty(view.id))
{
model.id = Common.Md5Operate.CreateGuidId();
}
else
{
model.id = view.id;
}
model.status_name = view.status_name;
model.status_no = string.IsNullOrEmpty(view.status_no) ? "310" : view.status_no;
GlobalDataCtrl globalDataCtrl = new GlobalDataCtrl();
model.serial_no = string.IsNullOrEmpty(view.serial_no) ? globalDataCtrl.GetNextNoByTblName("mpo_item") : view.serial_no;
model.item_no = model.serial_no;
model.part_no = string.IsNullOrEmpty(view.part_no) ? "PartNo" : view.part_no;
model.mpo_no = string.IsNullOrEmpty(view.mpo_no) ? "MpoNo" : view.mpo_no;
decimal tmpDecimal = 0;
model.item_qty = string.IsNullOrEmpty(view.item_qty) ? 1.0M : (decimal.TryParse(view.item_qty, out tmpDecimal) ? tmpDecimal : 1.0M);
DateTime tmpDt = DateTime.Now;
model.hope_product_time = string.IsNullOrEmpty(view.hope_product_time) ? (DateTime?)null : (DateTime.TryParse(view.hope_product_time, out tmpDt) ? tmpDt : (DateTime?)null);
model.print_time = string.IsNullOrEmpty(view.print_time) ? model.hope_product_time : (DateTime.TryParse(view.hope_product_time, out tmpDt) ? tmpDt : model.hope_product_time);
return(model);
}
/// <summary>
/// 插入订单详情
/// </summary>
/// <param name="rows">订单行</param>
/// <returns>数据影响行数</returns>
private int InsertMpoItem(List <DataRow> rows)
{
if (rows == null)
{
return(-1);
}
if (rows.Count <= 0)
{
return(-1);
}
string mpoNo = rows[0].Field <string>("ProductOrder");
string partNo = rows[0].Field <string>("CprReference");
List <Model.TableModel.Mpo_item> modelList = new List <Model.TableModel.Mpo_item>();
foreach (DataRow item in rows)
{
Model.TableModel.Mpo_item model = new Model.TableModel.Mpo_item();
model.id = Common.Md5Operate.CreateGuidId();
model.item_no = item.Field <string>("SerialNo");
model.item_qty = 1;
model.mpo_no = mpoNo;
model.part_no = partNo;
model.serial_no = item.Field <string>("SerialNo");
model.status_name = "已确认";
model.status_no = "310";
DateTime dt = RowToDateTime(item);
model.hope_product_time = dt;
model.print_time = dt;
modelList.Add(model);
}
return(LocalDbServer.QueryInt <Model.TableModel.Mpo_item>("Insert", modelList));
}
/// <summary>
/// 数据更新
/// </summary>
/// <param name="newValue">更新后对象</param>
/// <returns>影响记录条数</returns>
public int Update(ModelView.MpoItemView newValue)
{
Model.TableModel.Mpo_item model = View2Model(newValue);
List <Model.TableModel.Mpo_item> modelList = new List <Model.TableModel.Mpo_item>();
modelList.Add(model);
return(DbEngine.QueryInt <Model.TableModel.Mpo_item>("update", modelList));
}
/// <summary>
/// 更新操作
/// </summary>
/// <param name="listNewValue">更新后的视图模板类的集合</param>
/// <returns>影响记录条数</returns>
public int Update(List <ModelView.MpoItemView> listNewValue)
{
List <Model.TableModel.Mpo_item> modelList = new List <Model.TableModel.Mpo_item>();
foreach (ModelView.MpoItemView item in listNewValue)
{
Model.TableModel.Mpo_item model = View2Model(item);
modelList.Add(model);
}
return(DbEngine.QueryInt <Model.TableModel.Mpo_item>("update", modelList));
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="oldValues">要删除的多个值</param>
/// <returns>影响记录条数</returns>
public int Delete(List <ModelView.MpoItemView> oldValues)
{
List <Model.TableModel.Mpo_item> modelList = new List <Model.TableModel.Mpo_item>();
foreach (ModelView.MpoItemView item in oldValues)
{
Model.TableModel.Mpo_item model = View2Model(item);
modelList.Add(model);
}
return(DbEngine.QueryInt <Model.TableModel.Mpo_item>("Delete", modelList));
}
/// <summary>
/// 实体类转视图类
/// </summary>
/// <param name="model">实体类</param>
/// <returns>视图类</returns>
private ModelView.MpoItemView Model2View(Model.TableModel.Mpo_item model)
{
ModelView.MpoItemView view = new ModelView.MpoItemView();
view.id = model.id;
view.status_name = model.status_name;
view.status_no = model.status_no;
view.item_qty = decimal.Round(model.item_qty, MidpointRounding.AwayFromZero).ToString();
view.mpo_no = model.mpo_no;
view.item_no = model.item_no;
view.serial_no = model.serial_no;
view.part_no = model.part_no;
view.hope_product_time = model.hope_product_time.HasValue?((DateTime)model.hope_product_time).ToString("yyyy-MM-dd HH:mm:ss.fff"):string.Empty;
view.print_time = model.print_time.HasValue ? ((DateTime)model.print_time).ToString("yyyy-MM-dd HH:mm:ss.fff") : string.Empty;
return(view);
}