//导出付款记录
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;
}
}
}
