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);
}
}
