public object Post(JObject post)
{
var form = post["form"].ToObject <wq_termPop>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.wq_termPop.Find(form.PopCode);
if (dbForm == null)
{
db.wq_termPop.Add(form);
}
else
{
dbForm.PopName = form.PopName;
dbForm.Address = form.Address;
dbForm.Contact1 = form.Contact1;
dbForm.Tel1 = form.Tel1;
dbForm.Mobile1 = form.Mobile1;
dbForm.Contact2 = form.Contact2;
dbForm.Tel2 = form.Tel2;
dbForm.Mobile2 = form.Mobile2;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
if (post["wq_Pop_Dealer"] != null)
{
var sub = post["wq_Pop_Dealer"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <wq_Pop_Dealer>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.PopCode = form.PopCode;
model.id = new SysSerialServices().GetNewSerial("wq_Pop_Dealer." + form.PopCode, null);
db.wq_Pop_Dealer.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <wq_patrolPrmPicsSet>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.wq_patrolPrmPicsSet.Find(form.code);
if (dbForm == null)
{
form.compcode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode);
db.wq_patrolPrmPicsSet.Add(form);
}
else
{
dbForm.name = form.name;
dbForm.bgtime = form.bgtime;
dbForm.edtime = form.edtime;
dbForm.CONTENT = form.CONTENT;
}
if (post["wq_patrolPrmPicsSet_bd"] != null)
{
var sub = post["wq_patrolPrmPicsSet_bd"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <wq_patrolPrmPicsSet_bd>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.code = form.code;
model.Series = new SysSerialServices().GetNewSerial("wq_patrolPrmPicsSet_bd." + form.code, null);
db.wq_patrolPrmPicsSet_bd.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <SYS_BSDATATYPE>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.SYS_BSDATATYPE.Find(form.DataTypeID);
if (dbForm == null)
{
db.SYS_BSDATATYPE.Add(form);
}
else
{
dbForm.DataTypeName = form.DataTypeName;
dbForm.Remark = form.Remark;
}
if (post["SYS_BSDATA"] != null)
{
var sub = post["SYS_BSDATA"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <SYS_BSDATA>();
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.DataTypeID = form.DataTypeID;
model.Series = new SysSerialServices().GetNewSerial("SYS_BSDATA." + form.DataTypeID, null);
db.SYS_BSDATA.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <sys_rolet>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.sys_rolet.Find(form.RoleCode);
if (dbForm == null)
{
db.sys_rolet.Add(form);
}
else
{
dbForm.RoleName = form.RoleName;
dbForm.Description = form.Description;
}
if (post["sys_roleMenuMap_app"] != null)
{
var sub = post["sys_roleMenuMap_app"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <sys_roleMenuMap_app>();
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.RoleCode = form.RoleCode;
model.id = new SysSerialServices().GetNewSerial("sys_roleMenuMap_app." + form.RoleCode, null);
db.sys_roleMenuMap_app.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JArray post)
{
using (var db = new LUOLAI1401Context())
{
for (var i = 0; i < post.Count; i++)
{
var form = post[i].ToObject <PM_Overdue>(JsonExtension.FixJsonSerializer);
var dbForm = db.PM_Overdue.Find(form.FID);
RowState rowState = (RowState)(int)post[i]["_row_state"];
switch (rowState)
{
case RowState.Changed:
dbForm.CustID = form.CustID;
dbForm.Amt = form.Amt;
break;
case RowState.Deleted:
db.Entry(dbForm).State = System.Data.Entity.EntityState.Deleted;
break;
case RowState.New:
form.FID = int.Parse((string)NewFID());
db.PM_Overdue.Add(form);
break;
}
}
db.SaveChanges();
return(true);
}
}
public object Post(JArray post)
{
using (var db = new LUOLAI1401Context())
{
for (var i = 0; i < post.Count; i++)
{
var form = post[i].ToObject <fw_Direct>(JsonExtension.FixJsonSerializer);
var dbForm = db.fw_Direct.Find(form.dirid);
RowState rowState = (RowState)(int)post[i]["_row_state"];
switch (rowState)
{
case RowState.Changed:
dbForm.item = form.item;
dbForm.corpname = form.corpname;
dbForm.dirname = form.dirname;
dbForm.dirvalue = form.dirvalue;
dbForm.UpValue = form.UpValue;
break;
case RowState.Deleted:
db.Entry(dbForm).State = System.Data.Entity.EntityState.Deleted;
break;
case RowState.New:
form.dirid = (string)Newdirid();
db.fw_Direct.Add(form);
break;
}
}
db.SaveChanges();
return(true);
}
}
public object Post(JArray post)
{
using (var db = new LUOLAI1401Context())
{
for (var i = 0; i < post.Count; i++)
{
var form = post[i].ToObject <HR_HousingFundSet>(JsonExtension.FixJsonSerializer);
var dbForm = db.HR_HousingFundSet.Find(form.ID);
RowState rowState = (RowState)(int)post[i]["_row_state"];
switch (rowState)
{
case RowState.Changed:
dbForm.FType = form.FType;
dbForm.pIndv = form.pIndv;
dbForm.pCorp = form.pCorp;
dbForm.Remark = form.Remark;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
break;
case RowState.Deleted:
db.Entry(dbForm).State = System.Data.Entity.EntityState.Deleted;
break;
case RowState.New:
form.ID = int.Parse((string)NewID());
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.HR_HousingFundSet.Add(form);
break;
}
}
db.SaveChanges();
return(true);
}
}
public object Post(JObject post)
{
var form = post["form"].ToObject <PersonInfo>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.PersonInfo.Find(form.ID);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.PersonInfo.Add(form);
}
else
{
dbForm.psncode = form.psncode;
dbForm.name = form.name;
dbForm.Mobile = form.Mobile;
dbForm.sex = form.sex;
dbForm.idtype = form.idtype;
dbForm.CertNumber = form.CertNumber;
dbForm.nationality = form.nationality;
dbForm.nativeplace = form.nativeplace;
dbForm.age = form.age;
dbForm.birthdate = form.birthdate;
dbForm.BirthPlace = form.BirthPlace;
dbForm.FileNumber = form.FileNumber;
dbForm.SocialSecurity = form.SocialSecurity;
dbForm.WageCard = form.WageCard;
dbForm.EmployeeStatus = form.EmployeeStatus;
dbForm.position = form.position;
dbForm.RoleCode = form.RoleCode;
dbForm.effectdate = form.effectdate;
dbForm.stuffdate = form.stuffdate;
dbForm.marital = form.marital;
dbForm.health = form.health;
dbForm.Height = form.Height;
dbForm.Weight = form.Weight;
dbForm.GraduationSchool = form.GraduationSchool;
dbForm.lasteducation = form.lasteducation;
dbForm.HighestDegree = form.HighestDegree;
dbForm.major = form.major;
dbForm.rank = form.rank;
dbForm.is_status = form.is_status;
dbForm.kq_status = form.kq_status;
dbForm.glbdef1 = form.glbdef1;
dbForm.Photo = form.Photo;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
if (post["wq_unittype"] != null)
{
var sub = post["wq_unittype"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <wq_unittype>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.usercode = form.psncode;
model.compcode = form.CompCode;
model.id = new SysSerialServices().GetNewSerial("wq_unittype." + form.ID, null);
db.wq_unittype.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <fw_ObjectionResult>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.fw_ObjectionResult.Find(form.objectionid);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.fw_ObjectionResult.Add(form);
}
else
{
dbForm.MemId = form.MemId;
dbForm.orderid = form.orderid;
dbForm.IsContinue = form.IsContinue;
dbForm.paymemId = form.paymemId;
dbForm.payment = form.payment;
dbForm.paymentmode = form.paymentmode;
dbForm.paymentendtime = form.paymentendtime;
dbForm.resultstatus = form.resultstatus;
dbForm.explain = form.explain;
dbForm.resultperson = form.resultperson;
dbForm.resultphone = form.resultphone;
dbForm.finalresult = form.finalresult;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
if (post["v_objection"] != null)
{
var sub = post["v_objection"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <v_objection>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.objectionid = form.objectionid;
model.orderid = new SysSerialServices().GetNewSerial("v_objection." + form.objectionid, null).ToString();
db.v_objection.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
if (post["v_Orderinfo"] != null)
{
var sub = post["v_Orderinfo"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <v_Orderinfo>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.objectionid = form.objectionid;
model.selleruserid = new SysSerialServices().GetNewSerial("v_Orderinfo." + form.objectionid, null).ToString();
db.v_Orderinfo.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
if (post["v_ObjectionResult1"] != null)
{
var sub = post["v_ObjectionResult1"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <v_ObjectionResult1>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.objectionid = form.objectionid;
model.phone = new SysSerialServices().GetNewSerial("v_ObjectionResult1." + form.objectionid, null).ToString();
db.v_ObjectionResult1.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
if (post["v_ObjectionResult"] != null)
{
var sub = post["v_ObjectionResult"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <v_ObjectionResult>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.objectionid = form.objectionid;
model.phone = new SysSerialServices().GetNewSerial("v_ObjectionResult." + form.objectionid, null).ToString();
db.v_ObjectionResult.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <three1>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.three1.Find(form.id);
if (dbForm == null)
{
db.three1.Add(form);
}
else
{
dbForm.name = form.name;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
if (post["three2"] != null)
{
var sub = post["three2"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <three2>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.pid = form.id;
model.id = new SysSerialServices().GetNewSerial("three2." + form.id, null);
_id_maps.Add((int)obj["_id_"], new object[] { model.pid, model.id });
db.three2.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
if (post["three3"] != null)
{
var sub = post["three3"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <three3>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
if (obj["_pid_"] != null && _id_maps.ContainsKey((int)obj["_pid_"]))
{
model.gid = (int)_id_maps[(int)obj["_pid_"]][0];
model.pid = (int)_id_maps[(int)obj["_pid_"]][1];
}
model.id = new SysSerialServices().GetNewSerial("three3." + form.id, null);
db.three3.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <fw_orderinfo>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.fw_orderinfo.Find(form.ordid);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.fw_orderinfo.Add(form);
}
else
{
dbForm.selleruserid = form.selleruserid;
dbForm.buyeruserid = form.buyeruserid;
dbForm.tranmode = form.tranmode;
dbForm.fromid = form.fromid;
dbForm.ordstate = form.ordstate;
dbForm.isactive = form.isactive;
dbForm.SelfMentioning = form.SelfMentioning;
dbForm.pathvoucher = form.pathvoucher;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
if (post["fw_orderlist"] != null)
{
var sub = post["fw_orderlist"] as JArray;
if (sub.Count > 0)
{
for (int i = 0; i < sub.Count; i++)
{
JObject obj = sub[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
var model = obj.ToObject <fw_orderlist>(JsonExtension.FixJsonSerializer);
switch (rowState)
{
case RowState.Changed:
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
model.ordid = form.ordid;
model.ordlistid = new SysSerialServices().GetNewSerial("fw_orderlist." + form.ordid, null);
db.fw_orderlist.Add(model);
break;
case RowState.Deleted:
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
}
}
db.SaveChanges();
}
using (var db = new LUOLAI1401Context())
{
db.Database.Connection.Open();
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = "UPDATE fw_orderinfo SET pathfilename=Path FROM SYS_YLW.dbo.sys_file WHERE pathvoucher=FileId AND ordid=@ordid";
var p1 = cmd.CreateParameter();
p1.ParameterName = "@ordid";
p1.Value = form.ordid;
cmd.Parameters.Add(p1);
cmd.ExecuteNonQuery();
}
return(new { success = true, form = form });
}