public int UpdateSaleMan(dynamic requestData)
{
string query = JsonConvert.SerializeObject(requestData);
RegistSaleMan saleman = JsonConvert.DeserializeObject <RegistSaleMan>(query);
EntityState statebefore = db.Entry(saleman).State;
db.Entry(saleman).State = EntityState.Modified;
return(db.SaveChanges());
}
public string UpdateDrawPrize(dynamic requestData)
{
string query = JsonConvert.SerializeObject(requestData);
DrawPrize model = JsonConvert.DeserializeObject <DrawPrize>(query);
EntityState statebefore = db.Entry(model).State;
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return("Excute Success");
}
public int UpdateMember(dynamic requestData)
{
string query = JsonConvert.SerializeObject(requestData);
RegistMember model = JsonConvert.DeserializeObject <RegistMember>(query);
EntityState statebefore = db.Entry(model).State;
db.Entry(model).State = EntityState.Modified;
return(db.SaveChanges());
}
public int UpdateMemberResume(dynamic requestData)
{
string query = JsonConvert.SerializeObject(requestData);
MemberResume model = JsonConvert.DeserializeObject <MemberResume>(query);
EntityState statebefore = db.Entry(model).State;
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(model.ResumeId);
}
public string RealAuthUpdate(dynamic requestData)
{
string query = JsonConvert.SerializeObject(requestData);
MemberRealAuth model = JsonConvert.DeserializeObject <MemberRealAuth>(query);
model.AuthTime = DateTime.Now;
EntityState statebefore = db.Entry(model).State;
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return("Exc Success");
}
public string AddSigninCredit(dynamic requestData)
{
try
{
int MemberId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.MemberId));
var datatime = DateTime.Today;
var q = (from v in db.SigninCreditLog
where v.MemberId == MemberId && v.SigninData == datatime
select v
).FirstOrDefault();
if (q == null)
{
SigninCreditLog s = new SigninCreditLog();
s.SigninData = datatime;
s.MemberId = MemberId;
db.SigninCreditLog.Add(s);
SigninCredit sC = new SigninCredit();
var sccun = (from v in db.SigninCredit
where v.MemberId == MemberId
select v
).FirstOrDefault();
if (sccun == null)
{
sC.MemberId = MemberId;
sC.CreditsCount = 1;
sC.CreateTime = DateTime.Now;
sC.UpdateTime = DateTime.Now;
db.SigninCredit.Add(sC);
}
else
{
sccun.CreditsCount = sccun.CreditsCount + 1;
sccun.UpdateTime = DateTime.Now;
db.Entry <SigninCredit>(sccun).State = EntityState.Modified;
}
db.SaveChanges();
return("OK");
}
else
{
return("2");
}
}
catch (Exception)
{
return("No");
}
}
public string UpdateSingle(dynamic bannerDate)
{
try
{
string updateSingle = JsonConvert.SerializeObject(bannerDate);
Banner q = JsonConvert.DeserializeObject <Banner>(updateSingle);
var d = (from v in db.Banner
where v.BannerId == q.BannerId
select v).FirstOrDefault();
q.BannerId = 0;
d.PicUrl = q.PicUrl;
d.Link = q.Link;
d.PriorityId = q.PriorityId;
d.IsDisplay = q.IsDisplay;
d.BannerType = q.BannerType;
d.UpdatePerson = q.UpdatePerson;
d.UpdateTime = DateTime.Now;
db.Entry <Banner>(d).State = EntityState.Modified;
db.SaveChanges();
return("OK");
}
catch (Exception)
{
return("No");
}
}
public int UpdateAddress(dynamic requestData)
{
string query = JsonConvert.SerializeObject(requestData);
Address model = JsonConvert.DeserializeObject <Address>(query);
if (model.IsDefault == 1)
{
string sql = string.Format("Update [Address] Set IsDefault = 0 Where MemberId = {0}", model.MemberId);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
}
EntityState statebefore = db.Entry(model).State;
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(model.AddressId);
}
public string AddECWXTranspondDetails(dynamic requestData)
{
try
{
string BrowseDetails = JsonConvert.SerializeObject(requestData);
var q = JsonConvert.DeserializeObject <ECWXTranspondDetails>(BrowseDetails);
//是否包含
var IsUV = (from v in db.ECWXTranspondDetails
where v.ECBrowseURL == q.ECBrowseURL && v.OpenId == q.OpenId
select v).FirstOrDefault();
//查找EC总的是否有
var qECBrowse = (from v in db.ECBrowse
where v.ECURL == q.ECBrowseURL
select v).FirstOrDefault();
if (IsUV == null)
{
if (qECBrowse == null)
{
ECBrowse newqECBrowse = new ECBrowse();
newqECBrowse.ECURL = q.ECBrowseURL;
newqECBrowse.Transpond = 1;
db.ECBrowse.Add(newqECBrowse);
}
else
{
qECBrowse.Transpond = qECBrowse.Transpond + 1;
db.Entry <ECBrowse>(qECBrowse).State = EntityState.Modified;
}
}
else
{
qECBrowse.Transpond = qECBrowse.Transpond + 1;
db.Entry <ECBrowse>(qECBrowse).State = EntityState.Modified;
}
db.ECWXTranspondDetails.Add(q);
db.SaveChanges();
return("OK");
}
catch (Exception)
{
return("No");
}
}
public ActionResult Edit([Bind(Include = "CreditId,Head,Period,Sum,Procent")] Credit credit)
{
if (ModelState.IsValid)
{
db.Entry(credit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(credit));
}
public ActionResult Edit([Bind(Include = "BidId,Name,CreditHead,bidDate")] Bid bid)
{
if (ModelState.IsValid)
{
db.Entry(bid).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bid));
}
public string UpdateCultivate(CultivateInterflow cu)
{
var q = (from v in db.CultivateInterflow
where v.CuInterId == cu.CuInterId
select v).FirstOrDefault();
cu.CuInterId = 0;
q.CurriculumName = cu.CurriculumName;
q.CurriculumType = cu.CurriculumType;
q.Url = cu.Url;
q.Priority = cu.Priority;
q.IsDisplay = cu.IsDisplay;
q.Introduce = cu.Introduce;
if (q.Introduce.IndexOf("base64") > 0)
{
string d = q.Introduce;
foreach (string a in imgHandel.GetHtmlImageUrlList(d))
{
if (a.IndexOf(ImgHandle.DNS) < 0)
{
string[] asplit = a.Split(',');
string imgtype = asplit[0].Substring(11, asplit[0].Length - 18);
string filepath = imgHandel.Base64StringToImage(asplit[1], imgtype, "/pic/Lecturer");
d = d.Replace(a, filepath);
}
}
q.Introduce = d;
}
q.UpdatePerson = cu.UpdatePerson;
q.UpdateTime = DateTime.Now;
db.Entry <CultivateInterflow>(q).State = EntityState.Modified;
db.SaveChanges();
return(null);
}
public string AddMatchRegion(dynamic requestData)
{
try
{
string addMatchRegion = JsonConvert.SerializeObject(requestData);
List <MatchRegion> model = JsonConvert.DeserializeObject <List <MatchRegion> >(addMatchRegion);
////var allDel = string.Format(@"DELETE MatchRegion where ChefActivityId={0}", model[0].ChefActivityId);
//dataContext.ExecuteNonQuery(CommandType.Text, allDel);
foreach (MatchRegion m in model)
{
var q = (from v in db.MatchRegion
where v.MatchRegionId == m.MatchRegionId
select v).FirstOrDefault();
if (q != null)
{
m.CityName = m.AreaName;
// m.CreateTime = DateTime.Now;
m.UpdateTime = DateTime.Now;
q.AreaName = m.AreaName;
q.BeginTime = m.BeginTime;
q.CityName = m.AreaName;
q.EndTime = m.EndTime;
q.ProvinceName = m.ProvinceName;
q.UpdatePerson = m.UpdatePerson;
q.UpdateTime = DateTime.Now;
m.MatchRegionId = 0;
db.Entry <MatchRegion>(q).State = EntityState.Modified;
}
else
{
m.CityName = m.AreaName;
m.CreateTime = DateTime.Now;
m.UpdateTime = DateTime.Now;
//db.MatchRegion.Add(m);
//db.SaveChanges();
var sql = string.Format("INSERT INTO [dbo].[MatchRegion]([ProvinceName],[CityName],[AreaName],[ChefActivityId],[BeginTime],[EndTime],[CreatePerson],[UpdatePerson],[CreateTime],[UpdateTime],[Remark])VALUES('{0}','{1}','{2}',{3},'{4}','{5}','{6}','{7}','{8}','{9}','{10}')", m.ProvinceName, m.CityName, m.AreaName, m.ChefActivityId, m.BeginTime, m.EndTime, m.CreatePerson, m.UpdatePerson, m.CreateTime, m.UpdateTime, m.Remark);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
}
}
db.SaveChanges();
return("OK");
}
catch (Exception)
{
return("No");
}
}
public string UpdateSingle(dynamic bannerDate)
{
try
{
string updateSingle = JsonConvert.SerializeObject(bannerDate);
var model = JsonConvert.DeserializeObject <Tutor>(updateSingle);
if (model.Introduce.IndexOf("base64") > 0)
{
string d = model.Introduce;
GetHtmlImageUrlList(d);
foreach (string a in GetHtmlImageUrlList(d))
{
if (a.IndexOf(ImgHandle.DNS) < 0)
{
string[] asplit = a.Split(',');
string imgtype = asplit[0].Substring(11, asplit[0].Length - 18);
string filepath = Base64StringToImage(asplit[1], imgtype);
d = d.Replace(a, filepath);
}
}
model.Introduce = d;
}
model.UpdateTime = DateTime.Now;
db.Entry <Tutor>(model).State = EntityState.Modified;
db.Entry <Tutor>(model).Property <DateTime>(v => v.CreateTime).IsModified = false;
db.Entry <Tutor>(model).Property <string>(v => v.CreatePerson).IsModified = false;
db.Entry <Tutor>(model).Property <int>(v => v.IsDel).IsModified = false;
db.Entry <Tutor>(model).Property <string>(v => v.TutorComment).IsModified = false;
db.SaveChanges();
return("OK");
}
catch (Exception)
{
return("No");
}
}
public string AddChef(Chef requestData)
{
try
{
//string query = JsonConvert.SerializeObject(requestData);
//Chef model = JsonConvert.DeserializeObject<Chef>(query);
Chef model = requestData;
if (model.Birthday == Convert.ToDateTime("0001/1/1 0:00:00"))
{
model.Birthday = Convert.ToDateTime("1900-1-1");
}
var q = (from v in db.Chef
where v.MemberId == model.MemberId && v.ChefActivityId == model.ChefActivityId
select v
).FirstOrDefault();
if (q == null)
{
db.Chef.Add(model);
db.SaveChanges();
return(model.ChefId.ToString());
}
else
{
q.MemberId = model.MemberId;
q.ChefActivityId = model.ChefActivityId;
q.MatchRegionId = model.MatchRegionId;
q.ApplyType = model.ApplyType;
q.ReferrerName = model.ReferrerName;
q.Birthday = model.Birthday;
q.ChefPicUrl = model.ChefPicUrl;
//q.ChefHotelName = model.ChefHotelName;
q.ChefHotelPicUrl = model.ChefHotelPicUrl;
db.Entry <Chef>(q).State = EntityState.Modified;
db.SaveChanges();
string update = "update DishChef set IsApply=0 where ChefId=" + q.ChefId;
dataContext.ExecuteNonQuery(CommandType.Text, update);
return(q.ChefId.ToString());
}
}
catch (Exception)
{
return("No");
}
}
public string UpdateIsEnable(dynamic requestDate)
{
try
{
var qchefActivity = (from v in db.ChefActivity
where v.IsEnable == 1
select v).FirstOrDefault();
if (qchefActivity != null)
{
if (qchefActivity.IsEnable == 1)
{
if (qchefActivity != null)
{
qchefActivity.IsEnable = 0;
db.Entry <ChefActivity>(qchefActivity).State = EntityState.Modified;
db.SaveChanges();
}
}
}
ChefActivity chefActivity = new ChefActivity();
chefActivity.ChefActivityId = requestDate.ChefActivityId;
chefActivity.ChefActivityName = requestDate.ChefActivityName;
chefActivity.IsEnable = requestDate.IsEnable;
chefActivity.UpdatePerson = requestDate.UpdatePerson;
chefActivity.UpdateTime = DateTime.Now;
//db.Entry<ChefActivity>(chefActivity).State = EntityState.Modified;
//db.Entry<ChefActivity>(chefActivity).Property("CreatePerson").IsModified = false;
//db.Entry<ChefActivity>(chefActivity).Property("CreateTime").IsModified = false;
//db.SaveChanges();
var sql = string.Format(@"update ChefActivity set ChefActivityName='{0}',IsEnable={1},UpdatePerson='{2}',UpdateTime='{3}' where ChefActivityId={4}", chefActivity.ChefActivityName, chefActivity.IsEnable, chefActivity.UpdatePerson, chefActivity.UpdateTime, chefActivity.ChefActivityId);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
return("OK");
}
catch (Exception e)
{
return("No");
}
}
public string AddDishTutor(dynamic requestData)
{
try
{
string addDishTutor = JsonConvert.SerializeObject(requestData);
DishTutor model = JsonConvert.DeserializeObject <DishTutor>(addDishTutor);
var IsExist = (from v in db.DishTutor
where v.TutorId == model.TutorId && v.DishType == model.DishType
select v).FirstOrDefault();
//等于空就增加
if (IsExist == null)
{
if (model.DishStory.IndexOf("base64") > 0)
{
string d = model.DishStory;
foreach (string a in imgHandel.GetHtmlImageUrlList(d))
{
if (a.IndexOf(ImgHandle.DNS) < 0)
{
string[] asplit = a.Split(',');
string imgtype = asplit[0].Substring(11, asplit[0].Length - 18);
string filepath = imgHandel.Base64StringToImage(asplit[1], imgtype, "/pic/Dishtutor");
d = d.Replace(a, filepath);
}
}
model.DishStory = d;
}
model.CreateTime = DateTime.Now;
model.UpdateTime = DateTime.Now;
model.VisitCount = 0;
model.PrasieCount = 0;
model.ShareCount = 0;
db.DishTutor.Add(model);
db.SaveChanges();
return(model.TutorDishId.ToString());
}
//不为空就是修改
else
{
IsExist.UpdateTime = DateTime.Now;
IsExist.DishName = model.DishName;
IsExist.DishStory = model.DishStory;
if (IsExist.DishStory.IndexOf("base64") > 0)
{
string d = IsExist.DishStory;
foreach (string a in imgHandel.GetHtmlImageUrlList(d))
{
if (a.IndexOf(ImgHandle.DNS) < 0)
{
string[] asplit = a.Split(',');
string imgtype = asplit[0].Substring(11, asplit[0].Length - 18);
string filepath = imgHandel.Base64StringToImage(asplit[1], imgtype, "/pic/Dishtutor");
d = d.Replace(a, filepath);
}
}
IsExist.DishStory = d;
}
IsExist.DishPicUrl = model.DishPicUrl;
IsExist.UpdatePerson = model.UpdatePerson;
db.Entry <DishTutor>(IsExist).State = EntityState.Modified;
db.SaveChanges();
return(IsExist.TutorDishId.ToString());
}
}
catch (Exception)
{
return("No");
}
}
