protected void btnSave_Click(object sender, EventArgs e)
{
if (ddlFLAG.SelectedValue != "N")
{
Alert.Show("此发票已被使用,不允许更改!");
return;
}
if (PubFunc.FormDataCheck(Formlist).Length > 0)
{
Alert.Show("信息未维护完全!"); return;
}
if (lstSEQNO.Enabled)
{
if (DbHelperOra.Exists("SELECT 1 FROM dat_jsd_fp WHERE SEQNO='" + lstSEQNO.Text + "'"))
{
Alert.Show("此发票号码已存在,请检查!");
return;
}
string strSql = @"INSERT INTO dat_jsd_fp(CUSTID,SEQNO,FPTYPE,FLAG,TAXRATE,SUPID,SUPNAME,LRY,LRRQ,FPJE,JSJE,USEJE,MEMO)
select F_GETPARA('USERNAME'),'" + lstSEQNO.Text + "','" + lstFPTYPE.SelectedValue + "','N','" + ddlTAXRATE.SelectedValue + "','" + ddlSUPID.SelectedValue + "',F_GETSUPNAME('" + ddlSUPID.SelectedValue + "'),'" + lstLRY.SelectedValue + "',to_date('" + lstLRRQ.Text + "','YYYY-MM-DD')," + nbxFPJE.Text + ",0," + nbxFPJE.Text + ",'" + tbxMEMO.Text + "' from dual";
DbHelperOra.ExecuteSql(strSql);
open();
}
else
{
if (lstSEQNO.Text.Length < 1)
{
return;
}
string strUp = "update dat_jsd_fp set FPJE =" + nbxFPJE.Text + ",USEJE =" + nbxFPJE.Text + ",FPTYPE='" + lstFPTYPE.SelectedValue + "',SUPID='" + ddlSUPID.SelectedValue + "',TAXRATE='" + ddlTAXRATE.SelectedValue + "',MEMO ='" + tbxMEMO.Text + "' WHERE SEQNO='" + lstSEQNO.Text + "'";
DbHelperOra.ExecuteSql(strUp);
}
Alert.Show("保存数据成功!");
}
protected void btnSave_Click(object sender, EventArgs e)
{
MyTable mtType = new MyTable("DOC_LICENSE");
if (PubFunc.FormDataCheck(FormProducer).Length > 1)
{
return; //存在为空的非空列则返回！
}
if ((DbHelperOra.Exists("select 1 from DOC_LICENSE where code = '" + tbxCODE.Text + "'")) && (!hfdIsNew.Text.Equals("N")))
{
Alert.Show("此证照编码已经存在,请重新输入!");
return;
}
if (string.IsNullOrWhiteSpace(ddlFLAG.SelectedValue))
{
Alert.Show("请选择证照类别状态！", "提示", MessageBoxIcon.Information);
return;
}
mtType.ColRow = PubFunc.FormDataHT(FormProducer);
if (hfdIsNew.Text == "" || hfdIsNew.Text == "Y")
{
mtType.InsertExec();
}
else
{
mtType.UpdateExec("");
}
Alert.Show("数据保存成功！");
dataSearch();
//hfdIsNew.Text = "N";
}
private void DataQuery()
{
String sql = @"SELECT DBC.USERS USERID,OU.USERNAME,DBC.ISSEND,DECODE(DBC.ISSEND,'N','未发送','Y','已发送','E','异常')ISSENDNAME,DBC.BRCONTENT,DBC.TIMEUP FROM DOC_BRIEF_CON DBC,SYS_OPERUSER OU WHERE DBC.USERS=OU.USERID ";
int total = 0;
string strwhere = "";
PubFunc.FormDataCheck(FormSearch);
if (!string.IsNullOrEmpty(ddlUSERS.SelectedValue))
{
strwhere += string.Format(" AND OU.USERID LIKE'%{0}%' ", ddlUSERS.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlISSEND.SelectedValue))
{
strwhere += string.Format(" AND DBC.ISSEND='{0}' ", ddlISSEND.SelectedValue);
}
if (dpkBegRQ.SelectedDate != null && dpkEndRQ.SelectedDate != null)
{
strwhere += string.Format(" AND TRUNC(DBC.TIMEUP,'DD') BETWEEN TRUNC(TO_DATE('{0}','YYYY-MM-DD HH24:MI:SS'),'DD') AND TRUNC(TO_DATE('{1}','YYYY-MM-DD HH24:MI:SS'),'DD') ", dpkBegRQ.SelectedDate, dpkEndRQ.SelectedDate);
}
DataTable dt = PubFunc.DbGetPage(GridToBrief.PageIndex, GridToBrief.PageSize, sql + strwhere + " ORDER BY DECODE(DBC.ISSEND,'1','2'),DBC.TIMEUP ", ref total);
GridToBrief.DataSource = dt;
GridToBrief.RecordCount = total;
GridToBrief.DataBind();
}
protected void btnRejectSubmit_Click(object sender, EventArgs e)
{
if (ddlReject.SelectedText == "--请选择--")
{
Alert.Show("请选择驳回原因");
return;
}
if (txaMemo.Text.Length > 30)
{
Alert.Show("驳回原因超长！", MessageBoxIcon.Warning);
return;
}
PubFunc.FormDataCheck(Form2);
//增加待办事宜
List <CommandInfo> cmdList = new List <CommandInfo>();
string strMemo = docMEMO.Text + ";驳回原因:" + ddlReject.SelectedText;
if (!string.IsNullOrWhiteSpace(txaMemo.Text.Trim()))
{
strMemo += ";详细说明;" + txaMemo.Text;
}
cmdList.Add(new CommandInfo(string.Format("update DAT_YS_DOC SET FLAG='R',MEMO='{0}',SHR={1},SHRQ=SYSDATE WHERE SEQNO='{2}' AND FLAG='N'", strMemo, "'" + UserAction.UserID + "'", docBILLNO.Text), null));
if (DbHelperOra.ExecuteSqlTran(cmdList))
{
WindowReject.Hidden = true;
billOpen(docBILLNO.Text);
Alert.Show("驳回成功");
btnAudit.Enabled = false;
txaMemo.Text = "";
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
String sql = @"SELECT DBC.USERS USERID,OU.USERNAME,DBC.ISSEND,DECODE(DBC.ISSEND,'N','未发送','Y','已发送','E','异常')ISSENDNAME,DBC.BRCONTENT,DBC.TIMEUP FROM DOC_BRIEF_CON DBC,SYS_OPERUSER OU WHERE DBC.USERS=OU.USERID ";
int total = 0;
string strwhere = "";
PubFunc.FormDataCheck(FormSearch);
if (!string.IsNullOrEmpty(ddlUSERS.SelectedValue))
{
strwhere += string.Format(" AND OU.USERID LIKE'%{0}%' ", ddlUSERS.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlISSEND.SelectedValue))
{
strwhere += string.Format(" AND DBC.ISSEND='{0}' ", ddlISSEND.SelectedValue);
}
if (dpkBegRQ.SelectedDate != null && dpkEndRQ.SelectedDate != null)
{
strwhere += string.Format(" AND TRUNC(DBC.TIMEUP,'DD') BETWEEN TRUNC(TO_DATE('{0}','YYYY-MM-DD HH24:MI:SS'),'DD') AND TRUNC(TO_DATE('{1}','YYYY-MM-DD HH24:MI:SS'),'DD') ", dpkBegRQ.SelectedDate, dpkEndRQ.SelectedDate);
}
sql += strwhere;
DataTable dtData = DbHelperOra.Query(sql).Tables[0];
if (dtData == null || dtData.Rows.Count == 0)
{
Alert.Show("无法导出！", "消息提示", MessageBoxIcon.Warning);
return;
}
DataTable dt = PubFunc.GridDataGet(GridToBrief);
string[,] colName = { { "USERID", "USERNAME", "ISSENDNAME", "TIMEUP", "BRCONTENT" }, { "用户编码", "用户名称", "状态", "更新时间", "发送内容" } };
ExcelHelper.ExportByWeb(dt, "简报发送信息导出", "简报发送信息导出_" + DateTime.Now.ToString("yyyyMMddHH") + ".xls", colName);
}
protected void btnSave_Click(object sender, EventArgs e)
{
MyTable mtType = new MyTable("DOC_LICENSE");
if (PubFunc.FormDataCheck(FormProducer).Length > 1)
{
return; //存在为空的非空列则返回！
}
if ((DbHelperOra.Exists("select 1 from DOC_LICENSE where code = '" + tbxCODE.Text + "'")) && (!hfdIsNew.Text.Equals("N")))
{
Alert.Show("此证照编码已经存在,请重新输入!");
return;
}
mtType.ColRow = PubFunc.FormDataHT(FormProducer);
if (hfdIsNew.Text == "" || hfdIsNew.Text == "Y")
{
mtType.InsertExec();
}
else
{
mtType.UpdateExec("");
}
Alert.Show("数据保存成功！");
dataSearch();
hfdIsNew.Text = "N";
}
private void save(string flag = "N")
{
#region 数据有效性验证
if (docFLAG.SelectedValue != "M" && docFLAG.SelectedValue != "R")
{
Alert.Show("非[新单]不能保存！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (PubFunc.FormDataCheck(FormDoc).Length > 0)
{
return;
}
List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList().ToList();
if (newDict.Count == 0)
{
Alert.Show("请输入商品信息", "消息提示", MessageBoxIcon.Warning);
return;
}
List <Dictionary <string, object> > goodsData = new List <Dictionary <string, object> >();
string msg = "";
//判断是否有空行、批号填写是否符合要求
for (int i = 0; i < newDict.Count; i++)
{
if (!string.IsNullOrWhiteSpace(newDict[i]["GDSEQ"].ToString()) && !string.IsNullOrWhiteSpace(newDict[i]["GDNAME"].ToString()))
{
if (int.Parse(newDict[i]["BZSL"].ToString()) > int.Parse(newDict[i]["DHSL"].ToString()))
{
Alert.Show("第" + (i + 1) + "行商品【" + newDict[i]["GDNAME"].ToString() + "】【使用数】不允许大于【预入库数量】", "提示信息", MessageBoxIcon.Warning);
return;
}
if (int.Parse(newDict[i]["BZSL"].ToString()) != int.Parse(newDict[i]["DHSL"].ToString()))
{
msg += "第" + (i + 1) + "行商品【" + newDict[i]["GDNAME"].ToString() + "】，";
}
if ((newDict[i]["STR1"] ?? "").ToString().Length > 0 && (newDict[i]["BZSL"] ?? "").ToString() != "1")
{
Alert.Show("第" + (i + 1) + "行商品【" + newDict[i]["GDNAME"].ToString() + "】【使用数】不允许大于【预入库数量】", "提示信息", MessageBoxIcon.Warning);
return;
}
}
}
#endregion
if (!string.IsNullOrWhiteSpace(msg))
{
msg += "【使用数】不等于【预入库数量】，确认保存，请选择【确定】";
PageContext.RegisterStartupScript(Confirm.GetShowReference(msg, "消息提示", MessageBoxIcon.Information, PageManager1.GetCustomEventReference("btnOk"), PageManager1.GetCustomEventReference("btnCancel")));
}
else
{
btnOk();
}
SaveSuccess = true;
}
protected void btnGoods_Click(object sender, EventArgs e)
{
if (PubFunc.FormDataCheck(FormCond).Length > 1)
{
return;
}
string url = "~/ERPQuery/GoodsWindow_New.aspx?Deptout=" + docDEPTID.SelectedValue;// + "&goodsType=" + docCATID.SelectedValue;
PubFunc.FormLock(FormCond, true, "");
PageContext.RegisterStartupScript(winGoodsQuery.GetSaveStateReference(hfdValue.ClientID) + winGoodsQuery.GetShowReference(url, "商品信息查询"));
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
//参数说明：cx-查询内容，dr-调入科室,dc-调出科室
string url = "~/ERPQuery/GoodsWindow_KSD.aspx?dc=" + docDEPTOUT.SelectedValue + "&cx=&dr=" + docDEPTID.SelectedValue;
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "商品信息查询"));
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(Formlist).Length > 1)
{
return;
}
//参数说明：cx-查询内容，bm-商品配置部门,su-供应商
string url = "~/ERPQuery/GoodsWindow_New.aspx";
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "商品信息查询"));
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
//参数说明：cx-查询内容，bm-商品配置部门,su-供应商
string url = "~/ERPQuery/GoodsWindow_Zp.aspx?bm=" + docDEPTOUT.SelectedValue + "_" + docDEPTID.SelectedValue + "&cx=&su=";
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "赠品商品信息查询"));
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
PubFunc.FormLock(FormDoc, true, "");
string url = "~/ERPQuery/GoodsWindow_New.aspx?Deptout=" + docDEPTID.SelectedValue + "&GoodsState=YT";
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "商品信息查询"));
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (PubFunc.FormDataCheck(FormMx).Length > 0)
{
return;
}
//if (tbxCode.Text.Length != ddlSJCODE.SelectedValue.Length + 2 && tbxCode.Text.Length > 2)
//{
// Alert.Show("编码规则不正确，请检查！", "提示信息", MessageBoxIcon.Warning);
// return;
//}
//增加控制避免主键重复
if ((DbHelperOra.Exists("select 1 from SYS_DEPT where code = '" + tbxCode.Text + "'")) && (tbxCode.Enabled))
{
Alert.Show("你输入的编码已存在,请检查!");
return;
}
if (string.IsNullOrWhiteSpace(ddlSJCODE.SelectedValue))
{
Alert.Show("请填选上级！", "提示", MessageBoxIcon.Information);
return;
}
if (!CheckTel(tbxSTR6.Text))
{
Alert.Show("联系电话请保证格式（固话XXX-XXX）(手机1XXX)！");
return;
}
string ls_codelabel;
MyTable mtTable = new MyTable(strTable, "CODE");
mtTable.ColRow = PubFunc.FormDataHT(FormMx);
ls_codelabel = PubFunc.FormLabelGet(FormMx, "CODE");
if (PubFunc.StrIsEmpty(mtTable.ColRow["CODE"].ToString()))
{
Alert.Show("【" + ls_codelabel + "】不能为空！");
return;
}
if (tbxCode.Enabled) //新增
{
mtTable.InsertExec();
}
else
{
mtTable.UpdateExec("");
}
//写入日志
OperLog("管理架构定义", "修改资料【" + tbxCode.Text + "】");
Alert.Show("数据保存成功！");
ERPUtility.CacheClear("SYS_DEPT");
tbxCode.Enabled = false;
InitTree();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (PubFunc.FormDataCheck(FormLot).Length > 1)
{
return;
}
hfdGDSEQ.Text = tbxGDNAME.Text;
if (PubFunc.StrIsEmpty(hfdGDSEQ.Text))
{
Alert.Show(string.Format("您输入的商品【{0}】在商品资料中不存在，请重新输入！", tbxGDNAME.Text), "消息提示", MessageBoxIcon.Warning);
return;
}
if (dpkYXQZ.SelectedDate == null || dpkRQ_SC.SelectedDate == null)
{
Alert.Show("输入的效期或生产日期错误,请检查!", "消息提示", MessageBoxIcon.Warning);
return;
}
DateTime time_sc = Convert.ToDateTime(dpkRQ_SC.Text);
DateTime time_yx = Convert.ToDateTime(dpkYXQZ.Text);
DateTime time_now = new DateTime();
time_now = DateTime.Now;
if (DateTime.Compare(time_sc, time_now) > 0)
{
Alert.Show("生产日期不能大于当前日期!", "消息提示", MessageBoxIcon.Warning);
return;
}
if (DateTime.Compare(time_now, time_yx) > 0)
{
Alert.Show("有效日期不能小于当前日期!", "消息提示", MessageBoxIcon.Warning);
return;
}
if (!DbHelperOra.Exists(string.Format("select 1 from DOC_GOODS where GDSEQ='{0}' OR GDNAME ='{0}' ", hfdGDSEQ.Text.Trim())))
{
Alert.Show(string.Format("您输入的商品【{0}】在商品资料中不存在，请重新输入！", "消息提示", tbxGDNAME.Text), MessageBoxIcon.Warning);
return;
}
//验证批号是否已经存在
if (DbHelperOra.Exists(string.Format("select 1 from DAT_GOODSSTOCK where GDSEQ=(select gdseq from doc_goods where GDSEQ='{0}' OR GDNAME ='{0}') and PHID = '{1}'", hfdGDSEQ.Text.Trim(), tbsPH.Text)))
{
Alert.Show("您输入的商品批号已存在,请检查!");
return;
}
MyTable myLot = new MyTable("DOC_GOODSPH");
myLot.ColRow = PubFunc.FormDataHT(FormLot);
myLot.ColRow.Add("PHID", tbsPH.Text);
myLot.ColRow.Remove("GDNAME");
myLot.InsertExec();
Alert.Show("批号信息保存成功！");
DataSearch();
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
PubFunc.FormLock(FormDoc, true, "");
tbxMEMO.Enabled = true;
//参数说明：cx-查询内容，bm-商品配置部门,su-供应商
string url = "~/ERPQuery/ContantWindow_His.aspx?bm=" + docDEPTID.SelectedValue + "&cx=&su=Y";
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "高值商品信息"));
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
PubFunc.FormLock(FormDoc, true, "");
tbxBARCODE.Enabled = false;
//参数说明：cx-查询内容，bm-商品配置部门,su-供应商
string url = "~/ERPQuery/GoodsWindow_New.aspx?Deptout=" + docDEPTID.Text + "&goodsType=1";
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "商品信息查询"));
}
protected override void billAddRow()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非『新增』单据不能增行！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
billLockDoc(true);
PubFunc.GridRowAdd(GridGoods, "INIT");
}
protected void btnExtraction_Click(object sender, EventArgs e)
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
// string strSql = @"SELECT A.SEQNO,A.BILLNO,B.NAME FLAG_CN,A.FLAG,A.XSRQ,F_GETDEPTNAME(A.DEPTOUT) DEPTOUT,A.SUBNUM,F_GETUSERNAME(A.SLR) SLR
// FROM DAT_CK_DOC A, SYS_CODEVALUE B
// WHERE A.FLAG = B.CODE AND A.FLAG = 'Y' AND B.TYPE ='DIC_BILLSTATUS' AND A.BILLTYPE='LCD' AND A.XSTYPE='1' AND A.DEPTID='{0}' ";
// GridBill.DataSource = DbHelperOra.Query(string.Format(strSql, docDEPTID.SelectedValue)).Tables[0];
// GridBill.DataBind();
DataSearch();
WindowBill.Hidden = false;
}
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, "商品信息查询"));
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (PubFunc.FormDataCheck(FormDosage).Length > 0)
{
return;
}
int out_i = 0;
if (!int.TryParse(tbxCode.Text, out out_i))
{
Alert.Show("请输入正确的药效编码!");
return;
}
if (out_i < 1)
{
Alert.Show("请输入正确的药效编码!");
return;
}
MyTable mtType = new MyTable("DOC_GOODSJX");
mtType.ColRow = PubFunc.FormDataHT(FormDosage);
if (hfdIsNew.Text == "Y")
{
if (DbHelperOra.Exists(string.Format("select 1 from DOC_GOODSJX where code='{0}'", tbxCode.Text)))
{
Alert.Show(string.Format("您输入的剂型编码【{0}】已存在，请重新输入！", tbxCode.Text), MessageBoxIcon.Warning);
return;
}
mtType.InsertExec();
}
else
{
if (ckbFlag.Checked)
{
DbHelperOra.ExecuteSql("UPDATE DOC_GOODSJX SET flag='Y',name='" + tbxName.Text.Trim() + "' WHERE CODE='" + tbxCode.Text + "'");
}
else
{
DbHelperOra.ExecuteSql("UPDATE DOC_GOODSJX SET flag='N',name='" + tbxName.Text.Trim() + "' WHERE CODE='" + tbxCode.Text + "'");
}
}
OperLog("剂型资料", "修改剂型【" + tbxName.Text.Trim() + "】");
Alert.Show("数据保存成功！");
GetDosage();
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
if (string.IsNullOrWhiteSpace(docSTR1.Text))
{
Alert.Show("【预入库单号】为空，请输入！");
return;
}
docDEPTID.Enabled = false;
docXSRQ.Enabled = false;
docBILLNO.Enabled = false;
docSTR1.Enabled = false;
WindowGoods.Hidden = false;
DataSearch();
}
protected override void billGoods()
{
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
billLockDoc(true);
tbxMEMO.Enabled = true;
//绑定库存,区分代管和非代管的供应商
string strSql = "";
strSql = @"SELECT A.*,B.GDNAME,b.PIZNO PZWH,F_GETUNITNAME(A.UNIT) UNITNAME,0 SL FROM DAT_GOODSSTOCK A, DOC_GOODS B
WHERE A.GDSEQ = B.GDSEQ AND A.KCSL >0 AND A.DEPTID = '" + ddlDEPTID.SelectedValue + "' ORDER BY PH DESC";
GridLot.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridLot.DataBind();
WindowLot.Hidden = false;
}
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 billGoods()
{
if (docFLAG.SelectedValue != "M" && docFLAG.SelectedValue != "R")
{
Alert.Show("非新单不能增加商品");
return;
}
if (docBILLNO.Text.Length > 0 && docBILLNO.Text.StartsWith("TRI"))
{
Alert.Show("下传单据不能追加商品！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (PubFunc.FormDataCheck(FormDoc).Length > 1)
{
return;
}
string url = "~/ERPQuery/GoodsWindow_New.aspx?DeptIn=" + docDEPTID.SelectedValue;
PageContext.RegisterStartupScript(Window1.GetSaveStateReference(hfdValue.ClientID) + Window1.GetShowReference(url, "商品信息查询"));
}
protected void btnCatIDSubmit_Click(object sender, EventArgs e)
{
if (PubFunc.FormDataCheck(Form2).Length > 0)
{
return;
}
string strSqls = string.Format(@"UPDATE INF_DOC_GOODS_HIS SET CATID = '{0}', CATID0 = '{1}', HSJJ = '{2}' WHERE FLAG = 'N' AND GDSEQ = '{3}'", winCATID.SelectedValue, winCATID0.SelectedValue, winHSJJ.Text, hfdGDSEQ.Text);
if (DbHelperOra.ExecuteSql(strSqls) > 0)
{
WindowCatID.Hidden = true;
Alert.Show("商品信息调整成功！");
dataSearch();
OperLog("商品状态维护", "下传商品编码【" + hfdGDSEQ + "】的商品分类由【" + hfdCATID.Text + "】修改为【" + winCATID.SelectedValue + "】,商品种类由【" + hfdCATID0.Text + "】修改为【" + winCATID0.SelectedValue + "】,商品进价由【" + hfdHSJJ.Text + "】修改为【" + winHSJJ.Text + "】");
}
else
{
Alert.Show("非下传商品无法调整商品信息！");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (PubFunc.FormDataCheck(FormMx).Length > 0)
{
return;
}
//判断此类别是否存在
if ((DbHelperOra.Exists("select 1 from SYS_CATEGORY where code = '" + tbxCode.Text + "'")) && (tbxCode.Enabled))
{
Alert.Show("此商品类别编码已经存在,请检查!");
return;
}
string ls_codelabel;
MyTable mtTable = new MyTable(strTable, "CODE");
mtTable.ColRow = PubFunc.FormDataHT(FormMx);
ls_codelabel = PubFunc.FormLabelGet(FormMx, "CODE");
if (PubFunc.StrIsEmpty(mtTable.ColRow["CODE"].ToString()))
{
Alert.Show("【" + ls_codelabel + "】不能为空！");
return;
}
else if (mtTable.ColRow["CODE"].ToString().Length != CodeLen(tbxCLASS.Text))
{
Alert.Show("【" + ls_codelabel + "】长度应该为【" + CodeLen(tbxCLASS.Text).ToString() + "】，请修改！");
return;
}
if (tbxCode.Enabled) //新增
{
mtTable.InsertExec();
}
else
{
mtTable.UpdateExec("");
}
Alert.Show("数据保存成功！");
tbxCode.Enabled = false;
InitTree();
}
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 void btnRejectSubmit_Click(object sender, EventArgs e)
{
if (ddlReject.SelectedText == "--请选择--")
{
Alert.Show("请选择驳回原因");
return;
}
if (!string.IsNullOrWhiteSpace(txaMemo.Text) && txaMemo.Text.Length > 40)
{
Alert.Show("【驳回原因】字符超长");
return;
}
PubFunc.FormDataCheck(Form2);
//增加待办事宜
List <CommandInfo> cmdList = new List <CommandInfo>();
string strMemo = docMEMO.Text + "；驳回原因：" + ddlReject.SelectedText;
if (!string.IsNullOrWhiteSpace(txaMemo.Text.Trim()))
{
strMemo += "；详细说明：" + txaMemo.Text;
}
//cmdList.Add(new CommandInfo(string.Format("update DAT_SL_DOC set flag='R',memo='{0}',SHR={1}，SHRQ=SYSDATE where seqno='{2}' and flag='N'", strMemo, "'" + UserAction.UserID + "'", docBILLNO.Text), null));
cmdList.Add(new CommandInfo(string.Format("update DAT_DDPLAN_DOC SET FLAG='R',MEMO='{0}',SHR={1},SHRQ=SYSDATE WHERE SEQNO='{2}' AND BILLTYPE='CJD' AND FLAG='N'", strMemo, "'" + UserAction.UserID + "'", docBILLNO.Text), null));
if (DbHelperOra.ExecuteSqlTran(cmdList))
{
WindowReject.Hidden = true;
billOpen(docBILLNO.Text);
Alert.Show("驳回成功");
btnAudit.Enabled = false;
txaMemo.Text = "";
}
}
private void save(string flag = "N")
{
#region 数据有效性验证
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非新单不能保存！", "消息提示", MessageBoxIcon.Warning);
return;
}
List <Dictionary <string, object> > newDict = GridGoods.GetNewAddedList().ToList();
if (newDict.Count == 0)
{
Alert.Show("请输入商品信息", "消息提示", MessageBoxIcon.Warning);
return;
}
if (PubFunc.FormDataCheck(FormDoc).Length > 0)
{
return;
}
decimal subsum = 0;
List <Dictionary <string, object> > goodsData = new List <Dictionary <string, object> >();
//判断是否有空行、批号填写是否符合要求
for (int i = 0; i < newDict.Count; i++)
{
if (!string.IsNullOrWhiteSpace(newDict[i]["GDSEQ"].ToString()) && !string.IsNullOrWhiteSpace(newDict[i]["GDNAME"].ToString()))
{
//if (newDict[i]["ISLOT"].ToString() == "1" || newDict[i]["ISLOT"].ToString() == "2")
//{
// if (string.IsNullOrWhiteSpace(newDict[i]["PH"].ToString()) || newDict[i]["PH"].ToString() == "\\")
// {
// //GridGoods.SelectedCell = new int[] { i, 8 };
// string[] selectedCell = GridGoods.SelectedCell;
// PageContext.RegisterStartupScript(String.Format("F('{0}').selectCell('{1}','{2}');", GridGoods.ClientID, selectedCell[0], "KCSL"));
// Alert.Show("商品【" + newDict[i]["GDNAME"].ToString() + "】批号不能为空！！！", "消息提示", MessageBoxIcon.Warning);
// return;
// }
//}
//if (newDict[i].ContainsKey("STR1")&&goodsData.Count > 0 && goodsData.Where(x => x["STR1"].ToString() == newDict[i]["STR1"].ToString()).Count() > 0)
//{
// Alert.Show("条码[" + newDict[i]["STR1"] + "]扫描重复!", "消息提示", MessageBoxIcon.Warning);
// return;
if (!string.IsNullOrWhiteSpace(newDict[i]["STR1"].ToString()))
{
for (int k = 1 + i; k < newDict.Count; k++)
{
if ((newDict[i]["STR1"].ToString()) == (newDict[k]["STR1"].ToString()))
{
Alert.Show("商品『" + newDict[k]["GDNAME"].ToString() + "』条码『" + newDict[k]["STR1"].ToString() + "』重复，请维护！", "消息提示", MessageBoxIcon.Warning);
return;
}
}
}
if (newDict[i]["BZSL"].ToString() == "0" || string.IsNullOrWhiteSpace(newDict[i]["BZSL"].ToString()))
{
Alert.Show("商品【" + newDict[i]["GDNAME"].ToString() + "】使用数填写不正确！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (decimal.Parse(newDict[i]["KCSL"].ToString()) < decimal.Parse(newDict[i]["BZSL"].ToString()))
{
Alert.Show("商品【" + newDict[i]["GDNAME"].ToString() + "】使用数大于库存数，请重新输入！", "消息提示", MessageBoxIcon.Warning);
return;
}
//当商品中含有贵重商品信息，即需要赋唯一码时
if (newDict[i]["ISGZ"].ToString() == "Y" && newDict[i]["ONECODE"].ToString() == "")
{
Alert.Show("商品【" + newDict[i]["GDNAME"].ToString() + "】为贵重商品，请先进行扫描赋码！", "消息提示", MessageBoxIcon.Warning);
return;
}
goodsData.Add(newDict[i]);
subsum += Convert.ToDecimal(newDict[i]["HSJJ"].ToString()) * Convert.ToDecimal(newDict[i]["BZHL"].ToString());
}
}
if (goodsData.Count == 0)//所有Gird行都为空行时
{
Alert.Show("商品信息不能为空", "消息提示", MessageBoxIcon.Warning);
return;
}
//验证单据信息
if (DbHelperOra.Exists("SELECT 1 FROM DAT_XS_DOC where seqno = '" + docBILLNO.Text + "'") && docBILLNO.Enabled)
{
Alert.Show("您输入的单号已存在,请检查!");
return;
}
#endregion
if (PubFunc.StrIsEmpty(docBILLNO.Text))
{
docSEQNO.Text = BillSeqGet();
docBILLNO.Text = docSEQNO.Text;
docBILLNO.Enabled = false;
}
else
{
string flg = (string)DbHelperOra.GetSingle(string.Format("SELECT NVL(FLAG,'N') FROM DAT_XS_DOC WHERE SEQNO='{0}'", docBILLNO.Text));
if (!string.IsNullOrWhiteSpace(flg) && (",N,R").IndexOf(flg) < 0)
{
Alert.Show("您输入的单据号存在重复信息，请重新输入或置空！", "消息提示", MessageBoxIcon.Warning);
return;
}
else
{
docSEQNO.Text = docBILLNO.Text;
docBILLNO.Enabled = false;
}
}
MyTable mtType = new MyTable("DAT_XS_DOC");
mtType.ColRow = PubFunc.FormDataHT(FormDoc);
mtType.ColRow["SEQNO"] = docBILLNO.Text;
mtType.ColRow.Add("BILLTYPE", BillType);
mtType.ColRow.Add("SUBNUM", goodsData.Count);
mtType.ColRow.Add("XSTYPE", "1");
List <CommandInfo> cmdList = new List <CommandInfo>();
MyTable mtTypeMx = new MyTable("DAT_XS_COM");
//先删除单据信息在插入
cmdList.Add(new CommandInfo("delete DAT_XS_DOC where seqno='" + docBILLNO.Text + "'", null)); //删除单据台头
cmdList.Add(new CommandInfo("delete DAT_XS_COM where seqno='" + docBILLNO.Text + "'", null)); //删除单据明细
decimal subNum = 0;
for (int i = 0; i < goodsData.Count; i++)
{
mtTypeMx.ColRow = PubFunc.GridDataGet(goodsData[i]);
if (PubFunc.StrIsEmpty(mtTypeMx.ColRow["BZSL"].ToString()) || mtTypeMx.ColRow["BZSL"].ToString() == "0")
{
Alert.Show("商品【" + mtTypeMx.ColRow["GDSEQ"] + " | " + mtTypeMx.ColRow["GDNAME"] + "】【使用数】为0或空，无法进行【使用信息管理】操作。");
return;
}
mtTypeMx.ColRow.Add("SEQNO", docBILLNO.Text);
mtTypeMx.ColRow["ROWNO"] = i + 1;
mtTypeMx.ColRow.Add("PHID", mtTypeMx.ColRow["PH"]);
mtTypeMx.ColRow["DHSL"] = decimal.Parse(mtTypeMx.ColRow["BZHL"].ToString()) * decimal.Parse(mtTypeMx.ColRow["BZSL"].ToString());
mtTypeMx.ColRow["HSJE"] = decimal.Parse(mtTypeMx.ColRow["HSJJ"].ToString()) * decimal.Parse(mtTypeMx.ColRow["BZSL"].ToString()) * decimal.Parse(mtTypeMx.ColRow["BZHL"].ToString());
//mtTypeMx.ColRow["XSSL"] = goodsData[i]["DHSL"].ToString();
mtTypeMx.ColRow["XSSL"] = mtTypeMx.ColRow["DHSL"];
mtTypeMx.ColRow.Add("BHSJJ", 0);
mtTypeMx.ColRow.Add("BHSJE", 0);
mtTypeMx.ColRow.Remove("UNITNAME");
mtTypeMx.ColRow.Remove("PRODUCERNAME");
subNum = subNum + decimal.Parse(mtTypeMx.ColRow["HSJE"].ToString());
cmdList.Add(mtTypeMx.Insert());
}
mtType.ColRow.Add("SUBSUM", subNum);
cmdList.AddRange(mtType.InsertCommand());
if (DbHelperOra.ExecuteSqlTran(cmdList))
{
if (flag == "N")
{
Alert.Show("商品使用信息保存成功！");
}
OperLog("使用管理", "修改单据【" + docBILLNO.Text + "】");
billOpen(docBILLNO.Text);
}
SaveSuccess = true;
}