protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdEdit")
{
Response.Redirect("SaleBill.aspx?SbillIdno=" + e.CommandArgument, true);
}
else if (e.CommandName == "cmddelete")
{
objSaleBillDAL = new SaleBillDAL();
long intValue = objSaleBillDAL.Delete(Convert.ToInt32(e.CommandArgument));
objSaleBillDAL = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
ddlDateRange.Focus();
}
else
{
if (intValue == -1)
{
strMsg = "Record can not be deleted. It is in use!";
}
else
{
strMsg = "Record not deleted.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
private void toolBtnSave_Click(object sender, EventArgs e)
{
try
{
if (MessageManager.ShowMsgBox("INP-272307") == DialogResult.OK)
{
List <SaleBill> afterbill = new List <SaleBill> {
this.mergedBill
};
string str = new SaleBillDAL().SaveToRealTable(this.listBill, afterbill, this.mergedBill.BH);
if (str == "0")
{
MessageManager.ShowMsgBox("INP-272308");
base.Close();
}
else if (str.StartsWith("从预览表转正存库Fail: System.Data.SQLite.SQLiteException (0x80004005): constraint failed\r\nUNIQUE constraint failed: XSDJ_MX.XSDJBH, XSDJ_MX.XH\r\n"))
{
MessageManager.ShowMsgBox("合并后的单据号和原始单据号有重复，请删除原始单据，重新进行合并！\r\n单据合并未能完成，确定后将退出此界面");
base.Close();
}
else
{
MessageBoxHelper.Show(str);
}
}
}
catch (Exception exception)
{
HandleException.HandleError(exception);
}
}
public void Countall()
{
objSaleBillDAL = new SaleBillDAL();
Int64 count = objSaleBillDAL.Count();
objSaleBillDAL = null;
if (count > 0)
{
lblTotalRecord.Text = "T. Record (s):" + count;
}
else
{
lblTotalRecord.Text = "T. Record (s): 0 ";
}
}
private void BindGrid()
{
objSaleBillDAL = new SaleBillDAL();
DateTime?datefromValue = null;
DateTime?dateToValue = null;
Int64 yearIDNO = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue);
Int64 BillNo = string.IsNullOrEmpty(Convert.ToString(txtBillNo.Text)) ? 0 : Convert.ToInt64(txtBillNo.Text);
Int64 BillType = string.IsNullOrEmpty(Convert.ToString(ddlBillType.SelectedValue)) ? 0 : Convert.ToInt64(ddlBillType.SelectedValue);
Int64 CityFrom = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 Party = string.IsNullOrEmpty(Convert.ToString(ddlPartyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlPartyName.SelectedValue);
if (string.IsNullOrEmpty(Convert.ToString(txtBillDateFrom.Text)) == false)
{
datefromValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtBillDateFrom.Text));
}
if (string.IsNullOrEmpty(Convert.ToString(txtBillDateTo.Text)) == false)
{
dateToValue = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtBillDateTo.Text));
}
var lstGridData = objSaleBillDAL.SelectForSearch(yearIDNO, datefromValue, dateToValue, txtprefNo.Text, BillNo, CityFrom, BillType, Party);
objSaleBillDAL = null;
if (lstGridData != null && lstGridData.Count > 0)
{
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
Int64 intSbillIdno = Convert.ToInt64(DataBinder.Eval(e.Row.DataItem, "SbillHeadIdno"));
if (intSbillIdno > 0)
{
objSaleBillDAL = new SaleBillDAL();
var SbillExist = objSaleBillDAL.CheckClaimExists(Convert.ToInt64(intSbillIdno));
objSaleBillDAL = null;
if (SbillExist != null && SbillExist > 0)
{
lnkbtnDelete.Visible = false;
}
else
{
lnkbtnDelete.Visible = true;
}
}
}
}
private void toolStripBtnSave_Click(object sender, EventArgs e)
{
try
{
if (this.aisinoDataGrid1.get_SelectedRows().Count == 0)
{
MessageManager.ShowMsgBox("INP-272502");
}
else if (this.aisinoDataGrid3.get_Rows().Count == 0)
{
MessageManager.ShowMsgBox("INP-272506");
}
else if (MessageManager.ShowMsgBox("INP-272503") != DialogResult.Cancel)
{
int num2;
string str = "";
double num = 0.0;
for (num2 = 0; num2 < this.bill.ListGoods.Count; num2++)
{
int num7;
Goods goods = this.bill.ListGoods[num2];
double round = 0.0;
double num4 = 0.0;
if (goods.DJHXZ == 4)
{
continue;
}
if (this.bill.HYSY && (goods.SLV == 0.05))
{
round = SaleBillCtrl.GetRound((double)(((goods.JE / 0.95) * 0.05) - goods.SE), 2);
if (Math.Abs(round) > 0.06)
{
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，含税金额乘以税率减税额的绝对值大于0.06，不能进行折扣汇总";
}
else
{
if ((goods.DJ == 0.0) || (goods.SL == 0.0))
{
goto Label_0544;
}
num4 = Math.Abs(SaleBillCtrl.GetRound((double)(((goods.DJ * goods.SL) - goods.JE) - goods.SE), 2));
if (goods.HSJBZ)
{
if (num4 > 0.01)
{
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，单价乘以数量不等于含税金额，不能进行折扣汇总";
break;
}
goto Label_0544;
}
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，单价乘以数量不等于含税金额，不能进行折扣汇总";
}
break;
}
if (this.bill.JZ_50_15 && (goods.SLV == 0.015))
{
round = SaleBillCtrl.GetRound((double)(((goods.JE / 1.035) * 0.015) - goods.SE), 2);
if (Math.Abs(round) > 0.06)
{
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，金额与税率税额计算后误差的绝对值大于0.06，不能进行折扣汇总";
break;
}
if ((goods.DJ != 0.0) && (goods.SL != 0.0))
{
if (goods.HSJBZ)
{
if (Math.Abs(SaleBillCtrl.GetRound((double)(((goods.DJ * goods.SL) - goods.JE) - goods.SE), 2)) > 0.01)
{
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，单价乘以数量不等于含税金额，不能进行折扣汇总";
break;
}
}
else if (Math.Abs(SaleBillCtrl.GetRound((double)((goods.DJ * goods.SL) - goods.JE), 2)) > 0.01)
{
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，单价乘以数量不等于金额，不能进行折扣汇总";
break;
}
}
}
else
{
round = SaleBillCtrl.GetRound((double)((goods.JE * goods.SLV) - goods.SE), 2);
if (Math.Abs(round) > 0.06)
{
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，金额乘以税率减税额的绝对值大于0.06，不能进行折扣汇总";
break;
}
if ((goods.DJ != 0.0) && (goods.SL != 0.0))
{
if (goods.HSJBZ)
{
if (Math.Abs(SaleBillCtrl.GetRound((double)(((goods.DJ * goods.SL) - goods.JE) - goods.SE), 2)) > 0.01)
{
num7 = num2 + 1;
str = "第" + num7.ToString() + "行，单价乘以数量不等于含税金额，不能进行折扣汇总";
break;
}
}
else if (Math.Abs(SaleBillCtrl.GetRound((double)((goods.DJ * goods.SL) - goods.JE), 2)) > 0.01)
{
str = "第" + ((num2 + 1)).ToString() + "行，单价乘以数量不等于金额，不能进行折扣汇总";
break;
}
}
}
Label_0544:
num += round;
}
if (str.Length > 0)
{
MessageManager.ShowMsgBox(str);
}
else
{
if (Math.Abs(SaleBillCtrl.GetRound(num, 2)) > 1.27)
{
str = "单据税额误差累计值大于1.27，不能进行折扣汇总";
}
if (str.Length > 0)
{
MessageManager.ShowMsgBox(str);
}
else
{
string str2 = new SaleBillDAL().SaveCollectDiscountToRealTable(this.bill);
if (str2 == "0")
{
string dJMonth = this.comboBoxYF.SelectedItem.ToString();
string dJType = this.comboBoxDJZL.SelectedValue.ToString();
string keyWord = this.GetKeyWord();
int key = this.GetKey();
this.aisinoDataGrid1.set_DataSource(this.hzBLL.QueryXSDJ(dJMonth, dJType, keyWord, this.hzBLL.Pagesize, this.hzBLL.CurrentPage, key));
this.SelectedBH = "NoExist";
this.aisinoDataGrid2.set_DataSource(this.hzBLL.QueryXSDJMX("NoExist", this.hzBLL.Pagesize, 1));
this.aisinoDataGrid3.set_DataSource(this.hzBLL.QueryXSDJMX("NoExist", this.hzBLL.Pagesize, 1));
int count = this.aisinoDataGrid2.get_Rows().Count;
for (num2 = 0; num2 < count; num2++)
{
string str6 = this.aisinoDataGrid2.get_Rows()[num2].Cells["SLV"].Value.ToString();
string str7 = this.aisinoDataGrid2.get_Rows()[num2].Cells["XH"].Value.ToString();
if (((str6 != null) && (str6 != "")) && (str6 != "中外合作油气田"))
{
string str8 = this.billBL.ShowSLV(this.bill, str7, str6);
if (str8 != "")
{
this.aisinoDataGrid2.get_Rows()[num2].Cells["SLV"].Value = str8;
}
}
}
MessageManager.ShowMsgBox("INP-272504");
}
else if (str2 == "NoBH")
{
MessageManager.ShowMsgBox("INP-272505");
}
else
{
MessageBoxHelper.Show(str2);
}
}
}
}
}
catch (Exception exception)
{
HandleException.HandleError(exception);
}
}