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("该手机号已注册");
}
}
