/// <summary>
/// 存储编辑信息 Product主款号表
/// </summary>通过款号对styledescript进行修改 存储信息为产品描述
public int Updatestyledescript(string style, string productDescript, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var check = context.styledescript.Where(a => a.style == style).FirstOrDefault();
if (check != null)//判断是否已存描述信息 存在则update 不存在则insert
{
var q = context.styledescript.Where(a => a.style == style);
foreach (var item in q)
{
item.productDescript = productDescript; //描述
item.UserId = UserId; //操作人
}
context.SubmitChanges();
}
else
{
model.styledescript m = new model.styledescript()
{
style = style, //款号
productDescript = productDescript, //描述
UserId = UserId, //操作人
};
context.styledescript.InsertOnSubmit(m);
context.SubmitChanges();
}
return(1);
}
catch (Exception ex)
{
return(-1);
}
}
/// <summary>
/// 保存编辑客户信息
/// </summary>
/// <returns></returns>
public string SaveEdit(Dictionary <string, string> Dic, int UserId)
{
string s = string.Empty;
int? item = null;
try
{
pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.custom.Where(a => a.Id == Convert.ToInt32(Dic["Id"]));
foreach (var i in q)
{
//i.CustomerId = Dic["CustomerId"];
i.Shop = Dic["Shop"];
i.Contactperson = Dic["Contactperson"];
i.Sex = Dic["Sex"] == "" ? item : Convert.ToInt32(Dic["Sex"]);
i.Age = Dic["Age"] == "" ? item : Convert.ToInt32(Dic["Age"]);
i.Birthday = Dic["Birthday"];
i.IDNumber = Dic["IDNumber"];
i.Telephone = Dic["Telephone"];
i.Phone = Dic["Phone"];
i.Weixin = Dic["Weixin"];
i.QQNo = Dic["QQNo"];
i.CustomerLevel = Dic["CustomerLevel"];
i.Remark = Dic["Remark"];
i.CustomerServiceId = UserId;
}
context.SubmitChanges();
s = "修改成功!";
}
catch (Exception ex)
{
s = "修改失败!";
}
return(s);
}
/// <summary>
/// 更新季节
/// </summary>
/// <returns></returns>
public string UpdateSeason(string Id, string Cat1, int UserId)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var Check = context.Season.Where(a => a.Cat1 == Cat1);
var q = context.Season.Where(a => a.Id == Convert.ToInt32(Id));
if (Check.Count() == 0)
{
foreach (var i in q)
{
i.Cat1 = Cat1;
}
context.SubmitChanges();
s = "修改成功!";
}
else
{
s = "该季节已存在!";
}
}
catch (Exception ex)
{
s = "修改失败!";
}
return(s);
}
/// <summary>
/// 添加季节
/// </summary>
/// <returns></returns>
public string AddSeason(string Cat1, int UserId)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.Season.Where(a => a.Cat1 == Cat1);
if (q.Count() == 0)
{
model.Season ms = new model.Season()
{
Cat1 = Cat1,//季节
};
context.Season.InsertOnSubmit(ms);
context.SubmitChanges();
s = "添加成功!";
}
else
{
s = "该季节已存在!";
}
}
catch (Exception ex)
{
s = "添加失败!";
}
return(s);
}
/// <summary>
/// 编辑客户地址
/// </summary>
/// <returns></returns>
public string SaveEditAddress(Dictionary <string, string> Dic, int UserId)
{
string s = string.Empty;
try
{
pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.customAddress.Where(a => a.Id == Convert.ToInt32(Dic["Id"]));
foreach (var i in q)
{
i.Provinces = Dic["Provinces"];
i.City = Dic["City"];
i.District = Dic["District"];
i.CusAddress = Dic["CusAddress"];
i.CustomerServiceId = UserId;
i.UserId = UserId;
}
context.SubmitChanges();
s = "保存成功!";
}
catch (Exception ex)
{
s = "编辑失败!";
}
return(s);
}
/// <summary>
/// 添加客户地址
/// </summary>
/// <returns></returns>
public string SaveAddAddress(Dictionary <string, string> Dic, int UserId)
{
string s = string.Empty;
try
{
pbxdatasourceDataContext context = new pbxdatasourceDataContext();
model.customAddress mc = new model.customAddress()
{
CustomerId = Dic["CustomerId"], //客户Id
Provinces = Dic["Provinces"], //所在省
City = Dic["City"], //所在城市
District = Dic["District"], //所在地区
CusAddress = Dic["CusAddress"], //具体地址
CustomerServiceId = UserId, //处理客服
UserId = UserId, //操作人
};
context.customAddress.InsertOnSubmit(mc);
context.SubmitChanges();
s = "添加成功!";
}
catch (Exception ex)
{
s = "添加失败!";
}
return(s);
}
/// <summary>
/// 导入excell中的客户信息到custom表
/// </summary>
/// <returns></returns>
public string UploadExcel()
{
try
{
string s = "导入成功!";
DataTable dt = new DataTable();
pbxdatasourceDataContext context = new pbxdatasourceDataContext();
HttpPostedFileBase file1 = Request.Files[0];
string newFile = DateTime.Now.ToString("yyyyMMddHHmmss");
string filePath = newFile + file1.FileName; //生成新名字
file1.SaveAs(Server.MapPath("~/Uploadxls/" + filePath)); //存到本地
dt = GetExcellData(Server.MapPath("~/Uploadxls/" + filePath), "Sheet1$").Tables[0]; //把excel转换成datatable
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][0].ToString() != "")
{
int check = context.custom.Where(a => a.CustomerId == dt.Rows[i][0].ToString()).Count();//查询是否存在
if (check > 0)
{
s += dt.Rows[i][0] + ":已存在<br />";
}
else
{
custom cu = new custom()
{
CustomerId = dt.Rows[i][0].ToString(),
Shop = dt.Rows[i][1].ToString(),
Contactperson = dt.Rows[i][2].ToString(),
Sex = dt.Rows[i][3].ToString() == "女" ? 0 : 1,
Age = Convert.ToInt32(dt.Rows[i][4].ToString()),
Birthday = Convert.ToDateTime(dt.Rows[i][5].ToString()).ToString("yyyy-MM-dd"),
IDNumber = dt.Rows[i][6].ToString(),
Telephone = dt.Rows[i][7].ToString(),
Phone = dt.Rows[i][8].ToString(),
Weixin = dt.Rows[i][9].ToString(),
QQNo = dt.Rows[i][10].ToString(),
CustomerLevel = dt.Rows[i][11].ToString(),
Remark = dt.Rows[i][12].ToString(),
CustomerServiceId = Convert.ToInt32(dt.Rows[i][13].ToString()),
};
context.custom.InsertOnSubmit(cu);
context.SubmitChanges();
}
}
}
return(s);
}
catch (Exception ex)
{
return("导入失败!");
}
}
/// <summary>
/// 删除备注
/// </summary>
public string DeleteRemark(string Id)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.apiOrderRemark.Where(a => a.Id == Convert.ToInt32(Id));
context.apiOrderRemark.DeleteOnSubmit(q.First());
context.SubmitChanges();
return("删除成功！");
}
catch (Exception ex)
{
return("删除失败！");
}
}
/// <summary>
/// 添加品牌
/// </summary>
public string AddBrand(string BrandName, string BrandAbridge, string Def2, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var check = context.brand.Where(a => a.BrandAbridge == BrandAbridge).Where(a => a.BrandName == BrandName).ToList();
if (check.Count > 0)//--根据品牌缩写判断是否存在
{
return("品牌名或缩写重复!");
}
else
{
model.brand brand = new model.brand()
{
BrandName = BrandName,
BrandAbridge = BrandAbridge,
Def2 = Def2,
};
context.brand.InsertOnSubmit(brand);
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->AddBrand()",
ErrorMsg = "添加",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "添加品牌->" + BrandName,
UserId = UserId,
});
return("添加成功!");
}
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->AddBrand()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("修改失败!");
}
}
/// <summary>
/// 添加淘宝品牌
/// </summary>
public string AddTBBrand(string TBBrandName, string vid, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var check = context.TBBrand.Where(a => a.TBBrandName == TBBrandName && a.vid == vid).ToList();
if (check.Count > 0)
{
return("该品牌已存在!");
}
else
{
model.TBBrand tb = new model.TBBrand()
{
TBBrandName = TBBrandName, //淘宝品牌名
vid = vid, //淘宝编码
};
context.TBBrand.InsertOnSubmit(tb);
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->AddTBBrand()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "添加淘宝品牌->" + TBBrandName,
UserId = UserId,
});
return("添加成功!");
}
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->AddTBBrand()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("添加失败!");
}
}
/// <summary>
/// 添加客户信息
/// </summary>
/// <returns></returns>
public string AddCustomer(Dictionary <string, string> Dic, int UserId)
{
string s = string.Empty;
try
{
pbxdatasourceDataContext context = new pbxdatasourceDataContext();
int check = context.custom.Where(a => a.CustomerId == Dic["CustomerId"]).Count();
int?item = null;
if (check > 0)
{
s = "该客户信息已存在!";
}
else
{
model.custom mc = new model.custom()
{
CustomerId = Dic["CustomerId"], //客户Id
Shop = Dic["Shop"], //来源
Contactperson = Dic["Contactperson"], //联系人
Sex = Dic["Sex"] == "" ? item : Convert.ToInt32(Dic["Sex"]), //性别
Age = Dic["Age"] == "" ? item : Convert.ToInt32(Dic["Age"]), //年龄
Birthday = Dic["Birthday"], //出生日期
IDNumber = Dic["IDNumber"], //身份证
Telephone = Dic["Telephone"], //手机
Phone = Dic["Phone"], //电话
Weixin = Dic["Weixin"], //微信
QQNo = Dic["QQNo"], //QQ
CustomerLevel = Dic["CustomerLevel"], //客户等级
Remark = Dic["Remark"], //备注
CustomerServiceId = UserId, //处理客服
};
context.custom.InsertOnSubmit(mc);
context.SubmitChanges();
s = "添加客户信息成功!";
}
}
catch (Exception ex)
{
s = "添加失败!";
}
return(s);
}
/// <summary>
/// 修改备注
/// </summary>
public string EditRemark(Dictionary <string, string> Dic)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.apiOrderRemark.Where(a => a.Id == Convert.ToInt32(Dic["Id"]));
foreach (var item in q)
{
item.Remark = Dic["Remark"];
item.Edittime = Dic["Edittime"];
}
context.SubmitChanges();
return("修改成功！");
}
catch (Exception ex)
{
return("修改失败！");
}
}
/// <summary>
/// 删除客户信息
/// </summary>
/// <returns></returns>
public string DeleteCustomer(string Id, int UserId)
{
string s = string.Empty;
try
{
pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.custom.Where(a => a.Id == Convert.ToInt32(Id));//通过Id删除客户信息
foreach (var i in q)
{
context.custom.DeleteOnSubmit(i);
}
context.SubmitChanges();
s = "";
}
catch (Exception ex)
{
s = "删除失败!";
}
return(s);
}
/// <summary>
/// 添加备注
/// </summary>
public string UpdateApiOrder(Dictionary <string, string> Dic)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
model.apiOrderRemark tt = new model.apiOrderRemark()
{
OrderId = Dic["OrderId"],
Edittime = Dic["Edittime"],
Remark = Dic["Remark"],
UserId = Convert.ToInt32(Dic["UserId"]),
};
context.apiOrderRemark.InsertOnSubmit(tt);
context.SubmitChanges();
return("添加成功！");
}
catch (Exception ex)
{
return("添加失败！");
}
}
/// <summary>
/// 更新品牌对应的淘宝编号
/// </summary>
public string UpdateBrand(string BrandName, string BrandAbridge, string Vid, string Def2, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.brand.Where(a => a.BrandAbridge == BrandAbridge);//--根据品牌缩写Update
foreach (var i in q)
{
i.BrandName = BrandName;
i.Def1 = Vid;
i.Def2 = Def2;
}
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()//--操作日志
{
errorSrc = "pbxdata.dal->BrandDal->UpdateBrand()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "更新品牌对应的淘宝编号->" + BrandName,
UserId = UserId,
});
return("更新成功!");
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->UpdateBrand()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("更新失败!");
}
}
/// <summary>
/// 删除供应商类别
/// </summary>
public string deleteBrandVen(string Id, int UserId)
{
try
{
string item = "";
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.BrandVen.Where(a => a.Id == Convert.ToInt32(Id));//通过id删除
foreach (var i in q)
{
item = i.BrandNameVen;
context.BrandVen.DeleteOnSubmit(i);
}
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()//--操作日志
{
errorSrc = "pbxdata.dal->BrandDal->deleteBrandVen()",
ErrorMsg = "删除",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "修改供应商品牌表->" + item,
UserId = UserId,
});
return("删除成功!");
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->deleteBrandVen()",
ErrorMsg = "删除",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("删除失败!");
}
}
/// <summary>
/// 删除季节
/// </summary>
/// <returns></returns>
public string DeleteSeason(string Cat1, int UserId)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.Season.Where(a => a.Cat1 == Cat1);
foreach (var i in q)
{
context.Season.DeleteOnSubmit(i);
}
context.SubmitChanges();
s = "";
}
catch (Exception ex)
{
s = "删除失败!";
}
return(s);
}
/// <summary>
/// 更新淘宝品牌
/// </summary>
public string UpdateTBBrand(string TBBrandName, string vid, string Id, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.TBBrand.Where(a => a.Id == Convert.ToInt32(Id));
foreach (var i in q)
{
i.TBBrandName = TBBrandName; //淘宝品牌名
i.vid = vid; //淘宝编码
}
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->DeleteBrand()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "更新淘宝品牌->" + TBBrandName,
UserId = UserId,
});
return("修改成功!");
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->UpdateTBBrand()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("修改失败!");
}
}
/// <summary>
/// 删除品牌
/// </summary>
public string DeleteBrand(string BrandName, string BrandAbridge, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
var q = context.brand.Where(a => a.BrandName == BrandName & a.BrandAbridge == BrandAbridge);
foreach (var i in q)//--根据品牌名和品牌缩写删除
{
context.brand.DeleteOnSubmit(i);
}
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->DeleteBrand()",
ErrorMsg = "删除",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "删除品牌->" + BrandName,
UserId = UserId,
});
return("");
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->DeleteBrand()",
ErrorMsg = "删除",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("删除失败!");
}
}
/// <summary>
/// 更新供应商季节
/// </summary>
/// <returns></returns>
public string UpdateSeasonVen(Dictionary <string, string> dic, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
if (dic["Id"] == "0")//通过id来获取是Update还是insert
{
var q = context.SeasonVen.Where(a => a.Cat1Ven == dic["Cat1Ven"]).Where(a => a.Vencode == dic["Vencode"]).ToList();
if (q.Count == 0)//判断是否已存在
{
model.SeasonVen mc = new model.SeasonVen()
{
Cat1 = dic["Cat1"], //季节
Cat1Ven = dic["Cat1Ven"], //供应商季节
Vencode = dic["Vencode"], //供应商
};
context.SeasonVen.InsertOnSubmit(mc);
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->SeasonDal->UpdateSeasonVen()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "添加供应季节表->" + dic["Cat1Ven"],
UserId = UserId,
});
}
else
{
return("该季节已存在!");
}
}
else
{
var q = from c in context.SeasonVen where c.Id == Convert.ToInt32(dic["Id"].ToString()) select c;
foreach (var i in q)
{
i.Cat1 = dic["Cat1"];
i.Cat1Ven = dic["Cat1Ven"];
i.Vencode = dic["Vencode"];
}
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->SeasonDal->UpdateSeasonVen()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "修改供应季节表->" + dic["Cat1Ven"],
UserId = UserId,
});
}
return("修改成功!");
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->SeasonDal->UpdateSeasonVen()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("修改失败!");
}
}
/// <summary>
/// 更新供应商品牌表
/// </summary>
/// <returns></returns>
public string UpdateBrandVen(Dictionary <string, string> dic, int UserId)
{
try
{
model.pbxdatasourceDataContext context = new pbxdatasourceDataContext();
if (dic["Id"] == "0")//--判断是否存在 存在则更新不存在插入
{
var q = context.BrandVen.Where(a => a.BrandNameVen == dic["BrandNameVen"]).Where(a => a.Vencode == dic["Vencode"]).ToList();
if (q.Count == 0)
{
model.BrandVen BV = new model.BrandVen()
{
BrandName = dic["BrandName"],
BrandAbridge = dic["BrandAbridge"],
BrandNameVen = dic["BrandNameVen"],
Vencode = dic["Vencode"],
};
context.BrandVen.InsertOnSubmit(BV);
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->UpdateProducttypeVen()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "添加供应商品牌表->" + dic["BrandNameVen"],
UserId = UserId,
});
}
else
{
return("该品牌已存在!");
}
}
else
{
var q = from c in context.BrandVen where c.Id == Convert.ToInt32(dic["Id"].ToString()) select c;
foreach (var i in q)
{
i.BrandName = dic["BrandName"];
i.BrandAbridge = dic["BrandAbridge"];
i.BrandNameVen = dic["BrandNameVen"];
i.Vencode = dic["Vencode"];
}
context.SubmitChanges();
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->UpdateProducttypeVen()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 2,
errorMsgDetails = "修改供应商品牌表->" + dic["BrandNameVen"],
UserId = UserId,
});
}
return("修改成功!");
}
catch (Exception ex)
{
dal.InsertErrorlog(new model.errorlog()
{
errorSrc = "pbxdata.dal->BrandDal->UpdateProducttypeVen()",
ErrorMsg = "修改",
errorTime = DateTime.Now,
operation = 1,
errorMsgDetails = ex.Message,
UserId = UserId,
});
return("修改失败!");
}
}
