static void AddWholeSalerInfo() { WholeSalerInfo wholeSalerInfo = new WholeSalerInfo(); wholeSalerInfo.Management = "hlx"; wholeSalerInfo.SupName = "fdf"; wholeSalerInfo.TelePhone = "fdffdf411"; wholeSalerInfo.AddressInfo = "fds"; wholeSalerInfo.Remark = " "; wholeSalerInfo.DelFlag = false; WholeSalerInfoDal wholeSalerInfoDal = new WholeSalerInfoDal(); bool d = wholeSalerInfoDal.Add(wholeSalerInfo); if (d) { Console.WriteLine("成功"); } else { Console.WriteLine("失败"); } }
/// <summary> /// GoodsInfoHelper 转换为 GoodsInfo /// </summary> /// <param name="goodsInfoHelper"></param> /// <returns></returns> public GoodsInfo GetGoodsInfo(GoodsInfoHelper goodsInfoHelper) { GoodsInfo goodsInfo = new GoodsInfo(); var sort = goodsInfoHelper.SortName; var unit = goodsInfoHelper.UnitName; var wholeSalerName = goodsInfoHelper.WholeSalerName; //将Sort 转换为SortID //在sort表中查询是否有该数据,有则返回ID 无则添加该类型 后返回ID int sortId = sortInfoDal.GetSortIdByName(sort); if (sortId == int.MaxValue) { //添加该类型 SortInfo sortInfo = new SortInfo(); sortInfo.SortName = sort; sortInfo.DelFlag = false; sortId = sortInfoDal.GetIdByAdd(sortInfo); } int unitId = unitInfoDal.GetUnitIdByName(unit); if (unitId == int.MaxValue) { //添加该类型 UnitInfo unitInfo = new UnitInfo(); unitInfo.UnitName = unit; unitInfo.DelFlag = false; sortId = unitInfoDal.GetIdByAdd(unitInfo); } int wholesalerId = wholeSalerInfoDal.GetWholeSaleIdByName(wholeSalerName); if (wholesalerId == int.MaxValue) { WholeSalerInfo wholeSalerInfo = new WholeSalerInfo(); wholeSalerInfo.SupName = wholeSalerName; wholeSalerInfo.Management = "未知"; wholeSalerInfo.AddressInfo = "未知"; wholeSalerInfo.TelePhone = "未知"; wholeSalerInfo.AddressInfo = "未知"; wholeSalerInfo.DelFlag = false; wholesalerId = wholeSalerInfoDal.GetIdByAdd(wholeSalerInfo); } goodsInfo.GoodsName = goodsInfoHelper.GoodsName; goodsInfo.GoodsType = goodsInfoHelper.GoodsType; goodsInfo.CreateTime = DateTime.Now; goodsInfo.LastTime = goodsInfoHelper.LastTime; goodsInfo.PayPrice = goodsInfoHelper.PayPrice; goodsInfo.PurPrice = goodsInfoHelper.PurPrice; goodsInfo.Remark = goodsInfoHelper.Remark; goodsInfo.SalesCount = goodsInfoHelper.SalesCount; goodsInfo.SurplusCount = goodsInfoHelper.SurplusCount; goodsInfo.Total = goodsInfoHelper.Total; goodsInfo.UnitId = unitId; goodsInfo.SortId = sortId; goodsInfo.WholeSalerId = wholesalerId; return(goodsInfo); }
static void Edit() { WholeSalerInfo wholeSalerInfo = new WholeSalerInfo(); WholeSalerInfoDal sortInfoDal = new WholeSalerInfoDal(); bool d = sortInfoDal.Edit(wholeSalerInfo); if (d) { Console.WriteLine("成功"); } else { Console.WriteLine("失败"); } }
private void btnEnter_Click(object sender, EventArgs e) { Huang_System f1 = (Huang_System)this.Owner;//将本窗体的拥有者强制设为Form1类的实例f if (!CheckInput()) { lbltips.Text = "请检查数据,(*)数据不能为空"; lbltips.ForeColor = Color.Red; return; } //添加时候 默认 id 为maxValue if (entityId == int.MaxValue) { WholeSalerInfo wholeSalerInfo = new WholeSalerInfo(); wholeSalerInfo.SupName = txtSupName.Text.Trim(); wholeSalerInfo.Management = txtManagement.Text.Trim(); wholeSalerInfo.TelePhone = txtPhone.Text.Trim(); wholeSalerInfo.AddressInfo = txtAddress.Text.Trim(); wholeSalerInfo.Remark = txtRemark.Text.Trim(); var isSuccess = DataManager.WholeSalerInfoBLL.Add(wholeSalerInfo); if (!isSuccess) { MessageBox.Show("操作失败!"); } this.Tag = true; this.Close(); } else { WholeSalerInfo wholeSalerInfo = new WholeSalerInfo(); wholeSalerInfo.SupName = txtSupName.Text.Trim(); wholeSalerInfo.Management = txtManagement.Text.Trim(); wholeSalerInfo.TelePhone = txtPhone.Text.Trim(); wholeSalerInfo.AddressInfo = txtAddress.Text.Trim(); wholeSalerInfo.Remark = txtRemark.Text.Trim(); wholeSalerInfo.Id = entityId; var isSuccess = DataManager.WholeSalerInfoBLL.Edit(wholeSalerInfo); if (!isSuccess) { MessageBox.Show("操作失败!"); } this.Close(); } //属性界面 f1.GetDgv(f1.SelectIndex); }
static void Add() { WholeSalerInfo wholeSalerInfo = new WholeSalerInfo(); WholeSalerInfoDal wholeSalerInfoDal = new WholeSalerInfoDal(); bool d = wholeSalerInfoDal.Add(wholeSalerInfo); if (d) { Console.WriteLine("成功"); } else { Console.WriteLine("失败"); } }
static void EditWholeSalerInfo() { WholeSalerInfo wholeSalerInfo = new WholeSalerInfo(); wholeSalerInfo.Management = "hdfdlx"; wholeSalerInfo.SupName = "f"; wholeSalerInfo.TelePhone = "fd"; wholeSalerInfo.AddressInfo = "f"; wholeSalerInfo.Id = 1; wholeSalerInfo.Remark = " "; wholeSalerInfo.DelFlag = false; WholeSalerInfoDal sortInfoDal = new WholeSalerInfoDal(); bool d = sortInfoDal.Edit(wholeSalerInfo); if (d) { Console.WriteLine("成功"); } else { Console.WriteLine("失败"); } }
/// <summary> /// 获取默认的表名 /// </summary> /// <param name="id"></param> /// <param name="name">表名</param> /// <param name="handText">列名</param> /// <param name="hideIndex">隐藏列</param> public static void GetHandTxtAndHideIndex(int id, ref List <string> name, ref List <string> handText, ref List <int> hideIndex) { switch (id) { case 0: name = new GoodsInfo().GetTableName(); handText = new GoodsInfo().GetHanderTxt(); hideIndex = new GoodsInfo().GetHideIndex(); break; case 1: name = new OrderInfo().GetTableName(); handText = new OrderInfo().GetHanderTxt(); hideIndex = new OrderInfo().GetHideIndex(); break; case 2: name = new GoodsInfo().GetTableName(); handText = new GoodsInfo().GetHanderTxt(); hideIndex = new GoodsInfo().GetHideIndex(); break; case 3: name = new OrderInfo().GetTableName(); handText = new OrderInfo().GetHanderTxt(); hideIndex = new OrderInfo().GetHideIndex(); break; case 4: name = new ProfitsInfo().GetTableName(); handText = new ProfitsInfo().GetHanderTxt(); hideIndex = new ProfitsInfo().GetHideIndex(); break; case 5: name = new NoReceiveMoney().GetTableName(); handText = new NoReceiveMoney().GetHanderTxt(); hideIndex = new NoReceiveMoney().GetHideIndex(); break; case 6: name = new UnitInfo().GetTableName(); handText = new UnitInfo().GetHanderTxt(); hideIndex = new UnitInfo().GetHideIndex(); break; case 7: name = new SortInfo().GetTableName(); handText = new SortInfo().GetHanderTxt(); hideIndex = new SortInfo().GetHideIndex(); break; case 8: name = new WholeSalerInfo().GetTableName(); handText = new WholeSalerInfo().GetHanderTxt(); hideIndex = new WholeSalerInfo().GetHideIndex(); break; case 9: name = new UserInfo().GetTableName(); handText = new UserInfo().GetHanderTxt(); hideIndex = new UserInfo().GetHideIndex(); break; default: break; } }