private string pay_getid() { string xuhao = "", id = "", san = "", housan = ""; int hs = 0, h = 0; string xh3 = ""; DBCL.DBEntities dbc = new DBCL.DBEntities(); var model = dbc.pays.Select(m => m); try { foreach (var item in model) { xuhao = item.pay_id; housan = xuhao.Substring(xuhao.Length - 3, 3); hs = Convert.ToInt32(housan); if (hs > h) { h = hs; } } } catch { } if (xuhao == "") { xh3 = "001"; } else { xh3 = set_housan(h); } string data = DateTime.Today.ToString("yyyyMMdd"); id = "FK" + data + san + xh3; return(id); }
private void j_submit_Click(object sender, EventArgs e) { //变量************************************************************* int length = j_d.Rows.Count; int k = 0; string name = "", unit = "", price = ""; //校验 if (length == 1) { MessageBox.Show("请输入数据"); return; } for (int i = 0; i < length - 1; i++) { k = i + 1; if (j_d.Rows[i].Cells[1].Value == null && j_d.Rows[i].Cells[3].Value == null) { continue; } //判断名称不为空,数据库是否存在,如存在则继续,不存在 if (j_d.Rows[i].Cells[1].Value == null) { MessageBox.Show("第" + k + "行名称不能为空"); return; } name = Convert.ToString(j_d.Rows[i].Cells[1].Value); //判断数量是否为空,是否为正整数 if (j_d.Rows[i].Cells[2].Value == null) { MessageBox.Show("第" + k + "行数量不能为空"); return; } if (Validator.IsNumStr(Convert.ToString(j_d.Rows[i].Cells[2].Value)) == false) { MessageBox.Show("第" + k + "行数量不是正整数或超出10位"); return; } try { DBCL.DBEntities dbcd = new DBCL.DBEntities(); var wa_model = dbcd.warehouses.FirstOrDefault(m => m.warehouse_name.IndexOf(name) >= 0); decimal shuliang = Convert.ToDecimal(j_d.Rows[i].Cells[2].Value); if (wa_model.warehouse_number - shuliang < 0) { MessageBox.Show("第" + k + "行库存不足"); return; } } catch { MessageBox.Show("仓库不存在"); } //判断单位是否为空,是否与数据库该商品单位相同,不相同则返回报错 if (j_d.Rows[i].Cells[3].Value == null) { MessageBox.Show("第" + k + "行单位不能为空"); return; } name = Convert.ToString(j_d.Rows[i].Cells[1].Value); unit = Convert.ToString(j_d.Rows[i].Cells[3].Value); var w_model = db.warehouses.Select(m => m); w_model = w_model.Where(m => m.warehouse_name == name); string dunit = ""; foreach (var item in w_model) { dunit = item.warehouse_unit; } if (dunit != "") { if (dunit != unit) { MessageBox.Show("第" + k + "行单位错误应为:" + dunit); return; } } //判断单价是否为空,是否为保留两位小数,或整数 if (j_d.Rows[i].Cells[4].Value == null) { MessageBox.Show("第" + k + "行单价不能为空"); return; } price = Convert.ToString(j_d.Rows[i].Cells[4].Value); if (Validator.IsNumber2(price) == false) { MessageBox.Show("第" + k + "行单价必须是正整数或两位以内小数"); return; } } //判断供货商是否为空,提示并返回 if (j_source.Text.Trim() == "") { MessageBox.Show("请输入供货商"); return; } //***************************************************************************** try { if (j_delete() == false) { return; } if (jh_tijiao() == false) { return; } panxiu = false; } catch { MessageBox.Show("更新失败"); } MessageBox.Show("更新成功"); Action handler = CloseWindow; if (handler != null) { handler(); } this.Close(); }