//导出付款记录 protected void btn_Export_Click(object sender, EventArgs e) { string sqltext = "SELECT HTBH,PJNAME,ENGNAME,SKDW,QKJE,QKRQ,ZFJE,ZCRQ,QKYT,QKBM,QKR," + " CASE HTLB WHEN '0' THEN '销售' WHEN '1' THEN '委外' WHEN '3' THEN '采购' WHEN '4' THEN '办公' ELSE '其他' END AS HTLB," + " CASE PZ WHEN 1 THEN '有' WHEN 0 THEN '无' END AS PZ FROM CheckRequset WHERE" + ViewState["sqltext"].ToString(); DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count > 0) { ContractClass.ExportFKDataItem(dt); } else { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('没有可以导出的数据,请重新筛选');", true); } }
//按钮事件 //1查看请款,2编辑请款,3删除请款,4打印请款,5查看合同,6添加非合同请款 private void Action_Click(int clicktype) { //找到选定行的参数 string htbh = ""; string qkdh = ""; string qkr = ""; string qkzt = ""; string htlx = ""; bool check = false;; for (int i = 0; i < grvQKD.Rows.Count; i++) { CheckBox cbx = (CheckBox)grvQKD.Rows[i].FindControl("CheckBox1"); Label lbl_htbh = (Label)grvQKD.Rows[i].FindControl("lbl_htbh"); //合同编号 Label lbl_qkdh = (Label)grvQKD.Rows[i].FindControl("lbl_qkdh"); //请款单号 Label lbl_qkr = (Label)grvQKD.Rows[i].FindControl("lbl_qkr"); //请款人 Label lbl_qkzt = (Label)grvQKD.Rows[i].FindControl("lbl_qkzt"); //请款状态 Label lbl_htlx = (Label)grvQKD.Rows[i].FindControl("lbl_htlx"); //合同类型 if (cbx.Checked == true) { htbh = lbl_htbh.Text.Trim(); qkdh = lbl_qkdh.Text.Trim(); qkr = lbl_qkr.Text.Trim(); qkzt = lbl_qkzt.Text.Trim(); htlx = lbl_htlx.Text.Trim(); check = true; break; } } //判断是否选择了数据行 if (!check && clicktype != 6 && clicktype != 7)//没有选择行,且不是添加非合同请款,导出操作 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('请选择要操作的数据行!');", true); return; } else { switch (clicktype) { case 1: //查看请款 if (htbh == "" || htbh == null) //非合同请款 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "FHTQK('" + qkdh + "','View');", true); } else //合同请款 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "HTQK('" + qkdh + "','View','" + htlx + "');", true); } break; case 2: //编辑请款 if (CheckPower(qkr, qkzt, 2)) { if (htbh == "" || htbh == null) //非合同请款,这里的编辑,不能进行付款操作,如要付款,需要到待办款项处 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "FHTQK('" + qkdh + "','Edit');", true); } else //合同请款 { //当前登录人为财务时更改action值 if (Session["UserDeptID"].ToString() == "06") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "HTQK('" + qkdh + "','EditCW','" + htlx + "');", true); } else if (Session["UserName"].ToString() == qkr) { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "HTQK('" + qkdh + "','Edit','" + htlx + "');", true); } } } break; case 3: //删除请款 if (CheckPower(qkr, qkzt, 3)) { List <string> sqlstr = new List <string>(); string sqltext = ""; if (htbh == "" || htbh == null) //没有合同号即为非合同请款 { sqltext = "delete from TBPM_FHT_CheckRequest where CR_QKDH='" + qkdh + "'"; } else { sqltext = "delete from TBPM_CHECKREQUEST where CR_ID='" + qkdh + "'"; } sqlstr.Add(sqltext); DBCallCommon.ExecuteTrans(sqlstr); Response.Redirect("CM_CHECKREQUEST_QUERY.aspx"); } break; case 4: //打印请款 if (htbh == "" || htbh == null) //非合同请款 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('非合同请款不能打印');", true); } else //合同请款 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "PrintQK('" + qkdh + "');", true); } break; case 5: //查看合同 if (htbh == "" || htbh == null) //非合同请款 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('您选择的是非合同请款\\r没有相关合同信息!');", true); } else //合同请款 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "ViewHT('" + htbh + "','" + htlx + "');", true); } break; case 6: //添加非合同请款 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "Add_FHTQK();", true); break; case 7: string sqlExport = "SELECT HTBH,SUBSTRING (QKDH,CHARINDEX('-',QKDH)+1,LEN(QKDH)-CHARINDEX('-',QKDH)) AS QKQC," + " PJNAME,QKJE,QKRQ,YZF,QKBM,QKR," + " CASE QKZT WHEN 0 THEN '保存' WHEN 1 THEN '正在签字' WHEN 2 THEN '提交财务-未付款' WHEN 3 THEN '部分支付' WHEN 4 THEN '已支付' END AS QKZT," + " QKYT,SKDW FROM View_ALL_CheckRequest" + " WHERE " + ViewState["sqltext"].ToString(); DataTable dtExport = DBCallCommon.GetDTUsingSqlText(sqlExport); if (dtExport.Rows.Count > 0) { ContractClass.ExportQKDataItem(dtExport); } else { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('没有可以导出的数据,请重新筛选!');", true); return; } break; } } }
//按钮事件 //1查看合同,2编辑合同,3删除合同,4添加请款,5添加合同,6导出合同 private void Action_Click(int clicktype) { //找到选定行的参数 string htbh = ""; string fzr = ""; string htlx = ""; bool check = false;; for (int i = 0; i < GRV_CON.Rows.Count; i++) { CheckBox cbx = (CheckBox)GRV_CON.Rows[i].FindControl("CheckBox1"); Label lbl_htbh = (Label)GRV_CON.Rows[i].FindControl("lbl_htbh"); //合同编号 Label lbl_fzr = (Label)GRV_CON.Rows[i].FindControl("lbl_fzr"); //负责人 Label lbl_htlx = (Label)GRV_CON.Rows[i].FindControl("lbl_htlx"); //合同类型 if (cbx.Checked == true) { htbh = lbl_htbh.Text.Trim(); fzr = lbl_fzr.Text.Trim(); htlx = lbl_htlx.Text.Trim(); check = true; break; } } //判断是否选择了数据行 if (!check && clicktype != 5 && clicktype != 6)//没有选择行,且不是添加合同操作 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('请勾选要操作的数据行!');", true); return; } else { switch (clicktype) { case 1: //查看合同 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "ViewHT('" + htbh + "','" + htlx + "');", true); break; case 2: //编辑合同 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "EditHT('" + htbh + "','" + htlx + "');", true); break; case 3: //删除合同 if (CheckPower(fzr, htbh)) { //还没有付款的,如果要删除,则同时删除该合同下的: //合同评审主表、合同评审意见表、合同登记表、请款、发票登记、索赔、附件信息及附件 //附件包括:合同附件和索赔附件 List <string> sqlstr = new List <string>(); string sql_Del_Info = "delete from TBCR_CONTRACTREVIEW where CR_ID=(" + //删除合同评审主表信息 "select PCON_REVID from TBPM_CONPCHSINFO where PCON_BCODE='" + htbh + "')"; string sql_Del_Rev = "delete from TBCR_CONTRACTREVIEW_DETAIL where CRD_ID=(" + //删除合同评审意见表信息 "select PCON_REVID from TBPM_CONPCHSINFO where PCON_BCODE='" + htbh + "')"; string sql_Del_ConInfo = "delete from TBPM_CONPCHSINFO where PCON_BCODE='" + htbh + "'"; //删除合同登记信息 string sql_Del_YK = "delete from TBPM_CHECKREQUEST where CR_HTBH='" + htbh + "'"; //删除请款记录 string sql_Del_FP = "delete from TBPM_GATHINVDOC where GIV_HTBH='" + htbh + "'"; //删除发票记录 string sql_Del_SP = "delete from TBPM_SUBCLAIM where SPS_HTBH='" + htbh + "'"; //删除索赔记录 string sql_Del_Conno = "delete from TBCM_TEMPCONNO where CON_NO='" + htbh + "' and USER_NAME='" + Session["UserName"].ToString() + "'"; //删除已锁定的合同号 //删除附件及附件信息 Contract_Data.ContractClass.Del_ConAttachment(htbh); Contract_Data.ContractClass.Del_SPAttachment(htbh); sqlstr.Add(sql_Del_Info); sqlstr.Add(sql_Del_Rev); sqlstr.Add(sql_Del_ConInfo); sqlstr.Add(sql_Del_YK); sqlstr.Add(sql_Del_FP); sqlstr.Add(sql_Del_SP); sqlstr.Add(sql_Del_Conno); DBCallCommon.ExecuteTrans(sqlstr); Response.Redirect("CM_Contract_CG.aspx?ContractForm=2"); } break; case 4: //添加请款 string sql = "select CR_PSZT from TBPM_CONPCHSINFO left join TBCR_CONTRACTREVIEW on TBPM_CONPCHSINFO.PCON_REVID=TBCR_CONTRACTREVIEW.CR_ID where PCON_BCODE='" + htbh + "'"; System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); if (Convert.ToString(dt.Rows[0]["CR_PSZT"]) == "2") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "Add_QK('" + htbh + "','" + htlx + "');", true); } else { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('合同还未审批通过,无法添加请款!');", true); return; } break; case 5: //添加合同 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "Add_HT('" + ViewState["contractForm"].ToString() + "');", true); break; case 6: //导出合同 string sqlexport = "SELECT * FROM View_CM_ExportHTToExcel WHERE " + ViewState["sqlText"].ToString() + " ORDER BY PCON_BCODE"; System.Data.DataTable dt_export = DBCallCommon.GetDTUsingSqlText(sqlexport); if (dt_export.Rows.Count > 0) { ContractClass.ExportDataItem(dt_export); } else { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('没有可以导出的数据!');", true); return; } break; } } }
//按钮点击事件 private void Action_Click(int clicktype) { string qkdh = ""; string qkr = ""; string qkzt = ""; string ddcode = ""; string bill = ""; bool check = false;; for (int i = 0; i < grvQKD.Rows.Count; i++) { CheckBox cbx = (CheckBox)grvQKD.Rows[i].FindControl("CheckBox1"); Label lbl_qkdh = (Label)grvQKD.Rows[i].FindControl("lbl_qkdh"); //请款单号 Label lbl_qkr = (Label)grvQKD.Rows[i].FindControl("lbl_qkr"); //请款人 Label lbl_qkzt = (Label)grvQKD.Rows[i].FindControl("lbl_qkzt"); //请款状态 Label lbl_ddcode = (Label)grvQKD.Rows[i].FindControl("lbl_ddcode"); Label lbl_bill = (Label)grvQKD.Rows[i].FindControl("lbl_bill"); if (cbx.Checked == true) { qkdh = lbl_qkdh.Text.Trim(); qkr = lbl_qkr.Text.Trim(); qkzt = lbl_qkzt.Text.Trim(); ddcode = lbl_ddcode.Text.Trim(); bill = lbl_bill.Text.Trim(); check = true; break; } } //判断是否选择了数据行 if (!check && clicktype != 5)//没有选择行,且不是导出操作 { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('请选择要操作的数据行!');", true); return; } else { switch (clicktype) { case 1: //查看请款 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "ViewQK('" + qkdh + "','View');", true); break; case 2: //编辑请款 if (CheckPower(qkr, qkzt, 2)) { if (Session["UserDeptID"].ToString() == "08") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "ViewQK('" + qkdh + "','EditCW');", true); } else if (Session["UserName"].ToString() == qkr) { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "ViewQK('" + qkdh + "','Edit');", true); } } break; case 3: //删除请款 if (CheckPower(qkr, qkzt, 3)) { List <string> sqlstr = new List <string>(); string sqltext = ""; sqltext = "delete from TBPM_ORDER_CHECKREQUEST where DQ_ID='" + qkdh + "'"; sqlstr.Add(sqltext); DBCallCommon.ExecuteTrans(sqlstr); Response.Redirect("CR_NotContractOrder_Query.aspx"); } break; case 4: //查看订单 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "View_PurOrder('" + ddcode + "');", true); break; case 5: //导出 string sqlExport = "select DQ_ID,DQ_DDCODE,DQ_DDZJE,DQ_DATA,DQ_BMNAME,DQ_QKR," + " CASE DQ_STATE WHEN 0 THEN '保存' WHEN 1 THEN '正在签字' WHEN 2 THEN '提交财务-未付款' WHEN 3 THEN '已支付' END AS DQ_STATE," + "DQ_USE,DQ_CSNAME,DQ_CSBank,DQ_CSACCOUNT from TBPM_ORDER_CHECKREQUEST" + " WHERE " + ViewState["sqltext"].ToString(); DataTable dtExport = DBCallCommon.GetDTUsingSqlText(sqlExport); if (dtExport.Rows.Count > 0) { ContractClass.ExportDDQKDataItem(dtExport); } break; case 6: //打印 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "PrintDDQK('" + qkdh + "');", true); break; case 7: //查看发票 ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "View_Bill('" + bill + "','DView');", true); break; case 8: //财务付款 if (CheckPower(qkr, qkzt, 4)) { if (Session["UserDeptID"].ToString() == "08") { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "ViewQK('" + qkdh + "','EditCW');", true); } else { ScriptManager.RegisterStartupScript(this.Page, GetType(), "", "alert('您无权进行此操作!');", true); } } break; } } }