public EntityBase Save(BLLContext context, EntityBase saveEntity, bool isAdd)
{
MES_BD_ZY mesBdZy = new MES_BD_ZY(MES_BD_ZY.Fields.GUID);
mesBdZy.Data = saveEntity.Data;
mesBdZy.EffectDataFields();
val.SaveValidate(context, mesBdZy, isAdd);
if (isAdd)
{
if (context.Type != "tree")
{
mesBdZy.GUID = Guid.NewGuid().ToString("N");
}
mesBdZy.AddUserInfo(context, isAdd);
mesBdZy.Validate();
mesBdZy.Insert(context.Transaction);
}
else
{
mesBdZy.AddUserInfo(context, isAdd);
mesBdZy.NotSave("CREATE_DATE,CREATE_USER");
mesBdZy.Validate();
mesBdZy.Update(context.Transaction);
}
return(mesBdZy);
}
public void Save(EciResponse ajax)
{
MES_BD_ZY item = new MES_BD_ZY();
item.GUID = PageHelper.Request(MES_BD_ZY.Fields.GUID);
item.GH = PageHelper.Request(MES_BD_ZY.Fields.GH);
item.NAME = PageHelper.Request(MES_BD_ZY.Fields.NAME);
item.CODE = PageHelper.Request(MES_BD_ZY.Fields.CODE);
item.STATUS = PageHelper.Request(MES_BD_ZY.Fields.STATUS);
EciRequest request = new EciRequest(MESService.MesBdZySave);
request.Entity = item;
request.IsAdd = PageHelper.Request("FLAG") == "Add";
if (request.IsAdd)
{
item.PARENTID = PageHelper.Request(MES_BD_ZY.Fields.PARENTID);
request.Type = "tree";
}
EciResponse response = SOA.Execute(request);
ajax.Data = response.Data;
}
public void Save(EciResponse ajax)
{
MES_BD_ZY item = new MES_BD_ZY();
item.GUID = PageHelper.Request(MES_BD_ZY.Fields.GUID);
item.GH = PageHelper.Request(MES_BD_ZY.Fields.GH);
item.NAME = PageHelper.Request(MES_BD_ZY.Fields.NAME);
item.CODE = PageHelper.Request(MES_BD_ZY.Fields.CODE);
item.STATUS = PageHelper.Request(MES_BD_ZY.Fields.STATUS);
item.TEL = PageHelper.Request(MES_BD_ZY.Fields.TEL);
item.ID_CARD = PageHelper.Request(MES_BD_ZY.Fields.ID_CARD);
item.KHYH = PageHelper.Request(MES_BD_ZY.Fields.KHYH);
item.KHM = PageHelper.Request(MES_BD_ZY.Fields.KHM);
item.BANK = PageHelper.Request(MES_BD_ZY.Fields.BANK);
item.WHCD = PageHelper.Request(MES_BD_ZY.Fields.WHCD);
item.BYXX = PageHelper.Request(MES_BD_ZY.Fields.BYXX);
item.BYZY = PageHelper.Request(MES_BD_ZY.Fields.BYZY);
item.BYNF = PageHelper.Request(MES_BD_ZY.Fields.BYNF);
item.PROVINCE = PageHelper.Request(MES_BD_ZY.Fields.PROVINCE);
item.CITY = PageHelper.Request(MES_BD_ZY.Fields.CITY);
item.ADDRESS = PageHelper.Request(MES_BD_ZY.Fields.ADDRESS);
item.MAIL = PageHelper.Request(MES_BD_ZY.Fields.MAIL);
item.REMARK = PageHelper.Request(MES_BD_ZY.Fields.REMARK);
item.JS1 = PageHelper.Request(MES_BD_ZY.Fields.JS1);
item.JS1_RELATION = PageHelper.Request(MES_BD_ZY.Fields.JS1_RELATION);
item.JS1_TEL = PageHelper.Request(MES_BD_ZY.Fields.JS1_TEL);
item.JS1_ADDRESS = PageHelper.Request(MES_BD_ZY.Fields.JS1_ADDRESS);
item.JS2 = PageHelper.Request(MES_BD_ZY.Fields.JS2);
item.JS2_RELATION = PageHelper.Request(MES_BD_ZY.Fields.JS2_RELATION);
item.JS2_TEL = PageHelper.Request(MES_BD_ZY.Fields.JS2_TEL);
item.JS2_ADDRESS = PageHelper.Request(MES_BD_ZY.Fields.JS2_ADDRESS);
item.JS3 = PageHelper.Request(MES_BD_ZY.Fields.JS3);
item.JS3_RELATION = PageHelper.Request(MES_BD_ZY.Fields.JS3_RELATION);
item.JS3_TEL = PageHelper.Request(MES_BD_ZY.Fields.JS3_TEL);
item.JS3_ADDRESS = PageHelper.Request(MES_BD_ZY.Fields.JS3_ADDRESS);
item.JS4 = PageHelper.Request(MES_BD_ZY.Fields.JS4);
item.JS4_RELATION = PageHelper.Request(MES_BD_ZY.Fields.JS4_RELATION);
item.JS4_TEL = PageHelper.Request(MES_BD_ZY.Fields.JS4_TEL);
item.JS4_ADDRESS = PageHelper.Request(MES_BD_ZY.Fields.JS4_ADDRESS);
item.CAR_NO = PageHelper.Request(MES_BD_ZY.Fields.CAR_NO);
item.CAR_TYPE = PageHelper.Request(MES_BD_ZY.Fields.CAR_TYPE);
item.PIC1 = PageHelper.Request(MES_BD_ZY.Fields.PIC1);
item.PIC1_PATH = PageHelper.Request(MES_BD_ZY.Fields.PIC1_PATH);
EciRequest request = new EciRequest(MESService.MesBdZySave);
request.Entity = item;
request.IsAdd = PageHelper.Request("FLAG") == "Add";
if (request.IsAdd)
{
item.PARENTID = PageHelper.Request(MES_BD_ZY.Fields.PARENTID);
request.Type = "tree";
}
EciResponse response = SOA.Execute(request);
ajax.Data = response.Data;
}
private void LoadTab(MES_BD_ZY zy)
{
if (zy.IsNull())
{
tabZy.Visible = false;
}
else
{
tabStatus.Url = "frmMesBdZyStatusEdit.aspx?key=" + this.key + "&code=" + this.txtCode.Text.Trim();
tabDoc.Url = "frmMesBdZyDocEdit.aspx?key=" + this.key + "&code=" + this.txtCode.Text.Trim();
}
}
private void LoadHeadRecord()
{
EciRequest request = new EciRequest(MESService.MesBdZyLoad);
request.Key = this.fguid;
EciResponse response = SOA.Execute(request);
MES_BD_ZY data = response.DataTable.ToEntity <MES_BD_ZY>();
if (!data.IsNull())
{
txtName.Text = data.NAME;
}
}
/// <summary>
/// 导入
/// </summary>
/// <param name="datatable"></param>
protected void DyUpload(DataSet ds)
{
MES_BD_ZY saveEntity = new MES_BD_ZY();
//DataSet hzqdDateSet = new DataSet();
//hzqdDateSet.Tables.Add(datatable);
//新增表头数据
EciRequest request = new EciRequest(MESService.MesBdZyImport);
request.Entity = saveEntity;
request.DataSet = ds;
EciResponse response = SOA.Execute(request);
response.Message.Tip();
}
private void LoadRecord()
{
EciRequest request = new EciRequest(MESService.MesBdZyLoad);
request.Key = this.key;
EciResponse response = SOA.Execute(request);
MES_BD_ZY data = response.DataTable.ToEntity <MES_BD_ZY>();
this.Bind(data);
LoadTab(data);
hidPic1Path.Value = data.PIC1_PATH;
hidPic1.Value = data.PIC1;
hidPIC2Path.Value = data.PIC2_PATH;
hidPIC2.Value = data.PIC2;
}
protected void btnSave_Click(object sender, EventArgs e)
{
EciRequest request = new EciRequest(MESService.MesBdZySave);
request.IsAdd = this.key.NullOrEmpty();
MES_BD_ZY saveEntity = new MES_BD_ZY();
request.Entity = saveEntity;
saveEntity.Data = this.GetEntityFromUI().Data;
saveEntity.GUID = this.key;
if (txtFileUpload.HasFile)
{
btnUpload_Click(sender, e);
saveEntity.PIC1_PATH = this.hidPic1Path.Value;
saveEntity.PIC1 = this.hidPic1.Value;
}
if (txtFileUpload2.HasFile)
{
btnUpload2_Click(sender, e);
saveEntity.PIC2_PATH = this.hidPIC2Path.Value;
saveEntity.PIC2 = this.hidPIC2.Value;
}
EciResponse response = SOA.Execute(request);
MES_BD_ZY data = response.Entity.Upgrade <MES_BD_ZY>();
if (request.IsAdd)
{
this.key = data.GUID;
this.btnAdd.Enabled = true;
HtmlWindow.Onload("eci.open('frmMesBdZyEditTab.aspx?key=" + this.key + "')");
}
response.Message.Tip();
}
/// <summary>
/// 保存验证
/// </summary>
/// <param name="context"></param>
/// <param name="eciDataGroup"></param>
/// <param name="isAdd"></param>
public void SaveValidate(BLLContext context, MES_BD_ZY mesBdZy, bool isAdd)
{
string sql = "SELECT GUID FROM MES_BD_ZY WHERE BH = " + cmn.SQLQ(mesBdZy.BH);
DBHelper.CheckRepeat(sql, mesBdZy.GUID, "职员编号已存在");
sql = "SELECT GUID FROM MES_BD_ZY WHERE ZYNBM = " + cmn.SQLQ(mesBdZy.ZYNBM);
DBHelper.CheckRepeat(sql, mesBdZy.GUID, "职员内部名已存在");
//bool exists = false;
//if (isAdd)
//{
// exists = MES_BD_ZY.DAL.Select().Where(a => a.BH = mesBdZy.BH).Exists();
// if (exists)
// {
// throw new AppException("职员编号" + mesBdZy.BH+"已存在");
// }
// exists = MES_BD_ZY.DAL.Select().Where(a => a.ZYNBM = mesBdZy.ZYNBM).Exists();
// if (exists)
// {
// throw new AppException("职员内部名" + mesBdZy.ZYNBM + "已存在");
// }
//}
}
/// <summary>
/// 保存验证
/// </summary>
/// <param name="context"></param>
/// <param name="eciDataGroup"></param>
/// <param name="isAdd"></param>
public void SaveValidate(BLLContext context, MES_BD_ZY mesBdZy, bool isAdd)
{
}
public void MesBdZyImport(BLLContext context, EntityBase saveEntity, DataSet ds)
{
string errMess = "", bh = "", zy = "";
int rowCount = 1, rowCount2 = 1;;
MES_BD_ZY head = null;
MES_BD_ZY_STATUS body = null;
DataTable dt = new DataTable();
dt = ds.Tables[0];
#region 新增列
dt.Columns.Add("IMP_ID", typeof(System.String));
dt.Columns.Add("GUID", typeof(System.String));
dt.Columns.Add("FGUID", typeof(System.String));
dt.Columns.Add("CREATE_USER", typeof(System.String));
dt.Columns.Add("CREATE_USER_NAME", typeof(System.String));
dt.Columns.Add("CREATE_DATE", typeof(System.DateTime));
#endregion
string impId = Guid.NewGuid().ToString();
foreach (DataRow dr in dt.Rows)
{
dr["IMP_ID"] = impId;
dr["GUID"] = Guid.NewGuid().ToString();
dr["CREATE_USER"] = context.UserInfo.UserId;
dr["CREATE_USER_NAME"] = context.UserInfo.UserName;
dr["CREATE_DATE"] = DateTime.Now.ToString("yyyy-MM-dd");
rowCount++;
#region 必填项
if (dr["职员编号"].ToString().NullOrEmpty())
{
errMess += "<BR>第" + rowCount + "行:职员编号不能为空!";
}
if (dr["工号"].ToString().NullOrEmpty())
{
errMess += "<BR>第" + rowCount + "行:工号不能为空!";
}
if (dr["职员代码"].ToString().NullOrEmpty())
{
errMess += "<BR>第" + rowCount + "行:职员代码不能为空!";
}
if (dr["职员名"].ToString().NullOrEmpty())
{
errMess += "<BR>第" + rowCount + "行:职员名不能为空!";
}
if (!errMess.NullOrEmpty())
{
throw new AppException(errMess);
}
#endregion
if (bh != dr["职员编号"].ToString())
{
#region 表头
bh = dr["职员编号"].ToString();
head = new MES_BD_ZY();
head.EffectDataFields();
head.BH = bh;
head.PARENTID = dr["上级职员编号"].ToString();
head.GH = dr["工号"].ToString();
head.ZYNBM = dr["职员内部名"].ToString();
head.CODE = dr["职员代码"].ToString();
head.NAME = dr["职员名"].ToString();
head.STATUS = dr["职员状态"].ToString();
head.SSCJ = dr["所属车间"].ToString();
head.TEL = dr["移动电话"].ToString();
head.ID_CARD = dr["身份证号码"].ToString();
head.KHYH = dr["开户银行"].ToString();
head.KHM = dr["开户名"].ToString();
head.BANK = dr["银行账号"].ToString();
head.WHCD = dr["文化程度"].ToString();
head.BYXX = dr["毕业学校"].ToString();
head.BYZY = dr["毕业专业"].ToString();
head.BYNF = dr["毕业年份"].ToString();
head.PROVINCE = dr["省份"].ToString();
head.CITY = dr["城市"].ToString();
head.ADDRESS = dr["住址"].ToString();
head.MAIL = dr["电子邮件"].ToString();
head.REMARK = dr["备注"].ToString();
head.JS1 = dr["家属1"].ToString();
head.JS1_RELATION = dr["家属1关系"].ToString();
head.JS1_TEL = dr["家属1电话"].ToString();
head.JS1_ADDRESS = dr["家属1住址"].ToString();
head.JS2 = dr["家属2"].ToString();
head.JS2_RELATION = dr["家属2关系"].ToString();
head.JS2_TEL = dr["家属2电话"].ToString();
head.JS2_ADDRESS = dr["家属2住址"].ToString();
head.JS3 = dr["家属3"].ToString();
head.JS3_RELATION = dr["家属3关系"].ToString();
head.JS3_TEL = dr["家属3电话"].ToString();
head.JS3_ADDRESS = dr["家属3住址"].ToString();
head.JS4 = dr["家属4"].ToString();
head.JS4_RELATION = dr["家属4关系"].ToString();
head.JS4_TEL = dr["家属4电话"].ToString();
head.JS4_ADDRESS = dr["家属4住址"].ToString();
head.CAR_NO = dr["车牌号"].ToString();
head.CAR_TYPE = dr["车辆类型"].ToString();
head.Validate();
val.SaveValidate(null, head, true);
#endregion
}
}
DataTable dt2 = new DataTable();
dt2 = ds.Tables[1];
#region 新增列
dt2.Columns.Add("IMP_ID", typeof(System.String));
dt2.Columns.Add("GUID", typeof(System.String));
//dt2.Columns.Add("FGUID", typeof(System.String));
dt2.Columns.Add("CREATE_USER", typeof(System.String));
dt2.Columns.Add("CREATE_USER_NAME", typeof(System.String));
dt2.Columns.Add("CREATE_DATE", typeof(System.DateTime));
#endregion
foreach (DataRow dr in dt2.Rows)
{
dr["IMP_ID"] = impId;
dr["GUID"] = Guid.NewGuid().ToString();
dr["CREATE_USER"] = context.UserInfo.UserId;
dr["CREATE_USER_NAME"] = context.UserInfo.UserName;
dr["CREATE_DATE"] = DateTime.Now.ToString("yyyy-MM-dd");
rowCount2++;
#region 必填项
if (dr["职员编号"].ToString().NullOrEmpty())
{
errMess += "<BR>第" + rowCount + "行:职员编号不能为空!";
}
//if (dr["职员"].ToString().NullOrEmpty())
//{
// errMess += "<BR>第" + rowCount + "行:职员不能为空!";
//}
if (!errMess.NullOrEmpty())
{
throw new AppException(errMess);
}
if (string.IsNullOrEmpty(dr["入职日期"] as string))
{
dr["入职日期"] = null;
}
if (string.IsNullOrEmpty(dr["离职日期"] as string))
{
dr["离职日期"] = null;
}
#endregion
if (zy != dr["职员编号"].ToString())
{
#region 表体
body = new MES_BD_ZY_STATUS();
body.EffectDataFields();
body.BH = dr["职员编号"].ToString();
body.NAME = dr["职员"].ToString();
body.RZ_DATE = dr["入职日期"].ToString().ToDateNullable();
body.LZ_DATE = dr["离职日期"].ToString().ToDateNullable();
body.SSCJ = dr["所属车间"].ToString();
body.SSCSCX = dr["所属生产线"].ToString();
body.ZW = dr["职务"].ToString();
body.GZ = dr["工种"].ToString();
body.SSBZ = dr["所属班组"].ToString();
body.GZJJGZBL = dr["工种计件工资比例"].ToString().ToDoubleNullOrEmptyToZero();
body.REMARK = dr["备注"].ToString();
body.Validate();
#endregion
}
}
SqlBulkCopyByDataTable(context, "MES_BD_ZY_IMP", "MES_BD_ZY_STATUS_IMP", dt, dt2, impId);
#region 调用存储过程写入状态表
var po = new PO("SP_MES_BD_ZY_IMP");
po["P_IMP_ID"] = impId;
po.ExecuteProcedure(context.Transaction, "");
#endregion
}
