public bool Insert(MODELINVOICESTOCKS MODELINVOICESTOCKS) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO INVOICESTOCKS(INVOICESTARTNO,INVOICEENDNO,INVOICEBATCHID,INVOICEMEMO) "); str.Append("VALUES(@INVOICESTARTNO,@INVOICEENDNO,@INVOICEBATCHID,@INVOICEMEMO)"); SqlParameter[] para = { new SqlParameter("@INVOICESTARTNO", SqlDbType.VarChar, 50), new SqlParameter("@INVOICEENDNO", SqlDbType.VarChar, 50), new SqlParameter("@INVOICEBATCHID", SqlDbType.Int), new SqlParameter("@INVOICEMEMO", SqlDbType.VarChar, 200) }; para[0].Value = MODELINVOICESTOCKS.INVOICESTARTNO; para[1].Value = MODELINVOICESTOCKS.INVOICEENDNO; para[2].Value = MODELINVOICESTOCKS.INVOICEBATCHID; para[3].Value = MODELINVOICESTOCKS.INVOICEMEMO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool Update(MODELINVOICESTOCKS MODELINVOICESTOCKS) { StringBuilder str = new StringBuilder(); str.Append("UPDATE INVOICESTOCKS SET INVOICESTARTNO=@INVOICESTARTNO,INVOICEENDNO=@INVOICEENDNO,INVOICEBATCHID=@INVOICEBATCHID,INVOICEMEMO=@INVOICEMEMO "); str.Append("WHERE INVOICESTOCKSID=@INVOICESTOCKSID"); SqlParameter[] para = { new SqlParameter("@INVOICESTARTNO", SqlDbType.VarChar, 50), new SqlParameter("@INVOICEENDNO", SqlDbType.VarChar, 50), new SqlParameter("@INVOICEBATCHID", SqlDbType.Int), new SqlParameter("@INVOICEMEMO", SqlDbType.VarChar, 200), new SqlParameter("@INVOICESTOCKSID", SqlDbType.VarChar, 50) }; para[0].Value = MODELINVOICESTOCKS.INVOICESTARTNO; para[1].Value = MODELINVOICESTOCKS.INVOICEENDNO; para[2].Value = MODELINVOICESTOCKS.INVOICEBATCHID; para[3].Value = MODELINVOICESTOCKS.INVOICEMEMO; para[4].Value = MODELINVOICESTOCKS.INVOICESTOCKSID; 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 (cmbBatch.SelectedValue == DBNull.Value || cmbBatch.SelectedValue == null) { mes.Show("请选择发票批次!"); cmbBatch.Focus(); return; } if (Convert.ToInt64(txtStartNO.Text) > Convert.ToInt64(txtEndNO.Text)) { mes.Show("发票的起始号码不能大于发票终止号码!"); txtStartNO.Focus(); return; } MODELINVOICESTOCKS MODELINVOICESTOCKS = new MODELINVOICESTOCKS(); MODELINVOICESTOCKS.INVOICEBATCHID = Convert.ToInt32(cmbBatch.SelectedValue); MODELINVOICESTOCKS.INVOICESTARTNO = txtStartNO.Text; MODELINVOICESTOCKS.INVOICEENDNO = txtEndNO.Text; MODELINVOICESTOCKS.INVOICEMEMO = txtMemo.Text; //查询发票批次中的发票号是否已存在 DataTable dt = new DataTable(); if (isADD) { dt = BLLINVOICESTOCKS.Query(" AND INVOICEBATCHID='" + cmbBatch.SelectedValue.ToString() + "'"); } else { dt = BLLINVOICESTOCKS.Query(" AND INVOICEBATCHID='" + cmbBatch.SelectedValue.ToString() + "' AND INVOICESTOCKSID<>" + txtID.Text); } for (int i = 0; i < dt.Rows.Count; i++) { long intStartNO = 0, intEndNO = 0; object obj = dt.Rows[i]["INVOICESTARTNO"]; if (Information.IsNumeric(obj)) { intStartNO = Convert.ToInt64(obj); } obj = dt.Rows[i]["INVOICEENDNO"]; if (Information.IsNumeric(obj)) { intEndNO = Convert.ToInt64(obj); } if (Convert.ToInt64(MODELINVOICESTOCKS.INVOICESTARTNO) >= intStartNO && Convert.ToInt64(MODELINVOICESTOCKS.INVOICESTARTNO) <= intEndNO) { mes.Show("批次为'" + cmbBatch.Text + "'的发票起始号码在数据库中已存在!"); txtStartNO.Focus(); return; } if (Convert.ToInt64(MODELINVOICESTOCKS.INVOICEENDNO) >= intStartNO && Convert.ToInt64(MODELINVOICESTOCKS.INVOICEENDNO) <= intEndNO) { mes.Show("批次为'" + cmbBatch.Text + "'的发票终止号码在数据库中已存在!"); txtStartNO.Focus(); return; } } if (isADD) { //新增发票记录 if (BLLINVOICESTOCKS.Insert(MODELINVOICESTOCKS)) { toolSearch_Click(null, null); if (dgList.Rows.Count > 0) { dgList.ClearSelection(); dgList.CurrentCell = dgList.Rows[dgList.Rows.Count - 1].Cells["INVOICEBATCHNAME"]; dgList_CellClick(null, new DataGridViewCellEventArgs(2, dgList.Rows.Count - 1)); } //for (int i = 0; i < dgList.Rows.Count; i++) //{ // object obj = dgList.Rows[i].Cells["INVOICEBATCHID"].Value; // if (obj != null && obj != DBNull.Value) // { // if (MODELINVOICESTOCKS.INVOICEBATCHID == Convert.ToInt32(obj)) // { // dgList.ClearSelection(); // dgList.CurrentCell = dgList.Rows[i].Cells["INVOICEBATCHNAME"]; // dgList_CellClick(null, new DataGridViewCellEventArgs(2, i)); // break; // } // } //} } else { mes.Show("新增发票记录失败,请重新操作!"); return; } } else { MODELINVOICESTOCKS.INVOICESTOCKSID = txtID.Text; if (BLLINVOICESTOCKS.Update(MODELINVOICESTOCKS)) { if (dgList.CurrentRow != null) { dgList.CurrentRow.Cells["INVOICEBATCHID"].Value = MODELINVOICESTOCKS.INVOICEBATCHID; dgList.CurrentRow.Cells["INVOICEBATCHNAME"].Value = cmbBatch.Text; dgList.CurrentRow.Cells["INVOICESTARTNO"].Value = MODELINVOICESTOCKS.INVOICESTARTNO; dgList.CurrentRow.Cells["INVOICEENDNO"].Value = MODELINVOICESTOCKS.INVOICEENDNO; dgList.CurrentRow.Cells["INVOICEMEMO"].Value = MODELINVOICESTOCKS.INVOICEMEMO; } } 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); } }