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;
}
}
