/// <summary>
/// 视图类转实体类
/// </summary>
/// <param name="view">视图类</param>
/// <returns>实体类</returns>
private Model.TableModel.Sys_product_record_setting View2Model(ModelView.SysProductRecordSettingView view)
{
Model.TableModel.Sys_product_record_setting model = new Model.TableModel.Sys_product_record_setting();
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;
DateTime dt = DateTime.Now;
model.crt_time = DateTime.TryParse(view.crt_time, out dt) ? dt : DateTime.Now;
model.crt_user_no = string.IsNullOrEmpty(view.crt_user_no) ? "Server" : view.crt_user_no;
model.crt_user_name = view.crt_user_name;
GlobalDataCtrl globalDataCtrl = new GlobalDataCtrl();
model.product_record_no = string.IsNullOrEmpty(view.product_record_no) ? globalDataCtrl.GetNextNoByTblName("sys_product_record_setting") : view.product_record_no;
model.product_record_name = string.IsNullOrEmpty(view.product_record_name)?"ProductRecordName":view.product_record_name;
model.eqm_no = string.IsNullOrEmpty(view.eqm_no)?"EqmNo":view.eqm_no;
int intTmp = 0;
model.row_index = string.IsNullOrEmpty(view.row_index) ? 0 : (int.TryParse(view.row_index, out intTmp) ? intTmp : 0);
model.col_index = string.IsNullOrEmpty(view.col_index) ? 0 : (int.TryParse(view.col_index, out intTmp) ? intTmp : 0);
return(model);
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="oldValue">要删除的值</param>
/// <returns>影响记录条数</returns>
public int Delete(ModelView.SysProductRecordSettingView oldValue)
{
Model.TableModel.Sys_product_record_setting model = View2Model(oldValue);
List <Model.TableModel.Sys_product_record_setting> modelList = new List <Model.TableModel.Sys_product_record_setting>();
modelList.Add(model);
return(DbEngine.QueryInt <Model.TableModel.Sys_product_record_setting>("Delete", modelList));
}
/// <summary>
/// 数据插入
/// </summary>
/// <param name="newValue">新插入的值</param>
/// <returns>影响记录条数</returns>
public int Insert(ModelView.SysProductRecordSettingView newValue)
{
Model.TableModel.Sys_product_record_setting model = View2Model(newValue);
List <Model.TableModel.Sys_product_record_setting> modelList = new List <Model.TableModel.Sys_product_record_setting>();
modelList.Add(model);
return(DbEngine.QueryInt <Model.TableModel.Sys_product_record_setting>("Insert", modelList));
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="oldValues">要删除的多个值</param>
/// <returns>影响记录条数</returns>
public int Delete(List <ModelView.SysProductRecordSettingView> oldValues)
{
List <Model.TableModel.Sys_product_record_setting> modelList = new List <Model.TableModel.Sys_product_record_setting>();
foreach (ModelView.SysProductRecordSettingView item in oldValues)
{
Model.TableModel.Sys_product_record_setting model = View2Model(item);
modelList.Add(model);
}
return(DbEngine.QueryInt <Model.TableModel.Sys_product_record_setting>("Delete", modelList));
}
/// <summary>
/// 实体类转视图类
/// </summary>
/// <param name="model">实体类</param>
/// <returns>视图类</returns>
private ModelView.SysProductRecordSettingView Model2View(Model.TableModel.Sys_product_record_setting model)
{
ModelView.SysProductRecordSettingView view = new ModelView.SysProductRecordSettingView();
view.id = model.id;
view.status_name = model.status_name;
view.status_no = model.status_no;
view.crt_time = model.crt_time.ToString("yyyy-MM-dd HH:mm:ss.fff");
view.crt_user_no = model.crt_user_no;
view.crt_user_name = model.crt_user_name;
view.product_record_no = model.product_record_no;
view.product_record_name = model.product_record_name;
view.eqm_no = model.eqm_no;
view.row_index = model.row_index.ToString();
view.col_index = model.col_index.ToString();
return(view);
}
/// <summary>
/// 行记录处理为记录信息列表
/// </summary>
/// <param name="dataRow">行记录</param>
/// <returns>记录信息列表</returns>
private List <ModelView.ProductRecordView> ProcessDataRow(DataRow dataRow)
{
List <ModelView.ProductRecordView> listRes = new List <ModelView.ProductRecordView>();
SysProductRecordSettingCtrl sysProductRecordSettingCtrl = new SysProductRecordSettingCtrl();
List <Model.TableModel.Sys_product_record_setting> listSettings = null;
try
{
listSettings = sysProductRecordSettingCtrl.GetModelList("status_no='310'");
}
catch (Exception)
{
listSettings = null;
}
if (listSettings == null)
{
return(null);
}
if (listSettings.Count <= 0)
{
return(null);
}
string serialNo = dataRow.Field <string>("serial_no");
string eqmNo = dataRow.Field <string>("eqm_no");
string workerName = dataRow.Field <string>("worker_name");
string crtTime = dataRow.Field <DateTime>("crt_time").ToString("yyyy-MM-dd");
string itemName = dataRow.Field <string>("information");
string itemValue = dataRow.Field <string>("information_value");
Model.TableModel.Sys_product_record_setting setting1 = listSettings.Find(a => a.product_record_name == "日期" && a.eqm_no == eqmNo);
if (setting1 != null)
{
ModelView.ProductRecordView model1 = new ModelView.ProductRecordView();
model1.serial_no = serialNo;
model1.item_name = "日期";
model1.item_value = crtTime;
model1.eqm_no = eqmNo;
model1.row_index = setting1.row_index;
model1.col_index = setting1.col_index;
if (!listRes.Contains(model1))
{
listRes.Add(model1);
}
}
Model.TableModel.Sys_product_record_setting setting2 = listSettings.Find(a => a.product_record_name == "作业者" && a.eqm_no == eqmNo);
if (setting2 != null)
{
ModelView.ProductRecordView model2 = new ModelView.ProductRecordView();
model2.serial_no = serialNo;
model2.item_name = "作业者";
model2.item_value = workerName;
model2.eqm_no = eqmNo;
model2.row_index = setting2.row_index;
model2.col_index = setting2.col_index;
if (!listRes.Contains(model2))
{
listRes.Add(model2);
}
}
Model.TableModel.Sys_product_record_setting setting3 = listSettings.Find(a => a.product_record_name == itemName && a.eqm_no == eqmNo);
if (setting3 != null)
{
ModelView.ProductRecordView model3 = new ModelView.ProductRecordView();
model3.serial_no = serialNo;
model3.item_name = itemName;
model3.item_value = itemValue;
model3.eqm_no = eqmNo;
model3.row_index = setting3.row_index;
model3.col_index = setting3.col_index;
if (!listRes.Contains(model3))
{
listRes.Add(model3);
}
}
return(listRes);
}
