/// <summary>
/// 刷新商品表格dgv的数据
/// </summary>
public void update_dgv()
{
commodity c = new commodity();
c.Username = love.denglu_username == string.Empty ? "a" : love.denglu_username;//如果为null说明它不是登陆进来的，而是调试过程中产生的
dgv_data.DataSource = c.selectall();
}
private void Frm_LiuLanCom_Load(object sender, EventArgs e)
{
btn_add.Visible = false;
foreach (Control i in Controls)
{
i.Anchor = AnchorStyles.None;
}
Frm_Login f = new Frm_Login();
Icon = f.Icon;
AutoScroll = true;
commodity commodity = new commodity();
DataTable d = commodity.allcommodity();
allcount = d.Rows.Count;//记录下商品的总行数
for (int i = 0; i < allcount; i++)
{
comrows.Add(i);//循环添加行数到商品行号集合
}
//Text = comrows.Count.ToString();//查看行数
//程序进来就给看一个商品
//Random sjs = new Random();
//int dangqian = sjs.Next(0, comrows.Count);//记录下随机到的行号
//yigecom(comrows[dangqian]);//pannel控件显示某行的商品
//comrows.Remove(comrows[dangqian]);//每次都要把用过的值给清理掉
while (log)
{
btn_add_Click(sender, e);
}
}
private void Frm_LiuLanComDat_Load(object sender, EventArgs e)
{
//dgv_com.RowHeadersVisible = false;//不出现开头的空白边
//dgv_com.ColumnHeadersVisible = false;//不出现开头的空白边
totxt_yeshu.Text = hangshu.ToString();
string[] y = { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20" };
//tocmb_yeshu.Items.AddRange(y);
//tocmb_yeshu.DropDownStyle = ComboBoxStyle.DropDownList;
//tocmb_yeshu.SelectedIndex = 9;
//tocmb_yeshu.FlatStyle = FlatStyle.Standard;
btn_dgv_wushujutip.Visible = false;
Frm_Login f = new Frm_Login();
Icon = f.Icon;
MinimumSize = new Size(1132, 607);
foreach (Control item in Controls)
{
item.Anchor = AnchorStyles.None;
}
rab_xiangxi.ReadOnly = true;//不允许更改卖家介绍
rab_xiangxi.BorderStyle = BorderStyle.FixedSingle;
commodity com = new commodity();
dgv_com.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgv_com.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgv_com.DataSource = com.selldecommdity();
dgv_com.AutoGenerateColumns = false;
dgv_com.AllowUserToResizeColumns = false;
dgv_com.AllowUserToDeleteRows = false;
dgv_com.AllowUserToAddRows = false;
dgv_com.ReadOnly = true;
dgv_com.MultiSelect = false;
//下面分页的行、页记得不要放到分页方法里面去，因为每次执行都会初始化
CurrentRow = 0; //当前行为0
CurrentPage = 1; //当前页为1
fenyegongneng();
dgv_com.Columns[0].HeaderText = "商品名";
dgv_com.Columns[1].HeaderText = "售价";
dgv_com.Columns[2].HeaderText = "包邮";
dgv_com.Columns[3].HeaderText = "快递";
dgv_com.Columns[4].HeaderText = "库存";
dgv_com.Columns[5].HeaderText = "月销量";
dgv_com.Columns[6].HeaderText = "生产地";
love.meihua(this);
}
/// <summary>
/// 指定の金の保有量になったら、指定の資源を指定の保有量になるまで売ります
/// </summary>
/// <param name="commodity">売る資源</param>
/// <param name="needGoldAmount">必要な金の保有量</param>
/// <param name="LimitationAmount">買いをやめる資源の保有量</param>
public BuyShortageCommodity(commodity commodity, short needGoldAmount, short LimitationAmount)
{
AIFactRelOp buyCommodityAmount = commodity switch {
commodity.food => new food_amount(relop.le, LimitationAmount),
commodity.stone => new stone_amount(relop.le, LimitationAmount),
commodity.wood => new wood_amount(relop.le, LimitationAmount),
_ => throw new Exception(),
};
Facts.Add(
new can_buy_commodity(commodity),
new gold_amount(relop.ge, needGoldAmount),
buyCommodityAmount
);
Actions.Add(new buy_commodity(commodity));
}
/// <summary>
/// 指定の保有量になった資源を、指定の金の保有量になるか指定の保有量以下になるまで売ります
/// </summary>
/// <param name="commodity">売る資源</param>
/// <param name="needAmount">必要な資源の保有量</param>
/// <param name="LimitationGoldAmount">売りをやめる金の保有量</param>
public SellSurplusCommodity(commodity commodity, short needAmount, short LimitationGoldAmount)
{
AIFactRelOp sellCommodityAmount = commodity switch {
commodity.food => new food_amount(relop.ge, needAmount),
commodity.stone => new stone_amount(relop.ge, needAmount),
commodity.wood => new wood_amount(relop.ge, needAmount),
_ => throw new Exception(),
};
Facts.Add(
new can_sell_commodity(commodity),
new gold_amount(relop.le, LimitationGoldAmount),
sellCommodityAmount
);
Actions.Add(new sell_commodity(commodity));
}
private void DynamicPetObject()
{
//
//TODO 動態生成寵物選擇物件
//
for (int i = 0; i < int_pet; i++)
{
commodity civ_item = new commodity();
civ_item.int_gd = 3;
civ_item.str_name = str_petname[i];
civ_item.str_imgurl = str_img[i];
civ_item.srt_commodity = str_commodity[i];
civ_item.init();
// civ_item._btn_img.ID = i.ToString().Trim();
// civ_item._btn_img.Click +=_btn_img_Click;
civ_item._btn_choice.ID = i.ToString().Trim(); //ID
civ_item._btn_choice.Click += _btn_choice_Click; //事件
UpdatePanel1.ContentTemplateContainer.Controls.Add(civ_item);
}
}
private void btn_delete_Click(object sender, EventArgs e)//点击了删除的按钮
{
string sql = "select comid,name,shoujia,kuadi,kucun,isbaoyou from commodity";
DataTable d = sqlHelper.ExecutedataTable(sql, CommandType.Text, null);
if (d.Rows.Count == 0)
{
btn_clear_Click(sender, e);
lab_id.Visible = false;
DialogResult result = MessageBox.Show("已经没有商品可以删除了，你想要添加商品吗？", "删除提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
btn_addcommodity_Click(sender, e);//执行添加商品的按钮
}
else
{
return;
}
}
commodity c = new commodity();
c.Comid = int.Parse(lab_id.Text);
c.delete();
update_dgv();
MessageBox.Show("删除成功", "删除商品", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dgv_yulan.Rows.Count == 0)
{
foreach (Control i in Controls)
{
if (i is TextBox || i is ComboBox)
{
i.Text = string.Empty;
}
}
}
}
private void btn_update_Click(object sender, EventArgs e)//点击了修改商品的按钮
{
//判断库存是否正确
int s = 0;
if (!int.TryParse(txt_kucun.Text, out s))
{
MessageBox.Show("请正确输入不带负数0-9的阿拉伯数字", "库存提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_kucun.Focus();
txt_kucun.SelectAll();
return;
}
//判断售价是否正确
try
{
Convert.ToDecimal(txt_shoujia.Text);
}
catch (Exception)
{
MessageBox.Show("非法字符！请正确输入价格,应为 0 -- 9 包括一个小数点的数字", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_shoujia.SelectAll();
txt_shoujia.Focus();
return;
}
//判断快递公司
if (cmb_wuliugongsi.Text == "请选择")
{
MessageBox.Show("请选择商品的物流公司", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmb_wuliugongsi.Focus();
return;
}
if (comididid != 0 && comididid != int.Parse(txt_comid.Text))
{
MessageBox.Show("不能修改商品的id，因为它是唯一的，现在已经为你还原", "属性提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
txt_comid.Text = comididid.ToString();
txt_comid.Focus();
txt_comid.SelectAll();
return;
}
#region 检查图片是否都装进去了
foreach (Control item in Controls)
{
if (item is PictureBox)
{
PictureBox p = (PictureBox)item;
if (p.Image == null)
{
MessageBox.Show("请选择图片", "图片未选择提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
}
}
#endregion
//先删除后添加达到更新的效果
commodity cm = new commodity();
cm.Comid = int.Parse(txt_comid.Text);
cm.delete();
insertcommdity();//直接调用插入商品
MessageBox.Show(string.Format("修改“{0}”商品成功", txt_name.Text), "修改提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
comididid = int.Parse(txt_comid.Text);
}
/// <summary>
/// 添加到商品库的方法，供给添加商品还有更新商品用的
/// </summary>
public void insertcommdity()// 添加到商品库的方法
{
#region 层架构插入商品数据
commodity c = new commodity();
c.Comid = int.Parse(txt_comid.Text);
c.Username = love.denglu_username == string.Empty ? "a" : love.denglu_username;//如果这个是空的话说明这个是在软件的测试阶段，不是空的话说明它是通过了登陆键来赋值的
c.Name = txt_name.Text;
c.Shoujia = int.Parse(txt_shoujia.Text);
c.Kuadi = cmb_wuliugongsi.Text;
c.Kucun = int.Parse(txt_kucun.Text);
c.Isbaoyou = ckb_isbaoyou.Checked ? "是" : "否";
c.Yuexiaoliang = int.Parse(num_yuexiaoliang.Value.ToString());
//c.Adddatetime 自动使用日期时间
c.Scd = txt_scd.Text;
#region c.Isorcolor赋值 判断是否选择了有颜色pannel，并且有颜色chekbox被选中了，然后才赋值
int colorcount = 0;
foreach (Control item in pan_iscolor.Controls)
{
if (item is CheckBox)
{
CheckBox ck = (CheckBox)item;
if (ck.Checked)
{
colorcount++;
}
}
}
if (ckb_isorcolor.Checked && colorcount != 0)
{
c.Isorcolor = "有";
}
else
{
c.Isorcolor = "无";
}
#endregion
#region c.Isororther赋值 判断是否选择了有其它pannel，并且有其它色chekbox被选中了，然后才赋值
int orthercount = 0;
foreach (var item in list_orther.Items)
{
if (item.ToString().Trim() != string.Empty)
{
orthercount++;
}
}
if (ckb_isororther.Checked && orthercount != 0)
{
c.Isororther = "有";
}
else
{
c.Isororther = "无";
}
#endregion
c.Xiangxi = txt_xiangxi.Text == "这里键入你的产品介绍，或者你想对买家说的话。" ? "" : txt_xiangxi.Text;
c.Picda = sqlHelper.tiqupic(pic_daico, Application.StartupPath + @"\image\a.jpg");
c.Pic1 = sqlHelper.tiqupic(pic_xiao1, Application.StartupPath + @"\image\a.jpg");
c.Pic2 = sqlHelper.tiqupic(pic_xiao2, Application.StartupPath + @"\image\a.jpg");
c.Pic3 = sqlHelper.tiqupic(pic_xiao3, Application.StartupPath + @"\image\a.jpg");
c.addcommodity();//执行业务层插入的方法
#region 循环添加颜色
if (c.Isorcolor == "有")
{
commditycolor.Clear();//首先清除颜色的集合
foreach (Control item in pan_iscolor.Controls)
{
if (item is CheckBox)
{
CheckBox ck = (CheckBox)item;
if (ck.Checked)
{
commditycolor.Add(ck.Text);
}
}
}
foreach (var item in commditycolor)
{
comcolor co = new comcolor();
co.Comid = int.Parse(txt_comid.Text);
co.Color = item.ToString();
co.insertcolor();//执行插入
}
}
#endregion
#region 循环添加其它
if (c.Isororther == "有")
{
commdityorther.Clear();
foreach (var item in list_orther.Items)
{
if (item.ToString().Trim() != string.Empty)
{
commdityorther.Add(item.ToString().Trim());
}
}
foreach (var item in commdityorther)
{
comorther ct = new comorther();
ct.Comid = int.Parse(txt_comid.Text);
ct.Orther = item;
ct.insertorther();
}
}
#endregion
#endregion
}
public void updatecommodity()// 修改商品的方法
{
commodity c = new commodity();
c.Kucun = int.Parse(txt_kucun.Text);
c.Name = txt_name.Text;
c.Shoujia = decimal.Parse(txt_shoujia.Text);
c.Scd = txt_scd.Text;
c.Kuadi = cmb_wuliugongsi.Text;
c.Adddatetime = dtp_adddatetime.Value;
c.Isbaoyou = ckb_isbaoyou.Checked ? "是" : "否";
c.Picda = sqlHelper.tiqupic(pic_daico, Application.StartupPath + "\\asdf.jpg");
c.Pic1 = sqlHelper.tiqupic(pic_xiao1, Application.StartupPath + "\\asdf.jpg");
c.Pic2 = sqlHelper.tiqupic(pic_xiao2, Application.StartupPath + "\\asdf.jpg");
c.Pic3 = sqlHelper.tiqupic(pic_xiao3, Application.StartupPath + "\\asdf.jpg");
c.Comid = int.Parse(dangqianid);
c.Xiangxi = txt_xiangxi.Text == "这里键入你的产品介绍，或者你想对买家说的话。" ? "" : txt_xiangxi.Text;
#region c.Isorcolor赋值 判断是否选择了有颜色pannel，并且有颜色chekbox被选中了，然后才赋值
int colorcount = 0;
foreach (Control item in pan_iscolor.Controls)
{
if (item is CheckBox)
{
CheckBox ck = (CheckBox)item;
if (ck.Checked)
{
colorcount++;
}
}
}
if (ckb_isorcolor.Checked && colorcount != 0)
{
c.Isorcolor = "有";
}
else
{
c.Isorcolor = "无";
}
#endregion
#region c.Isororther赋值 判断是否选择了有其它pannel，并且有其它色chekbox被选中了，然后才赋值
int orthercount = 0;
foreach (var item in list_orther.Items)
{
if (item.ToString().Trim() != string.Empty)
{
orthercount++;
}
}
//判断是否写的是没有任何属性
string ss = string.Empty;//循环判断是否是没有添加任何属性如果是的话就要赋值无
foreach (var item in list_orther.Items)
{
if (item.ToString().Trim() != string.Empty)
{
ss += item.ToString().Trim();
}
}
//必须要选择了有其它并且在数量不等于1的情况下值不为 没有任何属性
if ((ckb_isororther.Checked && orthercount != 0) && ss != "没有任何属性")
{
c.Isororther = "有";
}
else
{
c.Isororther = "无";
}
c.IsXiangXiupdate();
#endregion
#region 循环添加颜色
if (c.Isorcolor == "有")
{
//首先删除所有颜色，然后再插入
string sqldecolor = "delete comcolor where comid = " + dangqianid;//先删除颜色
sqlHelper.ExecuteCommand(sqldecolor, CommandType.Text, null);
commditycolor.Clear();//首先清除颜色的集合
foreach (Control item in pan_iscolor.Controls)
{
if (item is CheckBox)
{
CheckBox ck = (CheckBox)item;
if (ck.Checked)
{
commditycolor.Add(ck.Text);
}
}
}
foreach (var item in commditycolor)
{
comcolor co = new comcolor();
co.Comid = int.Parse(dangqianid);
co.Color = item.ToString();
co.insertcolor();//执行插入
}
}
else
{
//既然没有颜色那么就要删除掉数据库中的所有颜色
string sqldecolor = "delete comcolor where comid = " + dangqianid;//先删除颜色
sqlHelper.ExecuteCommand(sqldecolor, CommandType.Text, null);
}
#endregion
#region 循环添加其它
if (c.Isororther == "有")
{
//首先删除所有其它，然后再插入
string sqldeorhter = "delete comorther where comid = " + dangqianid;//再删除其它
sqlHelper.ExecuteCommand(sqldeorhter, CommandType.Text, null);
commdityorther.Clear();
foreach (var item in list_orther.Items)
{
if (item.ToString().Trim() != string.Empty)
{
commdityorther.Add(item.ToString().Trim());
}
}
foreach (var item in commdityorther)
{
comorther ct = new comorther();
ct.Comid = int.Parse(dangqianid);
ct.Orther = item;
ct.insertorther();
}
}
else
{
//既然没有其它那么就要把其它从数据库中清空
string sqldeorhter = "delete comorther where comid = " + dangqianid;//再删除其它
sqlHelper.ExecuteCommand(sqldeorhter, CommandType.Text, null);
}
#endregion
}
/// <summary>
/// 返回一个带商品的pannel显示在窗体
/// </summary>
void yigecom(int rows)
{
//comid username name shoujia kuadi kucun isbaoyou yuexiaoliang adddatetime scd isorcolor isororther xiangxi picda pic1 pic2 pic3
commodity commodity = new commodity();
DataTable d = commodity.allcommodity();
Panel pn = new Panel();//负责装一个商品
Controls.Add(pn);
pn.BorderStyle = BorderStyle.FixedSingle;
//pn.Location = new Point(20, 20);
pn.Location = new_pannel_location;//使用最新的pannel
pn.Size = new Size(400, 140);
PictureBox picda = new PictureBox();//商品的大图片
picda.SizeMode = PictureBoxSizeMode.Zoom;
picda.Size = new Size(100, 100);
picda.Location = new Point(20, 20);
picda.BorderStyle = BorderStyle.FixedSingle;
pn.Controls.Add(picda);
sqlHelper.imagechu(d.Rows[rows]["picda"], picda); //显示出图片
Label name = new Label(); //商品
name.Text = "商品：" + d.Rows[rows]["name"].ToString();
name.Location = new Point(picda.Location.X + picda.Width + 50, picda.Location.Y + 20);
pn.Controls.Add(name); //位置等于图片框的x坐标加上大图片宽家20像素，加图宽是因为它要显示在图片的右边，必须超出来，y坐标就是大图片框的y坐标加20
Label yuexiaoliang = new Label(); //月销量
yuexiaoliang.Text = "月销：" + d.Rows[rows]["yuexiaoliang"].ToString();
yuexiaoliang.Location = new Point(name.Location.X, name.Location.Y + name.Height);
pn.Controls.Add(yuexiaoliang);
Label shoujia = new Label();//售价
shoujia.Text = "售价：" + d.Rows[rows]["shoujia"].ToString();
shoujia.Location = new Point(name.Location.X, yuexiaoliang.Location.Y + yuexiaoliang.Height);
pn.Controls.Add(shoujia);
Label kuadi = new Label();//快递
kuadi.Text = "快递：" + d.Rows[rows]["kuadi"].ToString();
kuadi.Location = new Point(name.Location.X + name.Width + 5, name.Location.Y);//开始第二行了，所有y直接用商品名的y
pn.Controls.Add(kuadi);
//comid username isbaoyou adddatetime isorcolor isororther xiangxi pic1 pic2 pic3
Label kucun = new Label();//库存
kucun.Text = "库存：" + d.Rows[rows]["kucun"].ToString();
kucun.Location = new Point(kuadi.Location.X, kuadi.Location.Y + kuadi.Height);
pn.Controls.Add(kucun);
Label scd = new Label();//生产地
scd.Text = "产地：" + d.Rows[rows]["scd"].ToString();
scd.Location = new Point(kucun.Location.X, kucun.Location.Y + kucun.Height);
pn.Controls.Add(scd);
new_pannel_location = pn.Location; //记录下最新的location
//Point ppp = new Point(panpo.X, panpo.Y + pn.Height + 20);//y轴加pannel高加20作为下一个pannel的位置
Point ppp = new Point(new_pannel_location.X, pn.Location.Y + pn.Height + 20); //y轴加pannel高加20作为下一个pannel的位置
new_pannel_location = ppp; //这里不能直接new新位置所以只能用赋值的方式进行
Label p = new Label();
p.Text = d.Rows[rows]["comid"].ToString();
pn.Controls.Add(p);
p.Size = new Size(1000, 1000);
p.Location = new Point(pn.Location.X - 100, pn.Location.Y - 100);
pn.Name = d.Rows[rows]["comid"].ToString();
pn.Click += new EventHandler(pn_Click);
pn.BackColor = Color.Transparent;
picda.BorderStyle = BorderStyle.None;
foreach (Control item in pn.Controls)
{
item.Name = d.Rows[rows]["comid"].ToString();
item.Click += new EventHandler(pn_Click);
}
}
/// <summary>
/// 返回一个带商品的pannel显示在窗体
/// </summary>
void yigecom1(int rows1)
{
//comid username name shoujia kuadi kucun isbaoyou yuexiaoliang adddatetime scd isorcolor isororther xiangxi picda pic1 pic2 pic3
commodity commodity1 = new commodity();
DataTable d1 = commodity1.allcommodity();
Panel pn1 = new Panel();//负责装一个商品
Controls.Add(pn1);
pn1.BorderStyle = BorderStyle.FixedSingle;
//pn.Location = new Point(20, 20);
pn1.Location = new_pannel2_location;//使用最新的pannel
pn1.Size = new Size(400, 140);
PictureBox picda1 = new PictureBox();//商品的大图片
picda1.SizeMode = PictureBoxSizeMode.Zoom;
picda1.Size = new Size(100, 100);
picda1.Location = new Point(20, 20);
picda1.BorderStyle = BorderStyle.FixedSingle;
pn1.Controls.Add(picda1);
sqlHelper.imagechu(d1.Rows[rows1]["picda"], picda1); //显示出图片
Label name1 = new Label(); //商品
name1.Text = "商品：" + d1.Rows[rows1]["name"].ToString();
name1.Location = new Point(picda1.Location.X + picda1.Width + 50, picda1.Location.Y + 20);
pn1.Controls.Add(name1); //位置等于图片框的x坐标加上大图片宽家20像素，加图宽是因为它要显示在图片的右边，必须超出来，y坐标就是大图片框的y坐标加20
Label yuexiaoliang1 = new Label(); //月销量
yuexiaoliang1.Text = "月销：" + d1.Rows[rows1]["yuexiaoliang"].ToString();
yuexiaoliang1.Location = new Point(name1.Location.X, name1.Location.Y + name1.Height);
pn1.Controls.Add(yuexiaoliang1);
Label shoujia1 = new Label();//售价
shoujia1.Text = "售价：" + d1.Rows[rows1]["shoujia"].ToString();
shoujia1.Location = new Point(name1.Location.X, yuexiaoliang1.Location.Y + yuexiaoliang1.Height);
pn1.Controls.Add(shoujia1);
Label kuadi1 = new Label();//快递
kuadi1.Text = "快递：" + d1.Rows[rows1]["kuadi"].ToString();
kuadi1.Location = new Point(name1.Location.X + name1.Width + 5, name1.Location.Y);//开始第二行了，所有y直接用商品名的y
pn1.Controls.Add(kuadi1);
//comid username isbaoyou adddatetime isorcolor isororther xiangxi pic1 pic2 pic3
Label kucun1 = new Label();//库存
kucun1.Text = "库存：" + d1.Rows[rows1]["kucun"].ToString();
kucun1.Location = new Point(kuadi1.Location.X, kuadi1.Location.Y + kuadi1.Height);
pn1.Controls.Add(kucun1);
Label scd1 = new Label();//生产地
scd1.Text = "产地：" + d1.Rows[rows1]["scd"].ToString();
scd1.Location = new Point(kucun1.Location.X, kucun1.Location.Y + kucun1.Height);
pn1.Controls.Add(scd1);
new_pannel2_location = pn1.Location; //记录下最新的location
//Point ppp = new Point(panpo.X, panpo.Y + pn.Height + 20);//y轴加pannel高加20作为下一个pannel的位置
Point ppp1 = new Point(new_pannel2_location.X, pn1.Location.Y + pn1.Height + 20); //y轴加pannel高加20作为下一个pannel的位置
new_pannel2_location = ppp1; //这里不能直接new新位置所以只能用赋值的方式进行
pn1.BackColor = Color.Transparent;
picda1.BorderStyle = BorderStyle.None;
}
private void btn_updata_Click(object sender, EventArgs e)//点击了修改的按钮
{
string sql = "select comid,name,shoujia,kuadi,kucun,isbaoyou from commodity";
DataTable d = sqlHelper.ExecutedataTable(sql, CommandType.Text, null);
//dgv_yulan.DataSource = d;
if (d.Rows.Count == 0)//如果删除的没有数据了那么就要清空，不然点击修改会出错
{
btn_clear_Click(sender, e);
DialogResult result = MessageBox.Show("没有可以供修改的商品，你想要添加商品吗？", "删除提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
btn_addcommodity_Click(sender, e);//执行添加商品的按钮
}
return;
}
#region xin值
xin = string.Empty;
foreach (Control item in Controls)
{
if (item is TextBox)
{
xin += item.Text;
}
if (item is ComboBox)
{
xin += item.Text;
}
if (item is RadioButton)
{
RadioButton r = (RadioButton)item;
if (r.Checked)
{
xin += r.Text;
}
}
if (item is DateTimePicker)
{
xin += item.Text;
}
}
#endregion
//if (xin == lao)
//{
// MessageBox.Show("你没有修改任何数据");
// return;
//}
//判断金额是否填写正确
try
{
Convert.ToDecimal(txt_shoujia.Text);
string sj = txt_shoujia.Text; //获取到售价
int dian = sj.IndexOf("."); //找到了就获取到 . 的索引
if (dian != -1 && sj.Length - dian > 2) //找到了点 并且 价格的长度减去.的索引 > 2
{
MessageBox.Show("小数位不能超过1位", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_shoujia.Focus();
txt_shoujia.SelectAll();
return;
}
}
catch
{
MessageBox.Show("请输入正确的金额", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_shoujia.Focus();
txt_shoujia.SelectAll();
return;
}
//判断库存数是否填写正确
try
{
Convert.ToInt32(txt_kucun.Text);
}
catch
{
MessageBox.Show("请输入包括0-9之间的数字", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_kucun.Focus();
txt_kucun.SelectAll();
return;
}
//判断月销量是否填写正确
try
{
Convert.ToInt32(txt_yuexiaoliang.Text);
}
catch
{
MessageBox.Show("请输入包括0-9之间的数字", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_yuexiaoliang.Focus();
txt_yuexiaoliang.SelectAll();
return;
}
commodity c = new commodity();
c.Name = txt_name.Text;
c.Comid = int.Parse(lab_id.Text);
c.Shoujia = Convert.ToDecimal(txt_shoujia.Text);
c.Kuadi = cmb_kuaidi.Text;
c.Kucun = int.Parse(txt_kucun.Text);
c.Isbaoyou = rad_shi.Checked == true ? "是" : "否";
c.Yuexiaoliang = int.Parse(txt_yuexiaoliang.Text);
c.Adddatetime = dtp_addtime.Value;
c.Scd = txt_scd.Text;
c.Username = uname;
c.IsYuLanupdate();
MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
#region lao值
lao = string.Empty;
foreach (Control item in Controls)
{
if (item is TextBox)
{
lao += item.Text;
}
if (item is ComboBox)
{
lao += item.Text;
}
if (item is RadioButton)
{
RadioButton r = (RadioButton)item;
if (r.Checked)
{
lao += r.Text;
}
}
if (item is DateTimePicker)
{
lao += item.Text;
}
}
#endregion
update_dgv();
}
