private void button1_Click(object sender, EventArgs e)
{
string strNum = "";
string strName = "";
string strContent = "";
string strPhone = "";
string strAdress = "";
strNum = tbFNumber.Text.Trim();
strName = tbFName.Text.Trim();
strContent = tbFContect.Text.Trim();
strPhone = tbFPhone.Text.Trim();
strAdress = tbFAddress.Text.Trim();
var model = db.Factories.FirstOrDefault(m => m.供应商编号 == strNum);
model.供应商编号 = strNum;
model.供应商名称 = strName;
model.联系人 = strContent;
model.联系电话 = strPhone;
model.供应商地址 = strAdress;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("供应商信息修改失败!");
return;
}
MessageBox.Show("供应商信息修改成功!");
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "" || textBox3.Text.Trim() == "")
{
MessageBox.Show("输入框不能为空");
return;
}
var model = db.users.FirstOrDefault(m => m.users_workid == username);
if (model.users_password != textBox1.Text.Trim())
{
MessageBox.Show("原始密码错误！");
return;
}
if (textBox2.Text != textBox3.Text.Trim())
{
MessageBox.Show("确认密码不正确!");
return;
}
model.users_password = textBox2.Text.Trim();
db.SaveChanges();
MessageBox.Show("修改密码成功！");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
string no = "";
string name = "";
int num = 0;
string time = "";
string cangku = "";
string khbh = "";
string khname = "";
decimal yi = 0;
string style = "";
decimal zo = 0;
decimal wei = 0;
no = tb_no.Text.Trim();
name = tbName.Text.Trim();
num = Convert.ToInt32(tb_num.Text.Trim());
time = dateTimePicker1.Text.Trim();
cangku = cbCk.Text.Trim();
khbh = cbNum.Text.Trim();
khname = cbName.Text.Trim();
yi = Convert.ToDecimal(textBox2.Text.Trim());
style = comboBox1.Text.Trim();
zo = Convert.ToDecimal(textBox6.Text.Trim());
wei = Convert.ToDecimal(textBox4.Text.Trim());
var model = db.Sells.FirstOrDefault(m => m.订单编号 == no);
model.订单编号 = no;
model.商品名称 = name;
model.销货数量 = num;
model.销货日期 = time;
model.客户编号 = khbh;
model.客户名称 = khname;
model.所属仓库 = cangku;
model.已付款金额 = yi;
model.总金额 = zo;
model.付款方式 = style;
model.未付款金额 = wei;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("修改失败!");
return;
}
MessageBox.Show("修改成功!");
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string strNum = "";
string strName = "";
string strContent = "";
string strPhone = "";
string strEmail = "";
string strAdress = "";
strNum = tbGNum.Text.Trim();
strName = tbGName.Text.Trim();
strContent = tbContent.Text.Trim();
strPhone = tbPhone.Text.Trim();
strEmail = tbEmail.Text.Trim();
strAdress = tbAdress.Text.Trim();
var model = db.Guests.FirstOrDefault(m => m.客户编号 == strNum);
model.客户编号 = strNum;
model.客户名称 = strName;
model.联系人 = strContent;
model.联系电话 = strPhone;
model.邮箱 = strEmail;
model.联系地址 = strAdress;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("修改失败!");
return;
}
MessageBox.Show("修改成功!");
this.Close();
}
private void button44_Click(object sender, EventArgs e)
{
string strFNum = "";
string strFName = "";
string strFPrice = "";
string strFLs = "";
string strFAddress = "";
string strFKc = "";
strFNum = tbFNum.Text.Trim();
strFName = tbFName.Text.Trim();
strFPrice = tbFPrice.Text.Trim();
strFLs = tbFLs.Text.Trim();
strFAddress = tbFAddress.Text.Trim();
strFKc = tbFKc.Text.Trim();
var model = db.Products.FirstOrDefault(m => m.商品编号 == strFNum);
model.商品编号 = strFNum;
model.商品名称 = strFName;
model.商品单价 = Convert.ToInt32(strFPrice);
model.零售价 = Convert.ToInt32(strFLs);
model.联系地址 = strFAddress;
model.当前库存 = strFKc;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("修改失败!");
return;
}
MessageBox.Show("商品信息修改成功!");
this.Close();
}
private void btYes_Click(object sender, EventArgs e)
{
string strName = "";
string strPawword = "";
string strPhone = "";
string strType = "";
string strEmail = "";
lbMessage1.Text = "";
lbMessage2.Text = "";
lbMessage3.Text = "";
lbMessage4.Text = "";
lbMessage5.Text = "";
lbMessage6.Text = "";
// 校验
if (texUsername.Text.Trim() == "")
{
lbMessage1.Text = "用户名不能为空!";
texUsername.Focus();
return;
}
if (texPassword.Text.Trim() == "")
{
lbMessage2.Text = "密码不能为空!";
texPassword.Focus();
return;
}
if (texPhone.Text.Trim() == "")
{
lbMessage4.Text = "手机号不能为空!";
texPhone.Focus();
return;
}
if (tbEmail.Text.Trim() == "")
{
lbMessage5.Text = "邮箱不能为空!";
tbEmail.Focus();
return;
}
if (texType.Text.Trim() == "")
{
lbMessage6.Text = "用户类型不能为空!";
texType.Focus();
return;
}
if (texPassword.Text.Trim() != texPassword1.Text.Trim())
{
lbMessage3.Text = "两次密码不同！";
texPhone.Focus();
return;
}
// 获取数据
strName = texUsername.Text.Trim();
strPawword = texPassword.Text.Trim();
strPhone = texPhone.Text.Trim();
strType = texType.Text.Trim();
strEmail = tbEmail.Text.Trim();
// 检验学号是否重复
if (db.manges.Any(m => m.user_name == strName) == true)
{
MessageBox.Show("用户名重复!");
texUsername.Focus();
return;
}
DBCL.mange mode1 = new DBCL.mange();
mode1.user_name = strName;
mode1.user_password = strPawword;
mode1.user_phone = strPhone;
mode1.user_type = strType;
mode1.user_email = strEmail;
try
{
db.manges.Add(mode1);
db.SaveChanges();
}
catch
{
MessageBox.Show("注册失败!");
return;
}
MessageBox.Show("注册成功，欢迎使用!");
this.Close();
login frmMain = new login();
frmMain.Show();
}
//删除数据
private void button2_Click(object sender, EventArgs e)
{
//判断表单是否已更新，若未更新，执行删除，否则，执行更新
if (ifChanged == true)
{
if (MessageBox.Show("表单已修改，是否要更新？（保存后才可删除）", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
return;
}
else
{
//删除原有表单
string TKReturns_id = textBox1.Text.ToString();
var model = db.TKReturns.Select(m => m);
model = model.Where(m => m.TKReturns_id == TKReturns_id);
foreach (var item in model)
{
//减少仓库中的货物数量
var model2 = db.warehouses.FirstOrDefault(m => m.warehouse_name == item.TKReturns_name);
model2.warehouse_number = model2.warehouse_number - Convert.ToDecimal(item.TKReturns_number);
//增加总资金
var model3 = db.funds.FirstOrDefault(m => m.funds_id == 1);
model3.funds_number = model3.funds_number - Convert.ToDecimal(item.TKReturns_number) * Convert.ToDecimal(item.TKReturns_price);
//对应收入单销售额减少
var model4 = db.pays.FirstOrDefault(m => m.pay_purchase_id == TKReturns_id);
model4.pay_number = model4.pay_number - Convert.ToDecimal(item.TKReturns_number) * Convert.ToDecimal(item.TKReturns_price);
//删除销售单中对应单号的所有数据
db.TKReturns.Remove(item);
}
//验证新单格式
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("销售单号不能为空！");
return;
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (int j = 0; j < dataGridView1.Columns.Count - 1; j++)
{
if (dataGridView1.Rows[i].Cells[j].Value == null)
{
MessageBox.Show("第" + (i + 1) + "行" + (j + 1) + "列处不能为空！");
return;
}
}
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (!Regex.IsMatch(dataGridView1.Rows[i].Cells[1].Value.ToString(), @"^[+-]?(?!0\d)\d+(\.[0-9]+)?$"))
{
MessageBox.Show("数量必须为数字！");
return;
}
if (!Regex.IsMatch(dataGridView1.Rows[i].Cells[2].Value.ToString(), @"^[+-]?(?!0\d)\d+(\.[0-9]+)?$"))
{
MessageBox.Show("单价必须为数字！");
return;
}
if (!Regex.IsMatch(dataGridView1.Rows[i].Cells[3].Value.ToString(), "^[\u4e00-\u9fa5]$"))
{
MessageBox.Show("单位必须为汉字！");
return;
}
}
//验证是否有此退货单
var model5 = db.TKReturns.Where(m => m.TKReturns_id == textBox1.Text.Trim());
if (model5.Count() == 0)
{
MessageBox.Show("此销售单不存在，请重新输入！");
return;
}
//验证表单内容是否正确
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
bool flag = false;
foreach (var item in model5)
{
if (dataGridView1.Rows[i].Cells[0].Value.ToString() == item.TKReturns_name)
{
flag = true;
break;
}
}
if (flag == false)
{
MessageBox.Show("退货表单信息有误！");
return;
}
}
//写入数据库
DBCL.TKReturn model6 = new DBCL.TKReturn();
string TKReturns_salesid = "";
string TKReturns_worker_id = "";
string TKReturns_data = "";
string TKReturns_name = "";
string TKReturns_unit = "";
string TKReturns_price = "";
string TKReturns_number = "";
string TKReturns_others = "";
TKReturns_salesid = textBox2.Text.Trim();
TKReturns_worker_id = username;
TKReturns_data = textBox3.Text.Trim();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
TKReturns_name = dataGridView1.Rows[i].Cells[0].Value.ToString().Trim();
TKReturns_number = dataGridView1.Rows[i].Cells[1].Value.ToString().Trim();
TKReturns_price = dataGridView1.Rows[i].Cells[2].Value.ToString().Trim();
TKReturns_unit = dataGridView1.Rows[i].Cells[3].Value.ToString().Trim();
if (dataGridView1.Rows[i].Cells[4].Value == null)
{
TKReturns_others = "";
}
else
{
TKReturns_others = dataGridView1.Rows[i].Cells[4].Value.ToString().Trim();
}
model6.TKReturns_id = TKReturns_id;
model6.TKReturns_salesid = TKReturns_salesid;
model6.TKReturns_worker_id = TKReturns_worker_id;
model6.TKReturns_data = TKReturns_data;
model6.TKReturns_name = TKReturns_name;
model6.TKReturns_number = Convert.ToDecimal(TKReturns_number);
model6.TKReturns_price = Convert.ToDecimal(TKReturns_price);
model6.TKReturns_unit = TKReturns_unit;
model6.TKReturns_others = TKReturns_others;
//保存到客户进货单
try
{
db.TKReturns.Add(model6);
db.SaveChanges();
}
catch
{
MessageBox.Show("失败！");
return;
}
//更改仓库货物数量
var model7 = db.warehouses.FirstOrDefault(m => m.warehouse_name == TKReturns_name);
model7.warehouse_number = model7.warehouse_number + Convert.ToDecimal(TKReturns_number);
}
//修改支出表
var model8 = db.pays.FirstOrDefault(m => m.pay_purchase_id == TKReturns_id);
double money = 0;
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
money = money + Convert.ToDouble(dataGridView1.Rows[i].Cells[1].Value.ToString()) * Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value.ToString());
}
model8.pay_number = Convert.ToDecimal(money);
//修改总金额
var model9 = db.funds.FirstOrDefault(m => m.funds_id == 1);
model9.funds_number = model9.funds_number - Convert.ToDecimal(money);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("更新失败！");
return;
}
MessageBox.Show("更新成功！");
//********************************************************************************************
//显示新表
textBox4.Text = username;
dataGridView1.Rows.Clear();
var model10 = db.TKReturns.Select(m => m);
model10 = model10.Where(m => m.TKReturns_id == current_TK_id);
int line = 0;
foreach (var item in model)
{
textBox1.Text = item.TKReturns_id;
textBox2.Text = item.TKReturns_salesid;
textBox3.Text = item.TKReturns_data;
dataGridView1.Rows.Add();
dataGridView1.Rows[line].Cells[0].Value = item.TKReturns_name;
dataGridView1.Rows[line].Cells[1].Value = item.TKReturns_number;
dataGridView1.Rows[line].Cells[2].Value = item.TKReturns_price;
dataGridView1.Rows[line].Cells[3].Value = item.TKReturns_unit;
dataGridView1.Rows[line].Cells[4].Value = item.TKReturns_others;
line++;
}
ifChanged = false;
}
}
else
{
if (dataGridView1.SelectedRows.Count > 0)
{
if (MessageBox.Show("确认删除？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.Cancel)
{
return;
}
string TKReturns_id = textBox1.Text.ToString();
foreach (DataGridViewRow r in dataGridView1.SelectedRows)
{
string TKReturns_name = r.Cells[0].Value.ToString();
string TKReturns_number = r.Cells[1].Value.ToString();
string TKReturns_price = r.Cells[2].Value.ToString();
//删除销售单中对应的数据
var model = db.TKReturns.Select(m => m);
model = model.Where(m => m.TKReturns_id == TKReturns_id);
model = model.Where(m => m.TKReturns_name == TKReturns_name);
foreach (var item in model)
{
db.TKReturns.Remove(item);
}
//减少仓库中的货物数量
var model2 = db.warehouses.FirstOrDefault(m => m.warehouse_name == TKReturns_name);
model2.warehouse_number = model2.warehouse_number - Convert.ToDecimal(TKReturns_number);
//增加总资金
var model3 = db.funds.FirstOrDefault(m => m.funds_id == 1);
model3.funds_number = model3.funds_number - Convert.ToDecimal(TKReturns_number) * Convert.ToDecimal(TKReturns_price);
//对应支出单数额减少
var model4 = db.pays.FirstOrDefault(m => m.pay_purchase_id == TKReturns_id);
model4.pay_number = model4.pay_number - Convert.ToDecimal(TKReturns_number) * Convert.ToDecimal(TKReturns_price);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("删除失败");
return;
}
}
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("请选择要删除的数据行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//重新加载页面内容
dataGridView1.Rows.Clear();
this.textBox4.Text = username;
var model5 = db.TKReturns.Select(m => m);
model5 = model5.Where(m => m.TKReturns_id == current_TK_id);
int line = 0;
foreach (var item in model5)
{
textBox1.Text = item.TKReturns_id;
textBox2.Text = item.TKReturns_salesid;
textBox3.Text = item.TKReturns_data;
dataGridView1.Rows.Add();
dataGridView1.Rows[line].Cells[0].Value = item.TKReturns_name;
dataGridView1.Rows[line].Cells[1].Value = item.TKReturns_number;
dataGridView1.Rows[line].Cells[2].Value = item.TKReturns_price;
dataGridView1.Rows[line].Cells[3].Value = item.TKReturns_unit;
dataGridView1.Rows[line].Cells[4].Value = item.TKReturns_others;
line++;
}
ifChanged = false;
}
}
//进货单获取总价*******************************************************
//删除进货单
private bool j_delete()
{
//删除进货单
string id = "", d = "OK";
id = chushi_id;
var model = db.purchases.Select(m => m);
model = model.Where(m => m.purchase_id == id);
try
{
var pay_item = db.pays.FirstOrDefault(m => m.pay_purchase_id == id);
pay_delete(pay_item.pay_id);
}
catch
{
DialogResult drs = MessageBox.Show("未找到相应的付款单是否继续", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
d = drs.ToString();
if (d != "OK")
{
return(false);
}
}
try
{
var p_item = db.purchases.FirstOrDefault(m => m.purchase_id == id);
z_setmoney("+", Convert.ToDecimal(p_item.purchase_real_price));
}
catch { }
foreach (var item in model)
{
if (item == null)
{
MessageBox.Show("该角色在数据库中不存在!");
return(false);
}
//删除对应付款单
try
{
try
{
//仓库修改 减去增加的
c_setnumber("-", item.purchase_name, Convert.ToDecimal(item.purchase_number));
}
catch
{
DialogResult drs = MessageBox.Show("仓库未找到相应的物品是否继续", "shangchu", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
d = drs.ToString();
if (d != "OK")
{
return(false);
}
}
db.purchases.Remove(item);
}
catch
{
MessageBox.Show("删除数据失败");
return(false);
}
}
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("删除存入失败");
return(false);
}
return(true);
}
private void button1_Click(object sender, EventArgs e)
{
string no = "";
string name = "";
int num = 0;
string time = "";
string cangku = "";
string shangjia = "";
decimal danjia = 0;
decimal lv = 0;
decimal ze = 0;
decimal yi = 0;
String style = "";
decimal zo = 0;
decimal wei = 0;
no = tb_no.Text.Trim();
name = cb_name.Text.Trim();
num = Convert.ToInt32(tb_num.Text.Trim());
time = dateTimePicker1.Text.Trim();
cangku = cb_cangku.Text.Trim();
shangjia = cb_sj.Text.Trim();
danjia = Convert.ToDecimal(tb_danjia.Text.Trim());
lv = Convert.ToDecimal(tb_lv.Text.Trim());
ze = Convert.ToDecimal(textBox1.Text.Trim());
yi = Convert.ToDecimal(textBox2.Text.Trim());
style = comboBox1.Text.Trim();
zo = Convert.ToDecimal(textBox6.Text.Trim());
wei = Convert.ToDecimal(textBox4.Text.Trim());
var model = db.Order1.FirstOrDefault(m => m.订单编号 == no);
model.订单编号 = no;
model.商品名称 = name;
model.购货数量 = num;
model.购货日期 = time;
model.所属仓库 = cangku;
model.供应商 = shangjia;
model.零售价 = danjia;
model.折扣率 = lv;
model.折扣额 = ze;
model.已付款金额 = yi;
model.总金额 = zo;
model.付款方式 = style;
model.未付款金额 = wei;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("修改失败!");
return;
}
MessageBox.Show("修改成功!");
this.Close();
}
private void save_Click(object sender, EventArgs e)
{
if (name.Text.Trim() == "")
{
MessageBox.Show("名称不能为空");
return;
}
//判断数量是否为空，是否为正整数
if (number.Text.Trim() == "")
{
MessageBox.Show("数量不能为空");
return;
}
if (Validator.IsNumStr(number.Text.Trim()) == false)
{
MessageBox.Show("数量不是正整数或超出10位");
return;
}
//判断单位是否为空，是否与数据库该商品单位相同，不相同则返回报错
if (unit.Text.Trim() == "")
{
MessageBox.Show("单位不能为空");
return;
}
string dname, sdunit;
dname = name.Text.Trim();
sdunit = unit.Text.Trim();
try
{
var w_model = db.warehouses.FirstOrDefault(m => m.warehouse_name == dname);
string dunit = "";
dunit = w_model.warehouse_unit;
if (dunit != "")
{
if (dunit != sunit)
{
MessageBox.Show("单位错误应为:" + dunit);
return;
}
}
}
catch { }
//判断单价是否为空，是否为保留两位小数，或整数
if (price.Text.Trim() == "")
{
MessageBox.Show("单价不能为空");
return;
}
string sdprice = price.Text.Trim();
if (Validator.IsNumber2(sdprice) == false)
{
MessageBox.Show("单价必须是正整数或两位以内小数");
return;
}
sname = name.Text.Trim();
dnumber = Convert.ToDecimal(number.Text.Trim());
dprice = Convert.ToDecimal(price.Text.Trim());
sunit = unit.Text.Trim();
sother = other.Text.Trim();
try
{
var model = db.warehouses.FirstOrDefault(m => m.warehouse_id == id);
model.warehouse_name = sname;
model.warehouse_number = dnumber;
model.warehouse_price = dprice;
model.warehouse_unit = sunit;
model.warehouse_others = sother;
}
catch
{
MessageBox.Show("更改失败");
return;
}
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("更改失败");
return;
}
MessageBox.Show("更改成功");
Action handler = CloseWindow;
if (handler != null)
{
handler();
}
this.Close();
}
//进货单获取总价*******************************************************
//删除进货单
private bool j_delete()
{
//删除进货单
string id = "", d = "OK";
id = chushi_id;
var model = db.TGReturns.Select(m => m);
model = model.Where(m => m.TGReturns_id == id);
foreach (var item in model)
{
if (model == null)
{
MessageBox.Show("该角色在数据库中不存在!");
return(false);
}
//删除对应付款单
try
{
try
{
//仓库修改 减去增加的
c_setnumber("+", item.TGReturns_name, Convert.ToDecimal(item.TGReturns_number), item.TGreturns_unit);
}
catch
{
DialogResult drs = MessageBox.Show("仓库未找到相应的物品是否继续", "shangchu", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
d = drs.ToString();
if (d != "OK")
{
return(false);
}
}
if (d != "OK")
{
DialogResult drs = MessageBox.Show("资金是否进行相应修改", "shanchu", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
d = drs.ToString();
if (d == "OK")
{
if (z_setmoney("-", Convert.ToDecimal(item.TGReturns_price * item.TGReturns_number)) == false)
{
return(false);
}
}
}
else
{
if (z_setmoney("-", Convert.ToDecimal(item.TGReturns_price * item.TGReturns_number)) == false)
{
return(false);
}
}
//总资金修改 加上减少的
db.TGReturns.Remove(item);
}
catch
{
MessageBox.Show("删除数据失败");
return(false);
}
}
try { db.SaveChanges(); }
catch
{
MessageBox.Show("删除数据失败");
return(false);
}
return(true);
}
//删除数据
private void button2_Click(object sender, EventArgs e)
{
//判断表单是否已更新，若未更新，执行删除，否则，执行更新
if (ifChanged == true)
{
if (MessageBox.Show("表单已修改，是否要更新？（保存后才可删除）", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
return;
}
else
{
string sales_id = textBox1.Text.ToString();
var model = db.sales.Select(m => m);
model = model.Where(m => m.sales_id == sales_id);
foreach (var item in model)
{
//增加仓库中的货物数量
var model2 = db.warehouses.FirstOrDefault(m => m.warehouse_name == item.sales_name);
model2.warehouse_number = model2.warehouse_number + Convert.ToDecimal(item.sales_number);
//减少总资金
var model3 = db.funds.FirstOrDefault(m => m.funds_id == 1);
model3.funds_number = model3.funds_number - Convert.ToDecimal(item.sales_number) * Convert.ToDecimal(item.sales_real_price);
//对应收入单销售额减少
var model4 = db.recipts.FirstOrDefault(m => m.receipt_sales_id == sales_id);
model4.receipt_number = model4.receipt_number - Convert.ToDecimal(item.sales_number) * Convert.ToDecimal(item.sales_real_price);
//删除销售单中对应单号的所有数据
db.sales.Remove(item);
}
//验证新单格式
if (textBox2.Text.Trim() == "")
{
MessageBox.Show("销售对象不能为空！");
return;
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (int j = 0; j < dataGridView1.Columns.Count - 1; j++)
{
if (j == 4)
{
continue;
}
if (dataGridView1.Rows[i].Cells[j].Value == null)
{
MessageBox.Show("第" + (i + 1) + "行" + (j + 1) + "列处不能为空！");
return;
}
}
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (!Regex.IsMatch(dataGridView1.Rows[i].Cells[1].Value.ToString(), @"^[+-]?(?!0\d)\d+(\.[0-9]+)?$"))
{
MessageBox.Show("数量必须为数字！");
return;
}
if (!Regex.IsMatch(dataGridView1.Rows[i].Cells[2].Value.ToString(), @"^[+-]?(?!0\d)\d+(\.[0-9]+)?$"))
{
MessageBox.Show("单价必须为数字！");
return;
}
if (!Regex.IsMatch(dataGridView1.Rows[i].Cells[3].Value.ToString(), "^[\u4e00-\u9fa5]$"))
{
MessageBox.Show("单位必须为汉字！");
return;
}
if (dataGridView1.Rows[i].Cells[4].Value != null)
{
if (!Regex.IsMatch(dataGridView1.Rows[i].Cells[1].Value.ToString(), @"^[+-]?(?!0\d)\d+(\.[0-9]+)?$"))
{
MessageBox.Show("折扣价必须为数字！");
return;
}
}
}
//判断仓库里是否有对应的物品
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
string name = dataGridView1.Rows[i].Cells[0].Value.ToString().Trim();
string number = dataGridView1.Rows[i].Cells[1].Value.ToString().Trim();
if (db.warehouses.Any(m => m.warehouse_name == name) == false)
{
MessageBox.Show("仓库中不存在" + name + "商品！");
return;
}
else
{
var mo = db.warehouses.Select(m => m);
mo = mo.Where(m => m.warehouse_name.IndexOf(name) >= 0);
foreach (var item in mo)
{
if (item.warehouse_number < Convert.ToDecimal(number))
{
MessageBox.Show("仓库中的" + name + "剩余量不足！");
return;
}
}
}
}
//如验证无误，则存入数据库
DBCL.sale model5 = new DBCL.sale();
string sales_whereabouts = "";
string sales_worker_id = "";
string sales_data = "";
string sales_name = "";
string sales_nuit = "";
string sales_number = "";
string sales_price = "";
string sales_real_price = "";
string sales_others = "";
string sales_whole_price = "";
sales_id = textBox1.Text.Trim();
sales_whereabouts = textBox2.Text.Trim();
sales_worker_id = username;
sales_data = textBox3.Text.Trim();
//计算总价
double result = 0;
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[4].Value == null)
{
result = result + Convert.ToDouble(dataGridView1.Rows[i].Cells[1].Value) * Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value);
}
else
{
result = result + Convert.ToDouble(dataGridView1.Rows[i].Cells[1].Value) * Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value);
}
}
sales_whole_price = Convert.ToString(result).Trim();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
sales_name = dataGridView1.Rows[i].Cells[0].Value.ToString().Trim();
sales_number = dataGridView1.Rows[i].Cells[1].Value.ToString().Trim();
sales_price = dataGridView1.Rows[i].Cells[2].Value.ToString().Trim();
sales_nuit = dataGridView1.Rows[i].Cells[3].Value.ToString().Trim();
if (dataGridView1.Rows[i].Cells[4].Value == null)
{
sales_real_price = sales_price;
}
else
{
sales_real_price = dataGridView1.Rows[i].Cells[4].Value.ToString().Trim();
}
if (dataGridView1.Rows[i].Cells[5].Value == null)
{
sales_others = "";
}
else
{
sales_others = dataGridView1.Rows[i].Cells[5].Value.ToString().Trim();
}
//向销售表中添加的信息
model5.sales_id = sales_id;
model5.sales_whereabouts = sales_whereabouts;
model5.sales_worker_id = sales_worker_id;
model5.sales_data = sales_data;
model5.sales_name = sales_name;
model5.sales_unit = sales_nuit;
model5.sales_number = Convert.ToDecimal(sales_number);
model5.sales_price = Convert.ToDecimal(sales_price);
model5.sales_real_price = Convert.ToDecimal(sales_real_price);
model5.sales_others = sales_others;
model5.sales_whole_price = Convert.ToDecimal(sales_whole_price);
try
{
db.sales.Add(model5);
db.SaveChanges();
}
catch
{
MessageBox.Show("更新失败！");
return;
}
//仓库表中修改的信息
var model6 = db.warehouses.FirstOrDefault(m => m.warehouse_name == sales_name);
model6.warehouse_number = model6.warehouse_number - Convert.ToDecimal(sales_number);
}
//修改收入单
var model7 = db.recipts.FirstOrDefault(m => m.receipt_sales_id == sales_id);
model7.receipt_number = Convert.ToDecimal(sales_whole_price);
//总资金修改
var model8 = db.funds.FirstOrDefault(m => m.funds_id == 1);
model8.funds_number = model8.funds_number + Convert.ToDecimal(sales_whole_price);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("更新失败！");
return;
}
MessageBox.Show("更新成功！");
//显示新表
dataGridView1.Rows.Clear();
this.textBox4.Text = username;
var model9 = db.sales.Select(m => m);
model9 = model9.Where(m => m.sales_id == current_sales_id);
int line = 0;
foreach (var item in model9)
{
textBox1.Text = item.sales_id;
textBox2.Text = item.sales_whereabouts;
textBox3.Text = item.sales_data;
dataGridView1.Rows.Add();
dataGridView1.Rows[line].Cells[0].Value = item.sales_name;
dataGridView1.Rows[line].Cells[1].Value = item.sales_number;
dataGridView1.Rows[line].Cells[2].Value = item.sales_price;
dataGridView1.Rows[line].Cells[3].Value = item.sales_unit;
dataGridView1.Rows[line].Cells[4].Value = item.sales_real_price;
dataGridView1.Rows[line].Cells[5].Value = item.sales_others;
line++;
}
ifChanged = false;
}
}
else
{
if (dataGridView1.SelectedRows.Count > 0)
{
if (MessageBox.Show("确认删除？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.Cancel)
{
return;
}
string sales_id = textBox1.Text.ToString();
foreach (DataGridViewRow r in dataGridView1.SelectedRows)
{
string sales_name = r.Cells[0].Value.ToString();
string sales_number = r.Cells[1].Value.ToString();
string sales_price = r.Cells[4].Value.ToString();
//删除销售单中对应的数据
var model = db.sales.Select(m => m);
model = model.Where(m => m.sales_id == sales_id);
model = model.Where(m => m.sales_name == sales_name);
foreach (var item in model)
{
db.sales.Remove(item);
}
//增加仓库中的货物数量
var model2 = db.warehouses.FirstOrDefault(m => m.warehouse_name == sales_name);
model2.warehouse_number = model2.warehouse_number + Convert.ToDecimal(sales_number);
//减少总资金
var model3 = db.funds.FirstOrDefault(m => m.funds_id == 1);
model3.funds_number = model3.funds_number - Convert.ToDecimal(sales_number) * Convert.ToDecimal(sales_price);
//对应收入单销售额减少
var model4 = db.recipts.FirstOrDefault(m => m.receipt_sales_id == sales_id);
model4.receipt_number = model4.receipt_number - Convert.ToDecimal(sales_number) * Convert.ToDecimal(sales_price);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("删除失败");
return;
}
}
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("请选择要删除的数据行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//重新加载页面内容
dataGridView1.Rows.Clear();
this.textBox4.Text = username;
var model5 = db.sales.Select(m => m);
model5 = model5.Where(m => m.sales_id == current_sales_id);
int line = 0;
foreach (var item in model5)
{
textBox1.Text = item.sales_id;
textBox2.Text = item.sales_whereabouts;
textBox3.Text = item.sales_data;
dataGridView1.Rows.Add();
dataGridView1.Rows[line].Cells[0].Value = item.sales_name;
dataGridView1.Rows[line].Cells[1].Value = item.sales_number;
dataGridView1.Rows[line].Cells[2].Value = item.sales_price;
dataGridView1.Rows[line].Cells[3].Value = item.sales_unit;
dataGridView1.Rows[line].Cells[4].Value = item.sales_real_price;
dataGridView1.Rows[line].Cells[5].Value = item.sales_others;
line++;
}
ifChanged = false;
}
}