protected override void billOpen(string strBillno)
{
string StrSql = strDocSql + " AND A.SEQNO = '{0}'";
DataTable dtDoc = DbHelperOra.Query(string.Format(StrSql, strBillno)).Tables[0];
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference());
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
if (dtBill != null && dtBill.Rows.Count > 0)
{
Doc.GridRowAdd(GridGoods, dtBill);
}
PubFunc.FormLock(FormDoc, true, "");
TabStrip1.ActiveTabIndex = 1;
if (docFLAG.SelectedValue == "M")
{
//初始化按钮
btnDel.Enabled = true;
btnSave.Enabled = true;
btnAudit.Enabled = false;
btnDelRow.Enabled = true;
btnGoods.Enabled = true;
docMEMO.Enabled = true;
tbxREASON.Enabled = true;
btnPrint.Enabled = false;
ButSubmit.Enabled = true;
}
else if (docFLAG.SelectedValue == "N")
{
btnDel.Enabled = false;
btnSave.Enabled = false;
btnAudit.Enabled = true;
btnDelRow.Enabled = false;
btnGoods.Enabled = false;
btnPrint.Enabled = false;
ButSubmit.Enabled = false;
}
else if (docFLAG.SelectedValue == "Y")
{
//初始化按钮
btnDel.Enabled = false;
btnSave.Enabled = false;
btnAudit.Enabled = false;
btnDelRow.Enabled = false;
btnGoods.Enabled = false;
btnPrint.Enabled = true;
ButSubmit.Enabled = false;
}
}
protected void cxsj(String strCode)
{
string strSql = string.Format("select * from DOC_SUPPLIER where SUPID='{0}'", strCode);
DataTable dtProducer = DbHelperOra.Query(strSql).Tables[0];
if (dtProducer.Rows.Count > 0)
{
PubFunc.FormDataSet(FormProducer, dtProducer.Rows[0]);
tbxSUPPWD.Text = "";
if (dtProducer.Rows[0]["STR1"].ToString() == "Y")
{
chkSTR1.Checked = true;
}
else
{
chkSTR1.Checked = false;
}
}
if (ddlFLAG.SelectedValue == "Y")
{
PubFunc.FormLock(FormProducer, true);
btnDelete.Enabled = false;
btnSave.Enabled = false;
btnAudit.Enabled = false;
btnUnAudit.Enabled = true;
}
else
{
PubFunc.FormLock(FormProducer, false);
btnUnAudit.Enabled = false;
btnAudit.Enabled = true;
btnDelete.Enabled = true;
tbxSUPID.Enabled = false;
btnSave.Enabled = true;
hfdIsNew.Text = "N";
}
if (strCode == "00001" || strCode == "00002")
{
chkISDG.Enabled = false;
}
else
{
chkISDG.Enabled = true;
}
ddlFLAG.Enabled = false;
chkSTR1.Enabled = false;
}
protected override void billOpen(string strBillno)
{
DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0];
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference());
decimal bzslTotal = 0, feeTotal = 0;
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
if (dtBill != null && dtBill.Rows.Count > 0)
{
foreach (DataRow row in dtBill.Rows)
{
bzslTotal += Convert.ToDecimal(row["BZSL"]);
feeTotal += Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZSL"]);
}
}
Doc.GridRowAdd(GridGoods, dtBill);
//计算合计数量
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("BZSL", bzslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F2"));
GridGoods.SummaryData = summary;
PubFunc.FormLock(FormDoc, true, "");
TabStrip1.ActiveTabIndex = 1;
//判断按钮状态
if (docFLAG.SelectedValue == "N")
{
tbxBARCODE.Enabled = true;
btnExtraction.Enabled = true;
btnSave.Enabled = true;
btnAudit.Enabled = true;
btnPrint.Enabled = false;
btnDelRow.Enabled = true;
btnGoods.Enabled = true;
}
else
{
btnExtraction.Enabled = false;
btnSave.Enabled = false;
btnAudit.Enabled = false;
btnPrint.Enabled = true;
btnDelRow.Enabled = false;
btnGoods.Enabled = false;
}
}
protected override void billDelRow()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非新增单据不能删除！");
return;
}
if (GridGoods.SelectedCell == null)
{
return;
}
GridGoods.DeleteSelectedRows();
PubFunc.FormLock(FormDoc, true, "");
tbxINSERT.Enabled = true;
}
protected override void billDelRow()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非『新增』单据不能删行！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (GridGoods.SelectedRowID == null)
{
Alert.Show("当前未选中单元行，无法进行操作!", "消息提示", MessageBoxIcon.Warning);
return;
}
PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(GridGoods.SelectedRowID));
PubFunc.FormLock(FormDoc, true, "");
}
protected override void billNew()
{
GridGoods.DataSource = null;
GridGoods.DataBind();
PubFunc.FormLock(FormDoc, false);
docSEQNO.Text = string.Empty;
tgbCKDH.Text = string.Empty;
docSEQNO.Enabled = false;
docFLAG.Enabled = false;
docLRY.Enabled = false;
tbxYJJJ.Enabled = false;
Bill_create.Enabled = true;
tbxMEMO.Text = string.Empty;
tbxYJJJ.Text = string.Empty;
}
protected override void billDelRow()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非新增单据不能删除！");
return;
}
if (GridGoods.SelectedCell == null)
{
return;
}
GridGoods.DeleteSelectedRows();
PubFunc.FormLock(FormDoc, true, "");
trbBARCODE.Enabled = true;
//Alert.Show("【删行】操作成功，请点击【保存】按钮使【删行】操作生效！");
}
protected override void billDelRow()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非新增单据不能删除！");
return;
}
if (GridGoods.SelectedCell == null)
{
return;
}
int rowIndex = GridGoods.SelectedRowIndex;
PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(rowIndex));
PubFunc.FormLock(FormDoc, true, "");
}
protected void btnGoods_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(docDEPTOUT.SelectedValue) || string.IsNullOrWhiteSpace(docDEPTID.SelectedValue))
{
Alert.Show("表单字段为空，请补充完整后再追加商品！");
return;
}
if (docDEPTOUT.SelectedValue == docDEPTID.SelectedValue)
{
Alert.Show("调出科室和调入科室不能为同一个，请重新选择！");
return;
}
PubFunc.FormLock(FormDoc, true, "");
WindowGoods.Hidden = false;
DataSearch();
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非新单据不允许操作");
return;
}
//参数说明：cx-查询内容，bm-商品配置部门,su-供应商
string url = "~/ERPApply/Contant_GoodsWindow_His.aspx?bm=" + docDEPTID.SelectedValue + "&cx=" + docDEPTOUT.SelectedValue + "&su=";
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "可出定数商品信息查询"));
PubFunc.FormLock(FormDoc, true, "");
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
if ((",M,N").IndexOf(docFLAG.SelectedValue) < 0)
{
return;
}
PubFunc.FormLock(FormDoc, true, "");
docMEMO.Enabled = true;
//参数说明：cx-查询内容，bm-商品配置部门,su-供应商
string url = "~/ERPQuery/GoodsWindow_New.aspx?Deptout=" + docDEPTOUT.SelectedValue + "&DeptIn=" + docDEPTID.SelectedValue + "&GoodsState=YT";
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "商品信息查询"));
}
private void DataInit()
{
PubFunc.DdlDataGet("DDL_DOC_SUPPLIERNULL", ddlSUPID);
PubFunc.DdlDataGet("DDL_BILL_STATUSJSD", docFLAG, lstFLAG);
PubFunc.DdlDataGet("DDL_USER", ddlFKY);
PubFunc.DdlDataGet("DDL_SYS_DEPT", ddlDEPTID);
ddlFKY.SelectedValue = UserAction.UserID;
lstLRRQ1.SelectedDate = DateTime.Now;
lstLRRQ2.SelectedDate = DateTime.Now;
dpkFKRQ.SelectedDate = DateTime.Now;
PubFunc.FormLock(FormDoc, true);
nbxJSJE.Enabled = true;
tgbFPHM.Enabled = true;
tbxMEMO.Enabled = true;
ddlFKY.Enabled = true;
dpkFKRQ.Enabled = true;
//docFPJE.Enabled = true;
}
protected override void billDelRow()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非新增单据不能删除！");
return;
}
if (GridGoods.SelectedCell == null)
{
return;
}
//string rowIndex = GridGoods.SelectedRowID; // GridGoods.SelectedRowIndex动态行不能删除行索引，只能删除行ID
//PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(rowIndex));
GridGoods.DeleteSelectedRows();
PubFunc.FormLock(FormDoc, true, "");
//tbxINSERT.Enabled = true;
}
protected override void billNew()
{
PubFunc.FormDataClear(Formlis);
ddlYHY.SelectedValue = UserAction.UserID;
ddlLRY.SelectedValue = UserAction.UserID;
dpkYHRQ.SelectedDate = DateTime.Now;
dpkLRRQ.SelectedDate = DateTime.Now;
PubFunc.FormLock(Formlis, false);
ddlLRY.Enabled = false;
dpkLRRQ.Enabled = false;
ddlSHR.Enabled = false;
dpkSHRQ.Enabled = false;
docFLAG.Enabled = false;
GridLis.SummaryData = null;
PageContext.RegisterStartupScript(GridLis.GetRejectChangesReference());
}
protected void btnAudit_Click(object sender, EventArgs e)
{
int[] rows = GridSupplier.SelectedRowIndexArray;
if (rows.Length > 0 && !string.IsNullOrEmpty(tbxSUPID.Text))
{
if (PubFunc.FormDataCheck(FormProducer).Length > 1)
{
return; //存在为空的非空列则返回！
}
else
{
saveExec();
string strFLAG = ddlFLAG.SelectedValue.ToString();
if (strFLAG == "Y")
{
Alert.Show("已经审核通过，无需再审！");
}
else
{
string strSUPID = "";
foreach (int index in rows)
{
strSUPID += PubFunc.GridDataGet(GridSupplier, index)["SUPID"].ToString() + ",";
}
strSUPID = strSUPID.TrimEnd(',').Replace(",", "','");
DbHelperOra.ExecuteSql("UPDATE DOC_SUPPLIER SET FLAG = 'Y' WHERE SUPID IN ('" + strSUPID + "')");
Alert.Show("供应商资料 审核通过！");
OperLog("供应商资料", "审核供应商【" + strSUPID + "】");
ERPUtility.CacheClear("DOC_SUPPLIER");
}
}
}
else
{
Alert.Show("请选择需要审核的供应商！");
return;
}
String strSUPID1 = tbxSUPID.Text.ToString();
cxsj(strSUPID1);
PubFunc.FormLock(FormProducer, true);
dataSearch();
}
protected override void billOpen(string strBillno)
{
string StrSql = strDocSql + " AND A.SEQNO = '{0}'";
DataTable dtDoc = DbHelperOra.Query(string.Format(StrSql, strBillno)).Tables[0];
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference());
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
decimal bzslTotal = 0, xsslTotal = 0, feeTotal = 0;
if (dtBill != null && dtBill.Rows.Count > 0)
{
foreach (DataRow row in dtBill.Rows)
{
bzslTotal += Convert.ToDecimal(row["BZSL"]);
xsslTotal += Convert.ToDecimal((row["XSSL"] ?? "0"));
feeTotal += Convert.ToDecimal((row["XSSL"] ?? "0")) * Convert.ToDecimal(row["HSJJ"]);
LoadGridRow(row, false, "OLD");
}
}
//增加合计
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("BZSL", bzslTotal.ToString());
summary.Add("XSSL", xsslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F2"));
GridGoods.SummaryData = summary;
PubFunc.FormLock(FormDoc, true, "");
GridGoods.AllowCellEditing = false;
if (docFLAG.SelectedValue.Equals("W"))
{
btnAudit.Enabled = true;
}
else
{
btnAudit.Enabled = false;
}
TabStrip1.ActiveTabIndex = 1;
}
protected void goodsRow_DoubleClick(object sender, GridRowClickEventArgs e)
{
DataTable dtnew = DbHelperOra.Query("SELECT * FROM DOC_SUPPLIERTEMP t where t.supid='" + GridGoods.Rows[e.RowIndex].DataKeys[2] + "'").Tables[0];
if (dtnew.Rows.Count > 0)
{
//GridGoods.Rows[e.RowIndex]
}
if (hfdOper.Text == "sq")
{
PubFunc.FormDataSet(FormProducer, dtnew.Rows[0]);
if (tbxSEQNO.Text.Length > 0)
{
if (DbHelperOra.GetSingle("SELECT T.FLAG FROM DAT_TZSUP_DOC T WHERE T.SEQNO='" + tbxSEQNO.Text + "'").ToString() != "M")
{
PubFunc.FormLock(FormProducer, true);
}
}
}
if (hfdOper.Text == "zj")
{
PubFunc.FormDataSet(FormProducer, dtnew.Rows[0]);
PubFunc.FormLock(FormProducer, true);
}
if (ddlType.SelectedValue == "M")
{
DataTable dt = DbHelperOra.Query("SELECT * FROM DOC_SUPPLIER T WHERE T.SUPID = '" + GridGoods.Rows[e.RowIndex].DataKeys[2] + "' ORDER BY T.SUPID desc").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
formGet(Form3, dt.Rows[0]);
}
else
{
PubFunc.FormDataSet(Form3, GridGoods.Rows[e.RowIndex]);
}
PubFunc.FormLock(Form3, true);
Panel4.Hidden = false;
}
WindowGoods.Hidden = false;
GridSupplier.Hidden = true;
}
protected override void billGoods()
{
if (ddlTYPE.SelectedValue.Trim().Length < 1)
{
Alert.Show("请选择【调整类型】!", "提示信息", MessageBoxIcon.Warning);
return;
}
if (tbxGDNAME_OLD.Text.Length < 1 || tbxGDNAME.Text.Length < 1)
{
Alert.Show("请输入商品编码后，按回车键进行确认!", "提示信息", MessageBoxIcon.Warning);
return;
}
if (!CheckInfo())
{
Alert.Show("商品编码与商品名称不符，请检查！", "提示信息", MessageBoxIcon.Warning);
return;
}
WindowGoods.Hidden = false;
btnExlSch_Click(null, null);
PubFunc.FormLock(FormDoc, true, "");
}
private void DataInit()
{
if (Request.QueryString["oper"].ToString() == "ck" || Request.QueryString["oper"].ToString() == "xs")
{
PubFunc.DdlDataGet("DDL_SYS_DEPT", lstDEPTOUT, ddlDEPTID);
}
else
{
PubFunc.DdlDataGet("DDL_SYS_DEPOT", lstDEPTOUT, ddlDEPTID);
}
PubFunc.DdlDataGet("DDL_USER", lstJSY);
PubFunc.DdlDataGet("DDL_DOC_SHS", ddlsup, ddlSUPID);
PubFunc.FormLock(Formlis, true);
//lstLRRQ1默认为上次结算日期
//lstLRRQ1.SelectedDate = DateTime.Now;
lstLRRQ2.SelectedDate = DateTime.Now;
//默认为威高
ddlsup.SelectedValue = PubFunc.DbGetPara("SUPPLIER");
lstJSY.SelectedValue = UserAction.UserID;
}
protected override void billOpen(string strBillno)
{
DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0];
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference());
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
decimal bzslTotal = 0, feeTotal = 0;
if (dtBill != null && dtBill.Rows.Count > 0)
{
foreach (DataRow row in dtBill.Rows)
{
//LoadGridRow(row, false, "DSC");
bzslTotal += Convert.ToDecimal(row["BZSL"] ?? "0");
feeTotal += Convert.ToDecimal(row["HSJJ"] ?? "0") * Convert.ToDecimal(row["BZHL"] ?? "0");
}
/*
* 修 改 人 ：袁鹏 修改时间：2015-04-13
* 信息说明：这种加载方法比LoadGridRow(row, false, "DSC")更高效
* 研发组织：威高讯通信息科技有限公司
*/
PubFunc.GridRowAdd(GridGoods, dtBill);
}
trbEditorGDSEQ.Enabled = false;
PubFunc.FormLock(FormDoc, true, "");
//计算合计数量
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("BZSL", bzslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F6"));
GridGoods.SummaryData = summary;
TabStrip1.ActiveTabIndex = 1;
}
protected void btnDelRow_Click(object sender, EventArgs e)
{
//201509211429 6448版本缺失 add by zhanghaicheng
if (docFLAG.SelectedValue != "M")
{
Alert.Show("非『新增』单据不能删行！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (CheckFlagForM() && docBILLNO.Text.Length > 0)
{
Alert.Show("此单据已经被别人操作，请等待操作!");
return;
}
if (GridGoods.SelectedCell == null)
{
Alert.Show("当前未选中单元行，无法进行操作!", "消息提示", MessageBoxIcon.Warning);
return;
}
GridGoods.DeleteSelectedRows();
PubFunc.FormLock(FormDoc, true, "");
docMEMO.Enabled = true;
}
protected override void billDelRow()
{
if (docFLAG.SelectedValue != "M")
{
Alert.Show("非新增单据不能删除！");
return;
}
string strBillno = docSEQNO.Text;
if (!Doc.getFlag(strBillno, "M", BillType))
{
Alert.Show("此单据已被其他人处理，请刷新页面更新单据状态！", "警告提示", MessageBoxIcon.Warning);
return;
}
if (GridGoods.SelectedCell == null)
{
return;
}
GridGoods.DeleteSelectedRows();
//int rowIndex = GridGoods.SelectedRowIndex;
//PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(rowIndex));
PubFunc.FormLock(FormDoc, true, "");
}
protected override void billDelRow()
{
if (docFLAG.SelectedValue != "N" && docFLAG.SelectedValue != "R")
{
Alert.Show("非『新增』单据不能删行！", "消息提示", MessageBoxIcon.Warning);
return;
}
string strBillno = docSEQNO.Text;
if (!Doc.getFlag(strBillno, "N", BillType) && !Doc.getFlag(strBillno, "R", BillType))
{
Alert.Show("此单据已被其他人处理，请刷新页面更新单据状态！", "警告提示", MessageBoxIcon.Warning);
return;
}
if (GridGoods.SelectedRowID == null)
{
Alert.Show("当前未选中单元行，无法进行操作!", "消息提示", MessageBoxIcon.Warning);
return;
}
//PageContext.RegisterStartupScript(GridGoods.GetDeleteRowReference(GridGoods.SelectedRowID));
GridGoods.DeleteSelectedRows();
PubFunc.FormLock(FormDoc, true, "");
}
protected override void billAddRow()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
string strBillno = docSEQNO.Text;
// 新增数据初始值
JObject defaultObj = new JObject();
defaultObj.Add("GDSEQ", "");
defaultObj.Add("BARCODE", "");
defaultObj.Add("GDNAME", "");
defaultObj.Add("GDSPEC", "");
defaultObj.Add("UNIT", "");
defaultObj.Add("UNITNAME", "");
defaultObj.Add("BZHL", "");
defaultObj.Add("BZSL", "");
defaultObj.Add("DHSL", "");
defaultObj.Add("XSSL", "");
defaultObj.Add("JXTAX", "");
defaultObj.Add("HSJJ", "");
defaultObj.Add("HSJE", "");
defaultObj.Add("ZPBH", "");
defaultObj.Add("PRODUCER", "");
defaultObj.Add("PRODUCERNAME", "");
defaultObj.Add("HWID", "");
defaultObj.Add("PH", "");
defaultObj.Add("PZWH", "");
defaultObj.Add("RQ_SC", "");
defaultObj.Add("YXQZ", "");
defaultObj.Add("MEMO", "");
PubFunc.FormLock(FormDoc, true, "");
trbEditorGDSEQ.Enabled = true;
PageContext.RegisterStartupScript(GridGoods.GetAddNewRecordReference(defaultObj, true));
}
protected override void billOpen(string strBillno)
{
DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0];
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference());
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
GridGoods.DataSource = dtBill;
GridGoods.DataBind();
PubFunc.FormLock(FormDoc, true, "");
TabStrip1.ActiveTabIndex = 1;
//屏蔽不需要的操作按钮
if (ddlFLAG.SelectedValue == "N")
{
btnTJ.Enabled = false;
btnAddRow.Enabled = false;
btnUpdate.Enabled = false;
btnDelect.Enabled = false;
btnDelRow.Enabled = false;
btnSave.Enabled = false;
btnPrint.Enabled = true;
btnCancel.Enabled = true;
btnAudit.Enabled = true;
btnGoods.Enabled = false;
btnDel.Enabled = false;
}
if (ddlFLAG.SelectedValue == "R")
{
btnAddRow.Enabled = false;
btnUpdate.Enabled = false;
btnDelect.Enabled = false;
btnDelRow.Enabled = false;
btnSave.Enabled = false;
btnPrint.Enabled = true;
btnCancel.Enabled = true;
btnAudit.Enabled = false;
btnGoods.Enabled = true;
string flag = DbHelperOra.GetSingle("select XGTYPE from DAT_TZSUP_DOC t where t.billno='" + strBillno + "'").ToString();
if (flag == "N")
{
btnAddRow.Enabled = true;
}
else if (flag == "M")
{
btnUpdate.Enabled = true;
}
else if (flag == "D")
{
btnDelect.Enabled = true;
}
btnDelRow.Enabled = true;
btnSave.Enabled = true;
btnCancel.Enabled = false;
btnDel.Enabled = true;
}
if (ddlFLAG.SelectedValue == "M")
{
btnAddRow.Enabled = false;
btnUpdate.Enabled = false;
btnDelect.Enabled = false;
btnTJ.Enabled = true;
btnGoods.Enabled = true;
string flag = DbHelperOra.GetSingle("select XGTYPE from DAT_TZSUP_DOC t where t.billno='" + strBillno + "'").ToString();
if (flag == "N")
{
btnAddRow.Enabled = true;
}
else if (flag == "M")
{
btnUpdate.Enabled = true;
}
else if (flag == "D")
{
btnDelect.Enabled = true;
}
btnDelRow.Enabled = true;
btnSave.Enabled = true;
btnDel.Enabled = true;
}
else if (ddlFLAG.SelectedValue == "Y")
{
btnAddRow.Enabled = false;
btnUpdate.Enabled = false;
btnDelect.Enabled = false;
btnDelRow.Enabled = false;
btnSave.Enabled = false;
btnTJ.Enabled = false;
btnAudit.Enabled = false;
btnPrint.Enabled = true;
btnCancel.Enabled = false;
btnUpdate.Enabled = false;
btnDelect.Enabled = false;
btnGoods.Enabled = false;
btnDel.Enabled = false;
}
}
protected override void billOpen(string strBillno)
{
DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0];
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference());
//decimal bzslTotal = 0, feeTotal = 0;
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
if (dtBill != null && dtBill.Rows.Count > 0)
{
Doc.GridRowAdd(GridGoods, dtBill);
}
//计算合计数量
//JObject summary = new JObject();
//summary.Add("GDNAME", "本页合计");
//summary.Add("BZSL", bzslTotal.ToString());
//summary.Add("HSJE", feeTotal.ToString("F2"));
//GridGoods.SummaryData = summary;
PubFunc.FormLock(FormDoc, true, "");
if ((",M,R").IndexOf(docFLAG.SelectedValue) > 0)
{
btnPrint.Enabled = false;
btnDel.Enabled = true;
btnSave.Enabled = true;
btnDelRow.Enabled = true;
btnGoods.Enabled = true;
btnAudit.Enabled = true;
btnCancel.Enabled = true;
}
else if (docFLAG.SelectedValue == "N")
{
btnPrint.Enabled = true;
btnDel.Enabled = false;
btnSave.Enabled = false;
btnAudit.Enabled = true;
btnDelRow.Enabled = false;
btnCancel.Enabled = true;
btnGoods.Enabled = false;
}
else if (docFLAG.SelectedValue == "Y")
{
btnPrint.Enabled = true;
btnDel.Enabled = false;
btnSave.Enabled = false;
btnAudit.Enabled = false;
btnDelRow.Enabled = false;
btnCancel.Enabled = false;
btnGoods.Enabled = false;
}
else
{
btnPrint.Enabled = false;
btnDel.Enabled = false;
btnSave.Enabled = false;
btnAudit.Enabled = false;
btnDelRow.Enabled = false;
btnCancel.Enabled = false;
btnGoods.Enabled = false;
}
TabStrip1.ActiveTabIndex = 1;
}
protected override void billOpen(string strBillno)
{
DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0];
if (dtDoc != null && dtDoc.Rows.Count > 0)
{
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
}
else
{
Alert.Show("单据信息获取失败！！！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (docLRY.SelectedValue == null)
{
docLRY.SelectedValue = UserAction.UserID;
}
PageContext.RegisterStartupScript(GridCom.GetRejectChangesReference());
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
if (dtBill != null && dtBill.Rows.Count > 0)
{
decimal ddslTotal = 0, bzslTotal = 0, feeTotal = 0;
foreach (DataRow row in dtBill.Rows)
{
ddslTotal += Convert.ToDecimal(string.IsNullOrWhiteSpace(row["DDSL"].ToString()) ? "0" : row["DDSL"].ToString());
if (!PubFunc.StrIsEmpty(Convert.ToString(row["BZSL"] ?? "0")))
{
bzslTotal += Convert.ToDecimal(row["BZSL"] ?? "0");
feeTotal += Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZSL"] ?? "0");
}
row["HSJE"] = Convert.ToDecimal(row["HSJE"]).ToString("F2");
//处理订货单位
//DataTable dtGoods = DbHelperOra.QueryForTable(string.Format("select F_GETUNITNAME(UNIT_DABZ) UNIT_DABZNAME,F_GETUNITNAME(UNIT_ZHONGBZ) UNIT_ZHONGBZNAME,UNIT_ORDER,PIZNO from doc_goods where gdseq='{0}'", row["GDSEQ"].ToString()));
//if (dtGoods != null && dtGoods.Rows.Count > 0)
//{
// if ("Z".Equals(dtGoods.Rows[0]["UNIT_ORDER"].ToString()))
// {
// row["UNITNAME"] = dtGoods.Rows[0]["UNIT_ZHONGBZNAME"].ToString();
// }
// if ("D".Equals(dtGoods.Rows[0]["UNIT_ORDER"].ToString()))
// {
// row["UNITNAME"] = dtGoods.Rows[0]["UNIT_DABZNAME"].ToString();
// }
// row["PZWH"] = dtGoods.Rows[0]["PIZNO"].ToString();
//}
}
/*
* 修 改 人 ：袁鹏 修改时间：2015-03-20
* 信息说明：这种加载方法比LoadGridRow(row, false, "OLD")更高效
*/
PubFunc.GridRowAdd(GridCom, dtBill);
//计算合计数量
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("DDSL", ddslTotal.ToString());
summary.Add("BZSL", bzslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F2"));
GridCom.SummaryData = summary;
}
PubFunc.FormLock(FormDoc, true, "");
if (docDHRQ.Text == "")
{
docDHRQ.SelectedDate = DateTime.Now;
}
if (docFLAG.SelectedValue == "M")
{
docDHRQ.Enabled = true;
}
TabStrip1.ActiveTabIndex = 1;
//增加按钮控制
if (docFLAG.SelectedValue == "M")
{
btnDel.Enabled = true;
btnSave.Enabled = true;
btnCommit.Enabled = true;
btnAudit.Enabled = false;
btnCancel.Enabled = false;
btnPrint.Enabled = false;
btnPrint.Enabled = false;
btnDelRow.Enabled = true;
btnGoods.Enabled = true;
tbxMEMO.Enabled = true;
}
else if (docFLAG.SelectedValue == "N")
{
btnDel.Enabled = false;
btnSave.Enabled = false;
btnCommit.Enabled = false;
btnAudit.Enabled = true;
btnCancel.Enabled = true;
btnPrint.Enabled = false;
btnPrint.Enabled = false;
btnDelRow.Enabled = false;
btnGoods.Enabled = false;
tbxMEMO.Enabled = false;
}
else
{
btnDel.Enabled = false;
btnSave.Enabled = false;
btnCommit.Enabled = false;
btnAudit.Enabled = false;
btnCancel.Enabled = false;
btnPrint.Enabled = true;
btnPrint.Enabled = true;
btnDelRow.Enabled = false;
btnGoods.Enabled = false;
tbxMEMO.Enabled = false;
}
}
protected override void billOpen(string strBillno)
{
DataTable dtDoc = DbHelperOra.Query(string.Format(strDocSql, strBillno)).Tables[0];
if (dtDoc != null && dtDoc.Rows.Count > 0)
{
PubFunc.FormDataSet(FormDoc, dtDoc.Rows[0]);
}
else
{
Alert.Show("单据信息获取失败！！！", "警告提示", MessageBoxIcon.Warning);
return;
}
PageContext.RegisterStartupScript(GridGoods.GetRejectChangesReference());
DataTable dtBill = DbHelperOra.Query(string.Format(strComSql, strBillno)).Tables[0];
decimal bzslTotal = 0, feeTotal = 0;
if (dtBill != null && dtBill.Rows.Count > 0)
{
foreach (DataRow row in dtBill.Rows)
{
bzslTotal += Convert.ToDecimal(row["YSSL"] ?? "0");
feeTotal += Convert.ToDecimal(row["YSSL"] ?? "0") * Convert.ToDecimal(row["HSJJ"] ?? "0");
}
Doc.GridRowAdd(GridGoods, dtBill);
}
//增加合计
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("YSSL", bzslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F2"));
GridGoods.SummaryData = summary;
PubFunc.FormLock(FormDoc, true, "");
TabStrip1.ActiveTabIndex = 1;
//按钮状态转换
if (docFLAG.SelectedValue == "N")
{
//提交
btnNew.Enabled = true;
btnGenerate.Enabled = false;
btnSave.Enabled = false;
btnSumbit.Enabled = false;
btnAudit.Enabled = true;
btnCancel.Enabled = true;
btnPrint.Enabled = true;
btnExport.Enabled = true;
btnDelRow.Enabled = false;
}
else if (docFLAG.SelectedValue.Equals("R"))
{
btnSave.Enabled = true;
btnSumbit.Enabled = true;
btnDelRow.Enabled = true;
btnGenerate.Enabled = false;
// dpkRQSJ1.Enabled = true;
// dpkRQSJ2.Enabled = true;
// ddlDEPTID.Enabled = true;
// nbxYSSL.Enabled = true;
docMEMO.Enabled = true;
}
else if (docFLAG.SelectedValue.Equals("M"))
{
btnSave.Enabled = true;
btnSumbit.Enabled = true;
btnDelRow.Enabled = true;
btnGenerate.Enabled = false;
btnExport.Enabled = false;
btnPrint.Enabled = false;
btnCancel.Enabled = false;
btnAudit.Enabled = false;
// dpkRQSJ1.Enabled = true;
// dpkRQSJ2.Enabled = true;
// ddlDEPTID.Enabled = true;
// nbxYSSL.Enabled = true;
docMEMO.Enabled = true;
}
else
{
//审核
btnNew.Enabled = true;
btnGenerate.Enabled = false;
btnSave.Enabled = false;
btnSumbit.Enabled = false;
btnAudit.Enabled = false;
btnPrint.Enabled = true;
btnExport.Enabled = true;
btnDelRow.Enabled = false;
}
}
protected override void billOpen(string strBillno)
{
//表头进行赋值
DataTable dtDoc = DbHelperOra.Query(strDocSql + string.Format(" AND SEQNO='{0}'", strBillno)).Tables[0];
PubFunc.FormDataSet(Formlis, dtDoc.Rows[0]);
PubFunc.FormLock(Formlis, true);
string strFlag = DbHelperOra.GetSingle(string.Format(@"SELECT flag FROM DAT_YH_DOC WHERE SEQNO = '{0}'", strBillno)).ToString();
hfdOper.Text = strFlag;
if (strFlag == "M")
{
tbxMEMO.Enabled = false;
btnDelRow.Enabled = true;
btnDel.Enabled = true;
btnSave.Enabled = false;
btnTJ.Enabled = true;
btnAudit.Enabled = false;
btnPrint.Enabled = false;
}
else if (strFlag == "N")
{
tbxMEMO.Enabled = true;
btnDelRow.Enabled = false;
btnDel.Enabled = false;
btnSave.Enabled = true;
btnTJ.Enabled = false;
btnAudit.Enabled = true;
btnPrint.Enabled = true;
}
else
{
tbxMEMO.Enabled = false;
btnDelRow.Enabled = false;
btnDel.Enabled = false;
btnSave.Enabled = false;
btnTJ.Enabled = false;
btnAudit.Enabled = false;
btnPrint.Enabled = false;
}
//表体赋值
PageContext.RegisterStartupScript(GridLis.GetRejectChangesReference());
decimal bzslTotal = 0, feeTotal = 0;
string sql = strComSql + string.Format(" AND SEQNO='{0}'", strBillno);
DataTable dtBill = DbHelperOra.Query(sql).Tables[0];
if (dtBill != null && dtBill.Rows.Count > 0)
{
foreach (DataRow row in dtBill.Rows)
{
bzslTotal += Convert.ToDecimal(row["KCSL"] ?? "0");
feeTotal += Convert.ToDecimal(row["HSJE"] ?? "0");
}
Doc.GridRowAdd(GridLis, dtBill);
}
//计算合计数量
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("KCSL", bzslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F2"));
GridLis.SummaryData = summary;
TabStrip1.ActiveTabIndex = 2;
}
protected override void billAddRow()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非『新增』单据不能增行！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList();
if (newDict.Count == 0)
{
if (Doc.DbGetSysPara("ISAUTOAPPLY") == "Y")
{
string sql = @"SELECT A.*, A.ZGKC - A.KCSL DHSL, (A.ZGKC - A.KCSL) / A.BZHL BZSL,
((A.ZGKC - A.KCSL) / A.BZHL) * A.HSJJ HSJE,A.KCSL NUM1
FROM (SELECT G.GDSEQ,
G.BARCODE,
G.GDNAME,
G.GDSPEC,
G.UNIT,
F_GETUNITNAME(G.UNIT) UNITNAME,
G.BZHL,
G.JXTAX,
G.HSJJ,
G.ZPBH,
G.PRODUCER,
F_GETPRODUCERNAME(G.PRODUCER) PRODUCERNAME,
PZ.HJCODE1,
'自动生成' MEMO,
G.ISLOT,
G.ISGZ,
PZ.ZDKC,
PZ.ZGKC,
(SELECT NVL(SUM(KCSL), 0)
FROM DAT_GOODSSTOCK
WHERE GDSEQ = G.GDSEQ) KCSL
FROM DOC_GOODSCFG PZ, DOC_GOODS G
WHERE PZ.GDSEQ = G.GDSEQ
AND PZ.ZDKC > 0
AND PZ.ZGKC > 0
AND PZ.DEPTID = '{0}') A
WHERE KCSL < ZDKC";
DataTable dt = DbHelperOra.Query(string.Format(sql, docDEPTID.SelectedValue)).Tables[0];
decimal bzslTotal = 0, feeTotal = 0;
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
bzslTotal += Convert.ToDecimal(row["BZSL"]);
feeTotal += Convert.ToDecimal(row["BZSL"]) * Convert.ToDecimal(row["HSJJ"]) * Convert.ToDecimal(row["BZHL"]);
LoadGridRow(row, false, "OLD");
}
}
else
{
PubFunc.GridRowAdd(GridGoods, "INIT");
}
//增加合计
JObject summary = new JObject();
summary.Add("GDNAME", "本页合计");
summary.Add("BZSL", bzslTotal.ToString());
summary.Add("HSJE", feeTotal.ToString("F2"));
GridGoods.SummaryData = summary;
}
else
{
PubFunc.GridRowAdd(GridGoods, "INIT");
}
}
else
{
PubFunc.GridRowAdd(GridGoods, "INIT");
}
PubFunc.FormLock(FormDoc, true, "");
}