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