public object Post(JObject post)
{
var form = post["form"].ToObject <wq_income>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.wq_income.Find(form.id);
if (dbForm == null)
{
form.CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode);
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.wq_income.Add(form);
}
else
{
dbForm.PopCode = form.PopCode;
dbForm.Month = form.Month;
dbForm.IncomeAmt = form.IncomeAmt;
dbForm.UserCode = form.UserCode;
dbForm.Remark = form.Remark;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <FA_InvAccepts>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.FA_InvAccepts.Find(form.FID);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.FA_InvAccepts.Add(form);
}
else
{
dbForm.Corp = form.Corp;
dbForm.CustID = form.CustID;
dbForm.PID = form.PID;
dbForm.Fdate = form.Fdate;
dbForm.Amt = form.Amt;
dbForm.invoiceTitle = form.invoiceTitle;
dbForm.invoiceType = form.invoiceType;
dbForm.Remark = form.Remark;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
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(JObject post)
{
var form = post["form"].ToObject <timingSet>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.timingSet.Find(form.id);
if (dbForm == null)
{
form.CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode);
db.timingSet.Add(form);
}
else
{
dbForm.RoleCode = form.RoleCode;
dbForm.psncode = form.psncode;
dbForm.timingtype = form.timingtype;
dbForm.interval = form.interval;
dbForm.mobegintime = form.mobegintime;
dbForm.moendtime = form.moendtime;
dbForm.afbegintime = form.afbegintime;
dbForm.afendtime = form.afendtime;
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Get(JObject req)
{
using (var db = new LUOLAI1401Context())
{
db.Database.Connection.Open();
try {
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "proc_SearchList";
cmd.Parameters.Add(new SqlParameter("@tableName", "wq_goodsreport GD LEFT JOIN wq_termPop PO ON GD.DealerCode=PO.PopCode"));
cmd.Parameters.Add(new SqlParameter("@fieldNames", "PO.PopName AS PopName,PO.Address AS Address,GD.RPdtCode AS RPdtCode,GD.PrmDate AS PrmDate,GD.Remark AS Remark,GD.No AS No"));
cmd.Parameters.Add(new SqlParameter("@fieldSort", "GD.PrmDate"));
var sbCondition = new StringBuilder();
sbCondition.Append(string.Format("{0}{1}{2}{3}{4}{5}{6}", "((GD.UserCode IN (SELECT UserCode FROM dbo.sys_user WHERE OrganizeName LIKE '", System.Web.HttpContext.Current.Session["OrganizeName"], "%') AND GD.CompCode='", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode, "') or ('", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).UserCode, "'='super ' ))"));
sbCondition.Append(" AND ");
SerachCondition.TextBox(sbCondition, "PopName", "PopName", "varchar");
SerachCondition.TextBox(sbCondition, "Address", "Address", "varchar");
SerachCondition.TextBox(sbCondition, "RPdtCode", "RPdtCode", "varchar");
SerachCondition.Date(sbCondition, "PrmDate", "PrmDate", "varchar");
if (sbCondition.Length > 5)
{
sbCondition.Length -= 5;
cmd.Parameters.Add(new SqlParameter("@condition", sbCondition.ToString()));
}
if (HttpContext.Current.Request.Get("_report_") == "1")
{
// 报表请求条件合成
return(sbCondition.ToString());
}
SqlParameter rowTotalParameter = null;
int rowTotal = 0;
int.TryParse(HttpContext.Current.Request.Get("total"), out rowTotal);
var rq = new PageRequest();
if (rq.Page.HasValue)
{
var pageSize = rq.Rows.HasValue ? rq.Rows.Value : 20;
var rowStart = (rq.Page.Value - 1) * pageSize + 1;
var rowEnd = rq.Page.Value * pageSize;
cmd.Parameters.Add(new SqlParameter("@rowStart", rowStart));
cmd.Parameters.Add(new SqlParameter("@rowEnd", rowEnd));
if (rowStart == 1)
{
cmd.Parameters.Add(rowTotalParameter = new SqlParameter("@rowTotal", System.Data.SqlDbType.Int, 8, System.Data.ParameterDirection.Output, true, 0, 0, null, System.Data.DataRowVersion.Default, 0));
}
}
string jsonArrayString = null;
using (var reader = cmd.ExecuteReader())
{
jsonArrayString = reader.ToJsonArrayString();
}
if (rowTotalParameter != null)
{
rowTotal = (int)rowTotalParameter.Value;
}
return(JObject.Parse("{rows:" + jsonArrayString + ", total:" + rowTotal + "}"));
} finally {
db.Database.Connection.Close();
}
}
}
public ActionResult Edit(int id)
{
fw_depositinfo form = null;
List <ComboItem> cat1 = null, memid = null;
List <cat2ComboItem> cat2 = null;
using (var db = new LUOLAI1401Context())
{
cat1 = db.Database.SqlQuery <ComboItem>("select catname Text, cast(catid as varchar(10)) Value from fw_categoryinfo where " + string.Format("{0}", "/*TABLEALIAS*/parentid='0'")).ToList();
cat2 = db.Database.SqlQuery <cat2ComboItem>("select catname Text, cast(catid as varchar(10)) Value,cast(parentid as varchar(10)) parentid from fw_categoryinfo where " + string.Format("{0}", "/*TABLEALIAS*/parentid !='0'")).ToList();
memid = db.fw_memberinfo.Select(i => new ComboItem {
Text = i.realname, Value = "" + i.memid
}).ToList();
form = db.fw_depositinfo.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new fw_depositinfo
{
depid = id
};
}
return(View(new { form = form, dataSource = new { cat1, cat2, memid } }));
}
public object Post(JObject post)
{
var form = post["form"].ToObject <HR_CertLoans>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.HR_CertLoans.Find(form.FID);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.HR_CertLoans.Add(form);
}
else
{
dbForm.CID = form.CID;
dbForm.Department = form.Department;
dbForm.GAddress = form.GAddress;
dbForm.ProjName = form.ProjName;
dbForm.Amt = form.Amt;
dbForm.loanDate = form.loanDate;
dbForm.EndTime = form.EndTime;
dbForm.KAmt = form.KAmt;
dbForm.TRemark = form.TRemark;
dbForm.DRemark = form.DRemark;
dbForm.Scan = form.Scan;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
db.SaveChanges();
}
return(new { success = true, form = form });
}
public ActionResult Edit2(long id)
{
ViewBag.id = id;
HR_PractiseCerts hr;
using (var db = new LUOLAI1401Context())
{
hr = db.HR_PractiseCerts.FirstOrDefault(s => s.FID == id);
}
if (hr != null)
{
ViewBag.Scan1 = hr.Scan1;
ViewBag.Scan2 = hr.Scan2;
ViewBag.Scan3 = hr.Scan3;
ViewBag.Scan4 = hr.Scan4;
}
else
{
ViewBag.Scan1 = "";
ViewBag.Scan2 = "";
ViewBag.Scan3 = "";
ViewBag.Scan4 = "";
}
return(View(hr));
}
public ActionResult Edit(string id)
{
FA_Receipts form = null;
List <ComboItem> Corp = null, SZType = null, payType = null;
using (var db = new SysContext())
{
Corp = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='HtCorp'")).ToList();
SZType = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='SHZHType'")).ToList();
payType = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='PayKind'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.Database.SqlQuery <FA_ReceiptsViewable>("select a.FID ,a.Corp ,a.SZType ,b.Contact CustID_RefText ,a.CustID ,a.Fdate ,a.Amt ,a.payType ,a.Remark ,a.CreatePerson ,a.CreateDate ,a.UpdateDate from FA_Receipts a LEFT JOIN BD_Customers b ON a.CustID = b.FID where a.FID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new FA_Receipts
{
FID = id
};
}
return(View(new { form = form, dataSource = new { Corp, SZType, payType } }));
}
public ActionResult Edit(string id)
{
PersonInfo form = null;
List <ComboItem> sex = null, idtype = null, EmployeeStatus = null, position = null, marital = null, lasteducation = null, HighestDegree = null, rank = null, wq_unittype_remark = null;
using (var db = new SysContext())
{
sex = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='Sex'")).ToList();
idtype = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='idtype'")).ToList();
EmployeeStatus = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='forstatus'")).ToList();
position = db.Database.SqlQuery <ComboItem>("select OrganizeName Text, OrganizeCode Value from sys_organize where " + string.Format("{0}{1}", "CompCode=", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode)).ToList();
marital = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='marital'")).ToList();
lasteducation = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='lasteducation'")).ToList();
HighestDegree = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='HighestDegree'")).ToList();
rank = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='rank'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.Database.SqlQuery <PersonInfoViewable>("select a.ID ,a.psncode ,a.name ,a.Mobile ,a.sex ,a.idtype ,a.CertNumber ,a.nationality ,a.nativeplace ,a.age ,a.birthdate ,a.BirthPlace ,a.characterrpr ,a.permanreside ,a.FileNumber ,a.SocialSecurity ,a.WageCard ,a.EmployeeStatus ,a.position ,b.RoleName RoleCode_RefText ,a.RoleCode ,a.effectdate ,a.stuffdate ,a.workaddr ,a.marital ,a.country ,a.polity ,a.health ,a.Height ,a.Weight ,a.Vision ,a.GraduationSchool ,a.lasteducation ,a.HighestDegree ,a.major ,a.rank ,a.joinworkdate ,a.FreeWorkYears ,a.is_status ,a.kq_status ,a.glbdef1 ,a.Photo ,a.CreatePerson ,a.CreateDate ,a.UpdatePerson ,a.UpdateDate from PersonInfo a LEFT JOIN [Bcp.Sys].dbo.sys_role b ON a.RoleCode = b.RoleCode AND " + string.Format("{0}{1}{2}", "CompCode='", System.Web.HttpContext.Current.Session["CompCode"], "'") + " where a.ID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new PersonInfo
{
ID = id,
kq_status = string.Format("{0}", "1"),
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
};
}
return(View(new { form = form, dataSource = new { sex, idtype, EmployeeStatus, position, marital, lasteducation, HighestDegree, rank, wq_unittype_remark } }));
}
public object Post(JObject post)
{
var form = post["form"].ToObject <fw_directprice>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.fw_directprice.Find(form.directid);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.fw_directprice.Add(form);
}
else
{
dbForm.directtitle = form.directtitle;
dbForm.catid0 = form.catid0;
dbForm.directtime0 = form.directtime0;
dbForm.directprice0 = form.directprice0;
dbForm.isshow = form.isshow;
dbForm.floatprice0 = form.floatprice0;
dbForm.floatrate0 = form.floatrate0;
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[]>();
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <fw_userinfo>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.fw_userinfo.Find(form.userid);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.fw_userinfo.Add(form);
}
else
{
dbForm.username = form.username;
dbForm.userpass = form.userpass;
dbForm.regtime = form.regtime;
dbForm.lasttime = form.lasttime;
dbForm.isadmin = form.isadmin;
dbForm.isenabled = form.isenabled;
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[]>();
db.SaveChanges();
}
return(new { success = true, form = form });
}
public ActionResult Edit(string id)
{
HR_WageSets form = null;
List <ComboItem> HFType = null, CustID = null;
using (var db = new SysContext())
{
HFType = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='FType'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
CustID = db.BD_Customers.Select(i => new ComboItem {
Text = i.Contact, Value = "" + i.FID
}).ToList();
form = db.Database.SqlQuery <HR_WageSetsViewable>("select a.FID ,b.empID empID_RefText ,a.empID ,a.HFType ,a.SSBaseAmt ,a.HFBaseAmt ,a.CustID ,a.START_TIME ,a.END_TIME ,a.Remark ,a.CreatePerson ,a.CreateDate ,a.UpdateDate from HR_WageSets a LEFT JOIN HR_PractiseCerts b ON a.empID = b.FID where a.FID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new HR_WageSets
{
FID = id
};
}
return(View(new { form = form, dataSource = new { HFType, CustID } }));
}
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 ActionResult Edit(int id)
{
base_customField form = null;
List <ComboItem> TypeCode = null;
using (var db = new SysContext())
{
TypeCode = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where " + string.Format("{0}", "CodeType='patrolSignIn'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.base_customField.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new base_customField
{
id = id,
CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode)
};
}
return(View(new { form = form, dataSource = new { TypeCode } }));
}
public object Post(JObject post)
{
var form = post["form"].ToObject <PM_ContractFiles>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.PM_ContractFiles.Find(form.FID);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.PM_ContractFiles.Add(form);
}
else
{
dbForm.PManager = form.PManager;
dbForm.type = form.type;
dbForm.PID = form.PID;
dbForm.Amt = form.Amt;
dbForm.Owner = form.Owner;
dbForm.ProjName = form.ProjName;
dbForm.BeginDate = form.BeginDate;
dbForm.EndDate = form.EndDate;
dbForm.projAddress = form.projAddress;
dbForm.Remark = form.Remark;
dbForm.Attach = form.Attach;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <HR_SocialSecuritySets>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.HR_SocialSecuritySets.Find(form.FID);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.HR_SocialSecuritySets.Add(form);
}
else
{
dbForm.pIndvPension = form.pIndvPension;
dbForm.pIndvMedical = form.pIndvMedical;
dbForm.pIndvUnemploy = form.pIndvUnemploy;
dbForm.pCorpPension = form.pCorpPension;
dbForm.pCorpBaseMedical = form.pCorpBaseMedical;
dbForm.pCorpLocalMedical = form.pCorpLocalMedical;
dbForm.pCorpInjury = form.pCorpInjury;
dbForm.pCorpBirth = form.pCorpBirth;
dbForm.pCorpUnemploy = form.pCorpUnemploy;
dbForm.FType = form.FType;
dbForm.Remark = form.Remark;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
}
// 记录多级零时主键对应(key int 为 js 生成的页内全局唯一编号)
var _id_maps = new Dictionary <int, object[]>();
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Get(JObject req)
{
using (var db = new LUOLAI1401Context())
{
db.Database.Connection.Open();
try {
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "proc_SearchList";
cmd.Parameters.Add(new SqlParameter("@tableName", "zdwdxl"));
cmd.Parameters.Add(new SqlParameter("@fieldNames", "zdwdxl.终端编号 AS 终端编号,zdwdxl.终端名称 AS 终端名称,zdwdxl.联系人 AS 联系人,zdwdxl.联系电话 AS 联系电话,zdwdxl.联系手机 AS 联系手机,zdwdxl.地址 AS 地址,zdwdxl.老板名 AS 老板名,zdwdxl.老板电话 AS 老板电话,zdwdxl.老板手机 AS 老板手机,zdwdxl.终端类型 AS 终端类型,zdwdxl.结算方式 AS 结算方式,zdwdxl.商超营业面积 AS 商超营业面积,zdwdxl.采购方式 AS 采购方式,zdwdxl.上座率 AS 上座率,zdwdxl.平均消费 AS 平均消费,zdwdxl.进店类型 AS 进店类型,zdwdxl.包间数 AS 包间数,zdwdxl.流通营业面积 AS 流通营业面积,zdwdxl.门面数 AS 门面数,zdwdxl.酒水容量 AS 酒水容量,zdwdxl.团购金额 AS 团购金额,zdwdxl.业务员编号 AS 业务员编号,zdwdxl.业务员名称 AS 业务员名称"));
cmd.Parameters.Add(new SqlParameter("@fieldSort", "zdwdxl.终端编号"));
var sbCondition = new StringBuilder();
sbCondition.Append(string.Format("{0}{1}{2}{3}{4}{5}{6}", "((业务员编号 IN (SELECT UserCode FROM dbo.sys_user WHERE OrganizeName LIKE '", System.Web.HttpContext.Current.Session["OrganizeName"], "%')AND 所属公司='", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode, "') or ('", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).UserCode, "'='super'))"));
sbCondition.Append(" AND ");
SerachCondition.TextBox(sbCondition, "终端名称", "终端名称", "");
SerachCondition.TextBox(sbCondition, "联系人", "联系人", "");
SerachCondition.TextBox(sbCondition, "联系手机", "联系手机", "");
SerachCondition.Dropdown(sbCondition, "终端类型", "终端类型", "");
if (sbCondition.Length > 5)
{
sbCondition.Length -= 5;
cmd.Parameters.Add(new SqlParameter("@condition", sbCondition.ToString()));
}
if (HttpContext.Current.Request.Get("_report_") == "1")
{
// 报表请求条件合成
return(sbCondition.ToString());
}
SqlParameter rowTotalParameter = null;
int rowTotal = 0;
int.TryParse(HttpContext.Current.Request.Get("total"), out rowTotal);
var rq = new PageRequest();
if (rq.Page.HasValue)
{
var pageSize = rq.Rows.HasValue ? rq.Rows.Value : 20;
var rowStart = (rq.Page.Value - 1) * pageSize + 1;
var rowEnd = rq.Page.Value * pageSize;
cmd.Parameters.Add(new SqlParameter("@rowStart", rowStart));
cmd.Parameters.Add(new SqlParameter("@rowEnd", rowEnd));
if (rowStart == 1)
{
cmd.Parameters.Add(rowTotalParameter = new SqlParameter("@rowTotal", System.Data.SqlDbType.Int, 8, System.Data.ParameterDirection.Output, true, 0, 0, null, System.Data.DataRowVersion.Default, 0));
}
}
string jsonArrayString = null;
using (var reader = cmd.ExecuteReader())
{
jsonArrayString = reader.ToJsonArrayString();
}
if (rowTotalParameter != null)
{
rowTotal = (int)rowTotalParameter.Value;
}
return(JObject.Parse("{rows:" + jsonArrayString + ", total:" + rowTotal + "}"));
} finally {
db.Database.Connection.Close();
}
}
}
public object Post(JObject post)
{
var form = post["form"].ToObject <wq_businesscustomers>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.wq_businesscustomers.Find(form.id);
if (dbForm == null)
{
form.CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode);
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.wq_businesscustomers.Add(form);
}
else
{
dbForm.DealerCode = form.DealerCode;
dbForm.DealerType = form.DealerType;
dbForm.Businessarea = form.Businessarea;
dbForm.Procurementmode = form.Procurementmode;
dbForm.Remark = form.Remark;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Get(JObject req)
{
using (var db = new LUOLAI1401Context())
{
db.Database.Connection.Open();
try {
var cmd = db.Database.Connection.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "proc_SearchList";
cmd.Parameters.Add(new SqlParameter("@tableName", "KZ_cpfbmx"));
cmd.Parameters.Add(new SqlParameter("@fieldNames", "KZ_cpfbmx.省份 AS 省份,KZ_cpfbmx.城市 AS 城市,KZ_cpfbmx.终端类型 AS 终端类型,KZ_cpfbmx.客户名称 AS 客户名称,KZ_cpfbmx.库存量 AS 库存量,KZ_cpfbmx.产品 AS 产品,KZ_cpfbmx.规格 AS 规格"));
cmd.Parameters.Add(new SqlParameter("@fieldSort", "省份"));
var sbCondition = new StringBuilder();
sbCondition.Append(string.Format("{0}{1}{2}{3}{4}", "((CompCode='", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode, "') or ('", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).UserCode, "'='super'))"));
sbCondition.Append(" AND ");
SerachCondition.TextBox(sbCondition, "省份", "省份", "varchar");
SerachCondition.TextBox(sbCondition, "城市", "城市", "varchar");
SerachCondition.Dropdown(sbCondition, "终端类型", "终端类型", "varchar");
SerachCondition.TextBox(sbCondition, "产品", "产品", "varchar");
if (sbCondition.Length > 5)
{
sbCondition.Length -= 5;
cmd.Parameters.Add(new SqlParameter("@condition", sbCondition.ToString()));
}
if (HttpContext.Current.Request.Get("_report_") == "1")
{
// 报表请求条件合成
return(sbCondition.ToString());
}
SqlParameter rowTotalParameter = null;
int rowTotal = 0;
int.TryParse(HttpContext.Current.Request.Get("total"), out rowTotal);
var rq = new PageRequest();
if (rq.Page.HasValue)
{
var pageSize = rq.Rows.HasValue ? rq.Rows.Value : 20;
var rowStart = (rq.Page.Value - 1) * pageSize + 1;
var rowEnd = rq.Page.Value * pageSize;
cmd.Parameters.Add(new SqlParameter("@rowStart", rowStart));
cmd.Parameters.Add(new SqlParameter("@rowEnd", rowEnd));
if (rowStart == 1)
{
cmd.Parameters.Add(rowTotalParameter = new SqlParameter("@rowTotal", System.Data.SqlDbType.Int, 8, System.Data.ParameterDirection.Output, true, 0, 0, null, System.Data.DataRowVersion.Default, 0));
}
}
string jsonArrayString = null;
using (var reader = cmd.ExecuteReader())
{
jsonArrayString = reader.ToJsonArrayString();
}
if (rowTotalParameter != null)
{
rowTotal = (int)rowTotalParameter.Value;
}
return(JObject.Parse("{rows:" + jsonArrayString + ", total:" + rowTotal + "}"));
} finally {
db.Database.Connection.Close();
}
}
}
public ActionResult Edit(long id)
{
HR_CertLoans form = null;
List <ComboItem> TRemark = null, DRemark = null;
using (var db = new SysContext())
{
TRemark = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='Tui'")).ToList();
DRemark = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='yes/no'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.HR_CertLoans.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new HR_CertLoans
{
FID = id
};
}
return(View(new { form = form, dataSource = new { TRemark, DRemark } }));
}
public ActionResult Edit(string id)
{
fw_memberinfo form = null;
List <ComboItem> gender = null, ispassed = null, isenabled = null;
using (var db = new SysContext())
{
gender = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='Gender'")).ToList();
ispassed = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='RZZT'")).ToList();
isenabled = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='YN'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.fw_memberinfo.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new fw_memberinfo
{
Fid = id
};
}
return(View(new { form = form, dataSource = new { gender, ispassed, isenabled } }));
}
public ActionResult Edit(string id)
{
timingSet form = null;
List <ComboItem> timingtype = null;
using (var db = new SysContext())
{
timingtype = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where " + string.Format("{0}", "CodeType='sfkq'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.Database.SqlQuery <timingSetViewable>("select a.CompCode ,b.RoleName RoleCode_RefText ,a.RoleCode ,c.name psncode_RefText ,a.psncode ,a.timingtype ,a.interval ,a.mobegintime ,a.moendtime ,a.afbegintime ,a.afendtime ,a.id from timingSet a LEFT JOIN [Bcp.Sys].dbo.sys_role b ON a.RoleCode = b.RoleCode LEFT JOIN PersonInfo c ON a.psncode = c.psncode where a.id = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new timingSet
{
id = id,
CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode)
};
}
return(View(new { form = form, dataSource = new { timingtype } }));
}
public object Post(JObject post)
{
var form = post["form"].ToObject <EnterpriseCertificate>(JsonExtension.FixJsonSerializer);
using (var db = new LUOLAI1401Context())
{
var dbForm = db.EnterpriseCertificate.Find(form.FID);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.EnterpriseCertificate.Add(form);
}
else
{
dbForm.Company = form.Company;
dbForm.Name = form.Name;
dbForm.EffectiveDate = form.EffectiveDate;
dbForm.Qty = form.Qty;
dbForm.onProject = form.onProject;
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[]>();
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <base_productCate>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.base_productCate.Find(form.CateCode);
if (dbForm == null)
{
form.CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode);
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.base_productCate.Add(form);
}
else
{
dbForm.CateName = form.CateName;
dbForm.DelFlag = form.DelFlag;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Post(JObject post)
{
var form = post["form"].ToObject <wq_distributionclient>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.wq_distributionclient.Find(form.id);
if (dbForm == null)
{
form.CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode);
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.wq_distributionclient.Add(form);
}
else
{
dbForm.DealerCode = form.DealerCode;
dbForm.DealerType = form.DealerType;
dbForm.Businessarea = form.Businessarea;
dbForm.Appearancenumber = form.Appearancenumber;
dbForm.Winecapacity = form.Winecapacity;
dbForm.jkfs = form.jkfs;
dbForm.Remark = form.Remark;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public ActionResult Edit(string id)
{
FA_InvAccepts form = null;
List <ComboItem> Corp = null, invoiceType = null;
using (var db = new SysContext())
{
Corp = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='HtCorp'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
invoiceType = db.HR_NewInvoices.Select(i => new ComboItem {
Text = i.Remarks, Value = "" + i.FID
}).ToList();
form = db.Database.SqlQuery <FA_InvAcceptsViewable>("select a.FID ,a.Corp ,b.Contact CustID_RefText ,a.CustID ,a.PID ,a.Fdate ,a.Amt ,a.invoiceTitle ,a.invoiceType ,a.Remark ,a.CreatePerson ,a.CreateDate ,a.UpdateDate from FA_InvAccepts a LEFT JOIN BD_Customers b ON a.CustID = b.FID where a.FID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new FA_InvAccepts
{
FID = id,
invoiceType = string.Format("{0}", "5")
};
}
return(View(new { form = form, dataSource = new { Corp, invoiceType } }));
}
public ActionResult Edit(int id)
{
wq_grouppurchase form = null;
List <ComboItem> DealerCode = null, DealerType = null;
using (var db = new SysContext())
{
DealerType = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where " + string.Format("{0}", "CodeType='Kz_zd'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
DealerCode = db.Database.SqlQuery <ComboItem>("select PopName Text, PopCode Value from wq_termPop where " + string.Format("{0}{1}{2}", "CompCode='", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode, "'")).ToList();
form = db.wq_grouppurchase.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new wq_grouppurchase
{
id = id,
CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode),
DealerType = string.Format("{0}", "团购客户")
};
}
return(View(new { form = form, dataSource = new { DealerCode, DealerType } }));
}
public object Post(JObject post)
{
var form = post["form"].ToObject <wq_goodsreport>();
using (var db = new LUOLAI1401Context())
{
var dbForm = db.wq_goodsreport.Find(form.RPdtCode);
if (dbForm == null)
{
form.CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode);
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.wq_goodsreport.Add(form);
}
else
{
dbForm.UserCode = form.UserCode;
dbForm.PrmDate = form.PrmDate;
dbForm.DealerCode = form.DealerCode;
dbForm.Remark = form.Remark;
dbForm.Pic1 = form.Pic1;
dbForm.Pic2 = form.Pic2;
dbForm.Pic3 = form.Pic3;
dbForm.Pic4 = form.Pic4;
dbForm.Pic5 = form.Pic5;
dbForm.Pic6 = form.Pic6;
dbForm.Pic7 = form.Pic7;
dbForm.Pic8 = form.Pic8;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public ActionResult Edit(string id)
{
wq_patrolSet form = null;
List <ComboItem> SignInMode = null, SignOutMode = null, PhotoMarkType = null, PhotoRatio = null;
using (var db = new SysContext())
{
SignInMode = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where CodeType='sfkq'").ToList();
SignOutMode = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where CodeType='sfkq'").ToList();
PhotoMarkType = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where CodeType='sfkq'").ToList();
PhotoRatio = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where CodeType='zpfbl'").ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.Database.SqlQuery <wq_patrolSetViewable>("select a.CompCode ,b.RoleName RoleCode_RefText ,a.RoleCode ,a.SignInMode ,a.SignOutMode ,a.SignInRange ,a.SignOutRange ,a.PhotoMarkType ,a.PhotoRatio ,a.CreatePerson ,a.CreateDate ,a.UpdatePerson ,a.UpdateDate ,a.id from wq_patrolSet a LEFT JOIN [Bcp.Sys].dbo.sys_role b ON a.RoleCode = b.RoleCode where a.id = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new wq_patrolSet
{
id = id,
CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode)
};
}
return(View(new { form = form, dataSource = new { SignInMode, SignOutMode, PhotoMarkType, PhotoRatio } }));
}
