public bool Insert(MODELRECEIPTFETCH MODELRECEIPTFETCH) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO RECEIPTFETCH(RECEIPTFETCHERID,RECEIPTFETCHERNAME,RECEIPTFETCHDEPID,RECEIPTFETCHDEPNAME,RECEIPTFETCHDATETIME,RECEIPTFETCHSTARTNO,RECEIPTFETCHENDNO,MEMO) "); str.Append("VALUES(@RECEIPTFETCHERID,@RECEIPTFETCHERNAME,@RECEIPTFETCHDEPID,@RECEIPTFETCHDEPNAME,@RECEIPTFETCHDATETIME,@RECEIPTFETCHSTARTNO,@RECEIPTFETCHENDNO,@MEMO)"); SqlParameter[] para = { new SqlParameter("@RECEIPTFETCHERID", SqlDbType.VarChar, 50), new SqlParameter("@RECEIPTFETCHERNAME", SqlDbType.VarChar, 50), new SqlParameter("@RECEIPTFETCHDEPID", SqlDbType.VarChar, 50), new SqlParameter("@RECEIPTFETCHDEPNAME", SqlDbType.VarChar, 50), new SqlParameter("@RECEIPTFETCHDATETIME", SqlDbType.DateTime), new SqlParameter("@RECEIPTFETCHSTARTNO", SqlDbType.VarChar, 10), new SqlParameter("@RECEIPTFETCHENDNO", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 200) }; para[0].Value = MODELRECEIPTFETCH.RECEIPTFETCHERID; para[1].Value = MODELRECEIPTFETCH.RECEIPTFETCHERNAME; para[2].Value = MODELRECEIPTFETCH.RECEIPTFETCHDEPID; para[3].Value = MODELRECEIPTFETCH.RECEIPTFETCHDEPNAME; para[4].Value = MODELRECEIPTFETCH.RECEIPTFETCHDATETIME; para[5].Value = MODELRECEIPTFETCH.RECEIPTFETCHSTARTNO; para[6].Value = MODELRECEIPTFETCH.RECEIPTFETCHENDNO; para[7].Value = MODELRECEIPTFETCH.MEMO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool Update(MODELRECEIPTFETCH MODELRECEIPTFETCH) { StringBuilder str = new StringBuilder(); str.Append("UPDATE RECEIPTFETCH SET RECEIPTFETCHERID=@RECEIPTFETCHERID,RECEIPTFETCHERNAME=@RECEIPTFETCHERNAME,RECEIPTFETCHDEPID=@RECEIPTFETCHDEPID," + "RECEIPTFETCHDEPNAME=@RECEIPTFETCHDEPNAME,RECEIPTFETCHSTARTNO=@RECEIPTFETCHSTARTNO," + "RECEIPTFETCHENDNO=@RECEIPTFETCHENDNO,MEMO=@MEMO"); str.Append(" WHERE RECEIPTFETCHID=@RECEIPTFETCHID"); SqlParameter[] para = { new SqlParameter("@RECEIPTFETCHERID", SqlDbType.VarChar, 30), new SqlParameter("@RECEIPTFETCHERNAME", SqlDbType.VarChar, 50), new SqlParameter("@RECEIPTFETCHDEPID", SqlDbType.VarChar, 50), new SqlParameter("@RECEIPTFETCHDEPNAME", SqlDbType.VarChar, 50), new SqlParameter("@RECEIPTFETCHSTARTNO", SqlDbType.VarChar, 30), new SqlParameter("@RECEIPTFETCHENDNO", SqlDbType.VarChar, 30), new SqlParameter("@MEMO", SqlDbType.VarChar, 200), new SqlParameter("@RECEIPTFETCHID", SqlDbType.VarChar, 50) }; para[0].Value = MODELRECEIPTFETCH.RECEIPTFETCHERID; para[1].Value = MODELRECEIPTFETCH.RECEIPTFETCHERNAME; para[2].Value = MODELRECEIPTFETCH.RECEIPTFETCHDEPID; para[3].Value = MODELRECEIPTFETCH.RECEIPTFETCHDEPNAME; para[4].Value = MODELRECEIPTFETCH.RECEIPTFETCHSTARTNO; para[5].Value = MODELRECEIPTFETCH.RECEIPTFETCHENDNO; para[6].Value = MODELRECEIPTFETCH.MEMO; para[7].Value = MODELRECEIPTFETCH.RECEIPTFETCHID; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void toolSave_Click(object sender, EventArgs e) { try { if (!Information.IsNumeric(txtStartNO.Text)) { mes.Show("请输入起始号,起始号只能为数字!"); txtStartNO.Focus(); return; } if (!Information.IsNumeric(txtEndNO.Text)) { mes.Show("请输入终止号,终止号只能为数字!"); txtEndNO.Focus(); return; } if (Convert.ToInt64(txtStartNO.Text) > Convert.ToInt64(txtEndNO.Text)) { mes.Show("起始号码不能大于终止号码!"); txtStartNO.Focus(); return; } if (cmbChargerWorkName.SelectedValue == null || cmbChargerWorkName.SelectedValue == DBNull.Value) { mes.Show("请选择领用人!"); cmbChargerWorkName.Focus(); return; } MODELRECEIPTFETCH MODELRECEIPTFETCH = new MODELRECEIPTFETCH(); MODELRECEIPTFETCH.RECEIPTFETCHERID = cmbChargerWorkName.SelectedValue.ToString(); MODELRECEIPTFETCH.RECEIPTFETCHERNAME = cmbChargerWorkName.Text; MODELRECEIPTFETCH.RECEIPTFETCHDATETIME = mes.GetDatetimeNow(); MODELRECEIPTFETCH.RECEIPTFETCHSTARTNO = txtStartNO.Text; MODELRECEIPTFETCH.RECEIPTFETCHENDNO = txtEndNO.Text; MODELRECEIPTFETCH.MEMO = txtMemo.Text; //查询发票批次中的发票号是否已存在 DataTable dt = new DataTable(); if (isADD) { dt = BLLRECEIPTFETCH.Query(""); } else { dt = BLLRECEIPTFETCH.Query(" AND RECEIPTFETCHID<>" + txtID.Text); } #region 验证是否在库存的发票中 //long llStartNO = Convert.ToInt64(MODELINVOICEFETCH.INVOICEFETCHSTARTNO); //long llEndNO = Convert.ToInt64(MODELINVOICEFETCH.INVOICEFETCHENDNO); //DataTable dtInvoiceStocks = BLLINVOICESTOCKS.Query(" AND INVOICEBATCHID='" + cmbBatch.SelectedValue.ToString() + "'"); //for (long i = llStartNO; i <= llEndNO; i++) //{ // bool isOK = false; // for (int j = 0; j < dtInvoiceStocks.Rows.Count; j++) // { // long llStocksStartNO = 0; // long llStocksEndNO = 0; // if (Information.IsNumeric(dtInvoiceStocks.Rows[j]["INVOICESTARTNO"])) // { // llStocksStartNO = Convert.ToInt64(dtInvoiceStocks.Rows[j]["INVOICESTARTNO"]); // } // if (Information.IsNumeric(dtInvoiceStocks.Rows[j]["INVOICESTARTNO"])) // { // llStocksEndNO = Convert.ToInt64(dtInvoiceStocks.Rows[j]["INVOICEENDNO"]); // } // if (i < llStocksStartNO || i > llStocksEndNO) // { // continue; // } // else // { // isOK = true; // break; // } // } // if (!isOK) // { // mes.Show("批次为'" + cmbBatch.Text + "'号码为'" + i.ToString().PadLeft(8, '0') + "'的发票号不在发票库存中!"); // return; // } //} #endregion #region 验证发票领取记录是否重复 for (int i = 0; i < dt.Rows.Count; i++) { long intStartNO = 0, intEndNO = 0; object obj = dt.Rows[i]["RECEIPTFETCHSTARTNO"]; if (Information.IsNumeric(obj)) { intStartNO = Convert.ToInt64(obj); } obj = dt.Rows[i]["RECEIPTFETCHENDNO"]; if (Information.IsNumeric(obj)) { intEndNO = Convert.ToInt64(obj); } if (Convert.ToInt64(MODELRECEIPTFETCH.RECEIPTFETCHSTARTNO) >= intStartNO && Convert.ToInt64(MODELRECEIPTFETCH.RECEIPTFETCHSTARTNO) <= intEndNO) { mes.Show("设定的领取起始号在领取记录中已经存在,无法再次领取!"); txtStartNO.Focus(); return; } if (Convert.ToInt64(MODELRECEIPTFETCH.RECEIPTFETCHENDNO) >= intStartNO && Convert.ToInt64(MODELRECEIPTFETCH.RECEIPTFETCHENDNO) <= intEndNO) { mes.Show("设定的领取终止号在领取记录中已经存在,无法再次领取!"); txtEndNO.Focus(); return; } } #endregion if (isADD) { //新增发票记录 if (BLLRECEIPTFETCH.Insert(MODELRECEIPTFETCH)) { toolSearch_Click(null, null); if (dgList.Rows.Count > 0) { dgList.ClearSelection(); dgList.CurrentCell = dgList.Rows[dgList.Rows.Count - 1].Cells["RECEIPTFETCHERNAME"]; dgList_RowEnter(null, new DataGridViewCellEventArgs(2, dgList.Rows.Count - 1)); } } else { mes.Show("新增发票记录失败,请重新操作!"); return; } } else { MODELRECEIPTFETCH.RECEIPTFETCHID = txtID.Text; if (BLLRECEIPTFETCH.Update(MODELRECEIPTFETCH)) { if (dgList.CurrentRow != null) { dgList.CurrentRow.Cells["RECEIPTFETCHERNAME"].Value = MODELRECEIPTFETCH.RECEIPTFETCHERNAME; //dgList.CurrentRow.Cells["INVOICEFETCHDEPID"].Value = cmbDEP.SelectedValue; //dgList.CurrentRow.Cells["INVOICEFETCHDEPNAME"].Value = cmbDEP.Text; dgList.CurrentRow.Cells["RECEIPTFETCHDATETIME"].Value = MODELRECEIPTFETCH.RECEIPTFETCHDATETIME; dgList.CurrentRow.Cells["RECEIPTFETCHSTARTNO"].Value = MODELRECEIPTFETCH.RECEIPTFETCHSTARTNO; dgList.CurrentRow.Cells["RECEIPTFETCHENDNO"].Value = MODELRECEIPTFETCH.RECEIPTFETCHENDNO; dgList.CurrentRow.Cells["MEMO"].Value = MODELRECEIPTFETCH.MEMO; } } else { mes.Show("修改领取记录失败,请重新查询理领取列表后再修改!"); return; } } dgList.Enabled = true; toolAdd.Text = "新增"; toolSearch.Enabled = true; toolDelete.Enabled = true; isADD = false; } catch (Exception ex) { log.Write(ex.ToString(), MsgType.Error); mes.Show(ex.Message); } }