protected void btnNew_Click(object sender, EventArgs e)
{
PubFunc.FormDataClear(FormMain);
PubFunc.FormDataClear(FormAssist);
hfdIsNew.Text = "Y";
hfdConfig.Text = "";
dpkINRQ.SelectedDate = DateTime.Now;
ddlFLAG.SelectedValue = "N";
tbxBZHL.Text = "1";
//ddlCATID.SelectedValue = "BG";
//ddlCATID0.SelectedValue = "5";
ddlUNIT_ORDER.SelectedValue = "X";
ddlUNIT_SELL.SelectedValue = "X";
btn_state(true);
//清空部门配置信息
GridDept.DataSource = null;
GridDept.DataBind();
//新增状态商品不允许配置科室 王阿磊2015年8月26日 22:29:52
if (ddlFLAG.SelectedText == "新增")
{
GridDept.Enabled = false;
}
else
{
GridDept.Enabled = true;
}
}
private void FillGrid()
{
StrSql = new StringBuilder();
StrSql.Length = 0;
StrSql.AppendLine("Select Id,DeptName From Dept_Mast Order By DeptName");
dtTemp = new DataTable();
dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString());
GridDept.DataSource = dtTemp;
GridDept.DataBind();
}
private void DataInit()
{
PubFunc.DdlDataGet(ddlGoodsType, "DDL_GOODS_TYPE");
DataTable dtDept = DbHelperOra.Query("select CODE,NAME from SYS_DEPT WHERE FLAG='Y' and ISDELETE='N'").Tables[0];
if (dtDept.Rows.Count > 0)
{
GridDept.DataSource = dtDept;
GridDept.DataBind();
}
}
protected void GridDept_RowCommand(object sender, GridCommandEventArgs e)
{
int columnIndex = e.ColumnIndex;
if (e.CommandName == "Store")
{
columnIndex = columnIndex - 1;
}
FineUIPro.CheckBoxField checkField1 = (FineUIPro.CheckBoxField)GridDept.FindColumn(columnIndex);
FineUIPro.CheckBoxField checkField2 = (FineUIPro.CheckBoxField)GridDept.FindColumn(columnIndex + 1);
string IsCFG = checkField1.GetCheckedState(e.RowIndex) ? "1" : "0";
string SPLB = checkField2.GetCheckedState(e.RowIndex) ? "1" : "0";
GridDept.Rows[e.RowIndex].Values[4] = IsCFG + "/" + SPLB;
}
protected void GridGoods_Sort(object sender, GridSortEventArgs e)
{
if (e.SortField == "FLAG")
{
for (int rowIndex = 0; rowIndex < GridDept.Rows.Count; rowIndex++)
{
FineUIPro.CheckBoxField cbxEnable = GridDept.FindColumn("cbxEnable") as FineUIPro.CheckBoxField;
cbxEnable.SetCheckedState(rowIndex, FLAG);
FineUIPro.CheckBoxField checkField1 = (FineUIPro.CheckBoxField)GridDept.FindColumn("cbxEnable");
FineUIPro.CheckBoxField checkField2 = (FineUIPro.CheckBoxField)GridDept.FindColumn("cbxStore");
string IsCFG = checkField1.GetCheckedState(rowIndex) ? "1" : "0";
string SPLB = checkField2.GetCheckedState(rowIndex) ? "1" : "0";
GridDept.Rows[rowIndex].Values[4] = IsCFG + "/" + SPLB;
}
FLAG = !FLAG;
}
}
private void search_dept()
{
//预算信息
String Sql = @"SELECT SA.*,NVL(SB.YSJE,0) YSJE FROM
(SELECT B.CODE,B.NAME,ABS(SUM(NVL(A.HSJE,0))) SYJE
FROM VIEW_JS A,SYS_DEPT B
WHERE TO_CHAR(A.RQSJ,'YYYY-MM') = TO_CHAR(SYSDATE,'YYYY-MM')
AND A.DEPTID(+) = B.CODE AND B.TYPE IN('3','4')
GROUP BY B.CODE,B.NAME) SA,
(SELECT DEPTID,SUM(SUBSUM) YSJE
FROM DAT_YS_DOC
WHERE FLAG = 'Y' AND SYSDATE BETWEEN BEGRQ AND ENDRQ + 1
GROUP BY DEPTID) SB
WHERE SA.CODE = SB.DEPTID(+)";
DataTable Dt = DbHelperOra.Query(Sql).Tables[0];
GridDept.DataSource = Dt;
GridDept.DataBind();
}
protected void GridDept_Selected(object sender, EventArgs e)
{
//if (TabStripMain.ActiveTabIndex != 2) return;
string seq = tbxGDID.Text;
if (PubFunc.StrIsEmpty(seq) || GridDept.Rows.Count > 0)
{
return;
}
//string strSql = @"SELECT B.CODE CODE,B.NAME NAME,nvl(A.FLAG,0)||'/'||nvl(Store,0) OLD,
// nvl(A.FLAG,0) FLAG,nvl(Store,0) Store,nvl(A.FLAG,0)||'/'||nvl(Store,0) NEW
// FROM (select deptid,TO_NUMBER(DECODE(ISCFG,'Y','1','1','1','0')) FLAG,TO_NUMBER(DECODE(SPLB,'Y','1','1','1','0')) Store FROM DOC_GOODSCFG where gdseq='{0}') A,
// SYS_DEPT B
// WHERE B.CODE =A.DEPTID(+) ";//B.ISLAST='Y' AND
string strSql = @"SELECT A.CODE,NVL(B.ISCFG,'N') FLAG,A.NAME
FROM SYS_DEPT A ,(SELECT DEPTID,ISCFG FROM DOC_GOODSCFG WHERE GDSEQ = '{0}') B
WHERE A.CODE = B.DEPTID(+) ORDER BY NVL(B.ISCFG,'N') DESC";
DataTable dtCFG = DbHelperOra.Query(string.Format(strSql, seq)).Tables[0];
GridDept.DataSource = dtCFG;
GridDept.DataBind();
List <int> selectRow = new List <int>();
for (int i = 0; i < dtCFG.Rows.Count; i++)
{
if (dtCFG.Rows[i]["FLAG"].ToString() != "N")
{
selectRow.Add(i);
}
}
GridDept.SelectedRowIndexArray = selectRow.ToArray();
//新增状态商品不允许配置科室 王阿磊2015年8月26日 22:29:52
if (ddlFLAG.SelectedText == "新增")
{
GridDept.Enabled = false;
}
else
{
GridDept.Enabled = true;
}
}
protected void GridGoods_RowDoubleClick(object sender, GridRowClickEventArgs e)
{
TabStripMain.ActiveTabIndex = 0;
string seq = GridGoods.Rows[e.RowIndex].Values[1].ToString();
DataTable dt = DbHelperOra.Query("select * from doc_goods where gdseq='" + seq.Trim() + "'").Tables[0];
PubFunc.FormDataSet(FormMain, dt.Rows[0]);
PubFunc.FormDataSet(FormAssist, dt.Rows[0]);
GridDept.DataSource = null; //清除商品科室配置
GridDept.DataBind();
GridDept_Selected(null, null); //双击即绑定GridDept数据，而不是在点开标签页绑定
hfdIsNew.Text = "N";
hfdConfig.Text = "";
ddlISFLAG7.Enabled = false;
if (string.IsNullOrWhiteSpace(ddlISFLAG7.SelectedValue) || ddlISFLAG7.SelectedValue == "Y")
{
if (!string.IsNullOrWhiteSpace(ddlFLAG.SelectedValue) && ddlFLAG.SelectedValue != "N")
{
tbsGDNAME.Enabled = false;
nbbBARCODE.Enabled = false;
ddlUNIT.Enabled = false;
}
else
{
tbsGDNAME.Enabled = true;
nbbBARCODE.Enabled = true;
ddlUNIT.Enabled = true;
}
tbxGDID.Enabled = false;
ddlCATID.Enabled = false;
ddlUNIT_DABZ.Enabled = true;
nbbBARCODE_DABZ.Enabled = true;
ddlUNIT_ZHONGBZ.Enabled = true;
nbbNUM_ZHONGBZ.Enabled = true;
nbbBARCODE_ZHONGBZ.Enabled = true;
nbbNUM_DABZ.Enabled = true;
ddlCATID.Enabled = true;
//新增状态商品不允许配置科室 王阿磊2015年8月26日 22:29:52
if (ddlFLAG.SelectedText == "新增")
{
GridDept.Enabled = false;
}
else
{
GridDept.Enabled = true;
}
}
else
{
btn_state(false);
nbbHSJJ.Enabled = true;
ddlUNIT_DABZ.Enabled = true;
nbbBARCODE_DABZ.Enabled = true;
ddlUNIT_ZHONGBZ.Enabled = true;
nbbNUM_ZHONGBZ.Enabled = true;
nbbBARCODE_ZHONGBZ.Enabled = true;
nbbNUM_DABZ.Enabled = true;
ddlCATID.Enabled = true;
}
}
