//
public ActionResult AddProductSupplier(string supplier, int proid)
{
ComResult com = new ComResult();
try
{
base_prod_supp_rel suppid = _service.AddProductSupplier(supplier, proid);
if (null == suppid)
{
com.Msg = "添加失败";
com.State = 0;
return(Json(com));
}
else
{
com.Msg = "";
com.State = 1;
com.DataResult = suppid;
return(Json(com));
}
}
catch (Exception ex)
{
com.Msg = ex.Message;
com.State = 0;
return(Json(com));
}
}
public base_prod_supp_rel AddProductSupplier(string supplier, int proid)
{
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
try
{
base_supplier isin = db.Queryable <base_supplier>().Where(s => s.supp_name == supplier).FirstOrDefault();
if (null == isin)
{
throw new Exception("此供应商不存在系统中");
}
//判断是否绑定过
base_prod_supp_rel isinsupp = db.Queryable <base_prod_supp_rel>().Where(s => s.prod_id == proid).Where(s => s.supp_id == isin.supp_id).FirstOrDefault();
if (null != isinsupp)
{
throw new Exception("已经绑定过此供应商不能重复绑定");
}
int levl = 1;
base_prod_supp_rel isexit = db.SqlQuery <base_prod_supp_rel>("select top 1 * from base_prod_supp_rel where prod_id=@prod_id order by lev_purch desc", new { prod_id = proid }).FirstOrDefault();
if (null == isexit)
{
levl = 1;
}
else
{
levl = isexit.lev_purch.ObjToInt() + 1;
}
base_prod_supp_rel newsupp = new base_prod_supp_rel();
newsupp.create_time = DateTime.Now;
newsupp.create_user_id = LoginUser.Current.user_id;
newsupp.del_flag = true;
newsupp.del_time = DateTime.Now;
newsupp.edit_time = DateTime.Now;
newsupp.edit_user_id = LoginUser.Current.user_id;
newsupp.lev_purch = (Byte?)levl;
newsupp.supp_id = isin.supp_id;
newsupp.prod_id = proid;
var isok = db.Insert <base_prod_supp_rel>(newsupp);
newsupp.rel_id = isok.ObjToInt();
return(newsupp);
}
catch (Exception ex)
{
throw ex;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DateTime start = DateTime.Now;
busi_product prolist = null;
busi_supplier oldsupp = null;
List <busi_productsku> skulist = null;
List <busi_product> myprolist = null;
int proid = 0;
int codeid = 0;
int suppid = 0;
using (var db = SugarDao.GetInstance(SugarDao.ConnectionGloablString))//原先数据库
{
myprolist = db.Queryable <busi_product>().Where(s => s.IsDel == false).Where(s => s.ProID > 0).OrderBy(s => s.ProID, OrderByType.Desc).ToList();
}
foreach (busi_product myitem in myprolist)
{
using (var db = SugarDao.GetInstance(SugarDao.ConnectionGloablString))//原先数据库
{
try
{
//prolist = db.Queryable<busi_product>().Where(s => s.IsDel == false).Where(s => s.ProID > 0).OrderBy(s => s.ProID).Take(1).First();
prolist = myitem;
skulist = db.Queryable <busi_productsku>().Where(s => s.IsDel == false).Where(s => s.ProID == prolist.ProID).ToList();
if (skulist.Count == 0)
{
continue;
}
oldsupp = db.Queryable <busi_supplier>().Where(s => s.SupplierID == prolist.SupplierID).FirstOrDefault();
if (null == oldsupp)
{
continue;
}
}
catch (Exception ex)
{
throw ex;
}
}
using (var db = SugarDao.GetInstance(SugarDao.ConnectionString))//新数据库
{
try
{
base_product add = new base_product(); //添加产品
add.brand_id = 1;
add.create_time = DateTime.Now;
add.create_user_id = 1;
add.del_flag = true;
add.del_time = null;
add.del_user_id = 0;
add.edit_time = DateTime.Now;
add.edit_user_id = 0;
add.ex_type = 0;
add.pic_url = prolist.PicUrl; //产品主图
add.bgcode = prolist.BCode;
add.pre_weight = prolist.SWeight;
add.price_us = Convert.ToDecimal(prolist.PriceR);
add.price_cn = Convert.ToDecimal(prolist.PriceR);
add.prod_class_id = Convert.ToInt32(prolist.CID);
add.prod_developer = prolist.DevePeople;
add.prod_picpath = "";
add.prod_property = 1; //Convert.ToInt32(clasf);
add.prod_status = 0;
add.prod_style = prolist.Code;
add.prod_title = prolist.Name;
add.prod_url = prolist.Url;
add.real_weight = prolist.SWeight;
add.remark = prolist.Remark;
add.title_en = "";
add.title_jp = "";
add.model = prolist.Model;
add.size = prolist.Size;
proid = db.Insert <base_product>(add).ObjToInt();
base_supplier isin = db.Queryable <base_supplier>().Where(s => s.supp_name == oldsupp.Name).FirstOrDefault();
if (null == isin) //不存在
{
base_supplier supp = new base_supplier(); //添加供应商,需要先判断这个供应商是否存在系统里
supp.create_user_id = 1;
supp.del_flag = true;
supp.supp_name = oldsupp.Name;
supp.supp_url = oldsupp.Url; //供应商店铺地址
supp.remark = oldsupp.Desc;
supp.supp_code = oldsupp.Code;
supp.is_grade = true;
supp.purc_mode = 1;
supp.purc_priority = 1;
supp.purc_sourceid = 1;
supp.create_time = DateTime.Now;
supp.edit_time = DateTime.Now;
supp.del_time = DateTime.Now;
suppid = db.Insert <base_supplier>(supp).ObjToInt();
}
base_prod_supp_rel supp_rel = new base_prod_supp_rel();
supp_rel.create_time = DateTime.Now;
supp_rel.create_user_id = 1;// LoginUser.Current.user_id;
supp_rel.del_flag = true;
supp_rel.del_time = DateTime.Now;
supp_rel.edit_time = DateTime.Now;
supp_rel.edit_user_id = 1; // LoginUser.Current.user_id;
supp_rel.lev_purch = 1; //默认全部为1，因为原先的系统只能绑定一个供应商
supp_rel.supp_id = suppid;
supp_rel.prod_id = proid;
db.Insert <base_prod_supp_rel>(supp_rel);
if (suppid > 0)//如果第一张表插入正常
{
base_prod_code procode = new base_prod_code();
base_product_imgs proimgs = new base_product_imgs();
foreach (var item in skulist)
{
procode.bar_code = item.Code; //插入SKU表
procode.create_time = DateTime.Now;
procode.create_user_id = 1; //LoginUser.Current.user_id;
procode.del_flag = true;
procode.del_time = DateTime.Now;
procode.del_user_id = 0;
procode.edit_time = DateTime.Now;
procode.edit_user_id = 0;
procode.isbn_code = "";
procode.jcode = "";
procode.prod_id = proid;
procode.prod_model = Getmodel(item.Code);
procode.prod_size = GetSize(item.Code);
procode.remark = "";
procode.sku_code = item.Code;
codeid = db.Insert <base_prod_code>(procode).ObjToInt();
proimgs.code_id = codeid;
proimgs.create_time = DateTime.Now;
proimgs.create_user_id = 1; // LoginUser.Current.user_id;
proimgs.del_flag = true;
proimgs.del_time = DateTime.Now;
proimgs.del_user_id = 0;
proimgs.edit_time = DateTime.Now;
proimgs.edit_user_id = 0;
proimgs.pic_describe = "";
proimgs.pic_url = item.PicUrl; ///sku图片地址
proimgs.prod_id = proid;
proimgs.prod_model = Getmodel(item.Code);
proimgs.remark = "";
db.Insert <base_product_imgs>(proimgs);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
}
DateTime end = DateTime.Now;
TimeSpan lasttime = end - start;
MessageBox.Show("导入" + myprolist.Count + "个产品到新系统,用时:" + lasttime.Hours + "小时" + lasttime.Minutes + "分" + lasttime.Seconds + "秒");
}
