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 GetSaleManInfo(dynamic requestData) { try { int salemanId = requestData.SalemanId; RegistSaleMan model = db.RegistSaleMan.Find(salemanId); return(JsonConvert.SerializeObject(model)); } catch (Exception ex) { return(ex.Message); } }
public string GetSaleManInfo(dynamic requestData) { try { int salemanId = requestData.SalemanId; RegistSaleMan model = db.RegistSaleMan.Find(salemanId); var q = JsonConvert.SerializeObject(model); string sql = string.Format("Select * from [SalemanArea] Where SalemanId = {0}", salemanId); var area = dataContext.ExecuteDataTable(CommandType.Text, sql); return("{ \"Data\":" + JsonConvert.SerializeObject(q) + ", \"Area\":" + JsonConvert.SerializeObject(area) + "}"); } catch (Exception ex) { return(ex.Message); } }
public string AddRegistSaleMan(dynamic requestData) { OpenIdAssociated openbase = new OpenIdAssociated(); RegistSaleMan saleman = new RegistSaleMan(); saleman.ProvinceId = requestData.ProvinceId; saleman.ProvinceName = requestData.ProvinceName; saleman.CityId = requestData.CityId; saleman.CityName = requestData.CityName; saleman.AreaId = requestData.AreaId; saleman.AreaName = requestData.AreaName; saleman.RegionId = requestData.RegionId; saleman.RegionName = requestData.RegionName; saleman.WorkNum = requestData.WorkNum; saleman.Name = requestData.Name; saleman.Telephone = requestData.Telephone; saleman.CardId = requestData.CardId; saleman.RegistDate = DateTime.Now; saleman.RegistState = 0; saleman.Remark = ""; saleman.ImportDate = null; saleman.IsEnable = 0; db.RegistSaleMan.Add(saleman); db.SaveChanges(); #region 获取用户OpenId if (requestData.OpenId != null) { openbase.OpenId = requestData.OpenId; openbase.UserId = saleman.SalemanId; openbase.UserType = 1; openbase.Nickname = requestData.Nickname; openbase.HeadImgUrl = requestData.HeadImgUrl; openbase.CreateDate = DateTime.Now; db.OpenIdAssociated.Add(openbase); db.SaveChanges(); } #endregion return(saleman.SalemanId.ToString()); }
public string AddRegistSaleMan(dynamic requestData) { OpenIdAssociated openbase = new OpenIdAssociated(); RegistSaleMan saleman = new RegistSaleMan(); saleman.ProvinceId = requestData.ProvinceId; saleman.ProvinceName = requestData.ProvinceName; saleman.CityId = requestData.CityId; saleman.CityName = requestData.CityName; saleman.AreaId = requestData.AreaId; saleman.AreaName = requestData.AreaName; //saleman.RegionId = requestData.RegionId; //saleman.RegionName = requestData.RegionName; saleman.Position = requestData.Position; saleman.Telephone = requestData.Telephone; string sql = string.Format("SELECT COUNT(1) total FROM dbo.RegistSaleMan WHERE Telephone = '{0}'", saleman.Telephone); int salemancount = Convert.ToInt16(dataContext.ExecuteScalar(CommandType.Text, sql)); if (salemancount == 0) { string tempPositon = "STL、RI、WSI、CSI"; //这四个职位的工号必填 if (tempPositon.Contains(saleman.Position)) { string workNum = requestData.WorkNum; if (string.IsNullOrEmpty(workNum)) { return("该职位必须填写工号"); } } saleman.WorkNum = requestData.WorkNum; saleman.Name = requestData.Name; saleman.CardId = requestData.CardId; saleman.RegistDate = DateTime.Now; saleman.RegistState = 0; saleman.Remark = ""; saleman.ImportDate = null; saleman.IsEnable = 0; db.RegistSaleMan.Add(saleman); db.SaveChanges(); #region 获取用户OpenId if (requestData.OpenId != null) { openbase.OpenId = requestData.OpenId; openbase.UserId = saleman.SalemanId; openbase.UserType = 1; openbase.Nickname = requestData.Nickname; openbase.HeadImgUrl = requestData.HeadImgUrl; openbase.CreateDate = DateTime.Now; db.OpenIdAssociated.Add(openbase); db.SaveChanges(); } #endregion return(saleman.SalemanId.ToString()); } else { return("该手机号已注册"); } }