/// <summary>
/// 根据产品ID获得产品的详细信息和SKU
/// </summary>
/// <param name="proid"></param>
/// <returns></returns>
public ProductDetail GetProductDetail(int proid)
{
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
try
{
base_product pro = db.Queryable <base_product>().Where(s => s.prod_id == proid).FirstOrDefault();
List <base_prod_code> proskus = db.Queryable <base_prod_code>().Where(s1 => s1.prod_id == proid).ToList();
List <img_model> proimgs = db.Queryable <base_product_imgs>().Where(s2 => s2.prod_id == proid).GroupBy(s2 => s2.prod_model)
.GroupBy(s2 => s2.pic_url)
.Select <img_model>("prod_model,pic_url").ToList();
List <SupplierModel> prosupp = db.Queryable <base_prod_supp_rel>().JoinTable <base_supplier>((s1, s2) => s1.supp_id == s2.supp_id)
.Where(s1 => s1.prod_id == proid)
.Select <base_supplier, SupplierModel>((s1, s2) => new SupplierModel()
{
rel_id = s1.rel_id,
supp_id = s1.supp_id,
suppliername = s2.supp_name,
prod_id = s1.prod_id,
lev_purch = s1.lev_purch
}).ToList();
//List<base_prod_supp_rel> prosupp = db.Queryable<base_prod_supp_rel>().Where(s3 => s3.prod_id == proid).ToList();
ProductDetail prodetail = new ProductDetail();
prodetail.pro = pro;
prodetail.proimgs = proimgs;
prodetail.proskus = proskus;
prodetail.prosupp = prosupp;
return(prodetail);
}
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 + "秒");
}
public bool InsertProdcut(string code, string proname, string bgname, string bgcode, string bgprice, string weight, string price, string remark, string clasf, string profly, string promodel, string prosize, List <string> skulist)
{
bool isexit = PcodeIsExit(code);
if (isexit)
{
throw new Exception("该款号已存在");
}
int proid = 0;
int codeid = 0;
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
db.CommandTimeOut = 5000;//设置超时时间 5秒
try
{
db.BeginTran();//开启事务
base_product add = new base_product();
add.brand_id = 1;
add.create_time = DateTime.Now;
add.create_user_id = LoginUser.Current.user_id;
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 = "";
add.bgcode = bgname;
add.bgcode = bgcode;
add.pre_weight = Convert.ToInt32(weight);
add.price_us = Convert.ToDecimal(bgprice);
add.price_cn = Convert.ToDecimal(price);
add.prod_class_id = Convert.ToInt32(profly);
add.prod_developer = LoginUser.Current.real_name;
add.prod_picpath = "";
add.prod_property = Convert.ToInt32(clasf);
add.prod_status = 0;
add.prod_style = code;
add.prod_title = proname;
add.prod_url = "";
add.real_weight = Convert.ToInt32(weight);
add.remark = remark;
add.title_en = "";
add.title_jp = "";
add.model = promodel;
add.size = prosize;
proid = db.Insert <base_product>(add).ObjToInt();
if (proid > 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; //插入SKU表
procode.create_time = DateTime.Now;
procode.create_user_id = 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);
procode.prod_size = GetSize(item);
procode.remark = "";
procode.sku_code = item;
codeid = db.Insert <base_prod_code>(procode).ObjToInt();
proimgs.code_id = codeid;
proimgs.create_time = DateTime.Now;
proimgs.create_user_id = 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 = "";
proimgs.prod_id = proid;
proimgs.prod_model = Getmodel(item);
proimgs.remark = "";
db.Insert <base_product_imgs>(proimgs);
}
db.CommitTran(); //提交事务
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
db.RollbackTran(); //回滚事务
throw ex;
}
}
}