protected void Confirm_Click(object sender, EventArgs e)
{
string a = Request.QueryString["FLAG"].ToString();
if (Request.QueryString["FLAG"].ToString() == "NEW")
{
string sql = "INSERT INTO TBTM_GNFY(GNFY_YEAR,GNFY_PJNAME,GNFY_ENGNAME,GNFY_HTBH,GNFY_HTJE,GNFY_RZB," +
"GNFY_ZW,GNFY_ZV,GNFY_DJTIME,GNFY_ZL1,GNFY_ZL2," +
"GNFY_TJ1,GNFY_TJ2,GNFY_CC,GNFY_GBZL,GNFY_LJE," +
"GNFY_BZ,GNFY_CLERKID,GNFY_DATE)" +
"VALUES('" + TextBoxYEAR.Text + "','" + TextBoxProject.Text + "','" + TextBoxEngine.Text + "','" + TextBoxHTBH.Text + "','" +
TextBoxHTJE.Text + "','" + TextBoxRZB.Text + "','" + TextBoxZZL.Text + "','" +
TextBoxZTJ.Text + "','" + TextBoxDJTIME.Text + "','" + TextBoxZL.Text + "','" +
TextBoxZL1.Text + "','" + TextBoxTJ.Text + "','" + TextBoxTJ1.Text + "','" +
TextBoxCC.Text + "','" + TextBoxGBZL.Text + "','" + TextBoxZZJSJE.Text + "','" +
TextBoxBZ.Text + "','" +
Session["UserID"].ToString() + "','" + DateTime.Now + "')";
DBCallCommon.ExeSqlText(sql);
Confirm.Enabled = false;
}
if (Request.QueryString["FLAG"].ToString() == "EDIT")
{
string sql = "UPDATE TBTM_GNFY SET GNFY_PJNAME='" + TextBoxProject.Text + "',GNFY_HTBH='" + TextBoxHTBH.Text + "'," +
"GNFY_HTJE='" + TextBoxHTJE.Text + "',GNFY_RZB='" + TextBoxRZB.Text + "'," +
"GNFY_ENGNAME='" + TextBoxEngine.Text + "',GNFY_DJTIME='" + TextBoxDJTIME.Text + "'," +
"GNFY_ZW='" + TextBoxZZL.Text + "',GNFY_ZV='" + TextBoxZTJ.Text + "'," +
"GNFY_ZL1='" + TextBoxZL.Text + "',GNFY_ZL2='" + TextBoxZL1.Text + "'," +
"GNFY_TJ1='" + TextBoxTJ.Text + "',GNFY_TJ2='" + TextBoxTJ1.Text + "'," +
"GNFY_CC='" + TextBoxCC.Text + "',GNFY_GBZL='" + TextBoxGBZL.Text + "'," +
"GNFY_LJE='" + TextBoxZZJSJE.Text + "',GNFY_BZ='" + TextBoxBZ.Text + "'," +
"GNFY_YEAR='" + TextBoxYEAR.Text + "'," +
"GNFY_CLERKID='" + Session["UserID"].ToString() + "'," +
"GNFY_DATE='" + DateTime.Now + "' WHERE GNFY_ID='" + Request.QueryString["ID"].ToString() + "'";
DBCallCommon.ExeSqlText(sql);
}
Response.Redirect("SM_Trans_GNFY.aspx");
}
protected void btn_del_Click(object sender, EventArgs e)
{
string strId = string.Empty;
string context = string.Empty;
List <string> list = new List <string>();
foreach (RepeaterItem rptItem in Repeater1.Items)
{
CheckBox chk = (CheckBox)rptItem.FindControl("chk");
if (chk.Checked)
{
strId += "'" + ((Label)rptItem.FindControl("CM_ID")).Text + "'" + ",";
context += "'" + ((Label)rptItem.FindControl("CM_CONTEXT")).Text + "'" + ",";
}
}
strId = strId.Substring(0, strId.Length - 1);
context = context.Substring(0, context.Length - 1);
#region 除文件
string sqlfile = "select fileload,fileName from tb_files where BC_CONTEXT in (" + context + ")";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlfile);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string strFilePath = dt.Rows[i]["fileload"].ToString() + @"\" + dt.Rows[i]["fileName"].ToString();
File.Delete(strFilePath);
}
}
#endregion
string sqlTxt = "delete from TBCM_APPLICA where CM_ID in (" + strId + ")";
list.Add(sqlTxt);
string sqlTxt1 = "delete from tb_files where BC_CONTEXT in (" + context + ")";
list.Add(sqlTxt1);
DBCallCommon.ExecuteTrans(list);
bindGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Title = "岗位信息管理";
lblupdate.Visible = false;
lblupload2.Visible = false;
string actionstr = Request.QueryString["action"].ToString();
GetDepartment1(); //获取部门下拉框的值
//getjobcat(); //获取工种下拉框的值
if (actionstr == "add")
{
btnupdate.Text = "增加";
//ST_MANCLERK.Text = Session["UserName"].ToString();
ST_FILLDATE.Text = System.DateTime.Now.ToString();
Panel2.CssClass = "";
TextBoxdept.Visible = false;
Panel1.Enabled = true;
}
else if (actionstr == "update")
{
//ST_MANCLERK.Text = Session["UserName"].ToString();
ST_FILLDATE.Text = System.DateTime.Now.ToString();
Panel2.CssClass = "";
TextBoxdept.Visible = false;
Panel1.Enabled = true;
Showdata();
}
else
{
btnupdate.Visible = false;
DropDownListdept.Visible = false;
Showdata();
}
}
DBCallCommon.closeConn(sqlConn);
}
protected void btn_export_Click(object sender, EventArgs e)
{
string condition = ViewState["StrWhere"].ToString();
string sqlfjcb = "select FJCB_TSAID,sum(ISNULL(FJCB_HJHSJE,0)) as FJCB_HJHSJE,sum(ISNULL(FJCB_HJBHSJE,0)) as FJCB_HJBHSJE,(FJCB_YEAR+'-'+FJCB_MONTH) as FJCB_YEARMONTH from FM_FJCB where " + condition + " group by FJCB_TSAID,(FJCB_YEAR+'-'+FJCB_MONTH)";
System.Data.DataTable dtfjcb = DBCallCommon.GetDTUsingSqlText(sqlfjcb);
string filename = "分交成本任务号汇总.xls";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename)));
HttpContext.Current.Response.Clear();
using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("分交成本汇总导出.xls")))
{
IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象
ISheet sheet1 = wk.GetSheetAt(0);
for (int i = 0; i < dtfjcb.Rows.Count; i++)
{
IRow row = sheet1.CreateRow(i + 1);
ICell cell0 = row.CreateCell(0);
cell0.SetCellValue(i + 1);
for (int j = 0; j < dtfjcb.Columns.Count; j++)
{
string str = dtfjcb.Rows[i][j].ToString();
row.CreateCell(j + 1).SetCellValue(str);
}
}
for (int r = 0; r <= dtfjcb.Columns.Count; r++)
{
sheet1.AutoSizeColumn(r);
}
sheet1.ForceFormulaRecalculation = true;
MemoryStream file = new MemoryStream();
wk.Write(file);
HttpContext.Current.Response.BinaryWrite(file.GetBuffer());
HttpContext.Current.Response.End();
}
}
protected void btnYYFX_OnClick(object sender, EventArgs e)
{
string CLD_ID = "";
string CLD_SPZT = "";
string CLD_BH = "";
for (int i = 0, length = rptSHFWCLD.Items.Count; i < length; i++)
{
CheckBox cbx = (CheckBox)rptSHFWCLD.Items[i].FindControl("cbxXuHao");
if (cbx.Checked)
{
CLD_ID = ((HtmlInputHidden)rptSHFWCLD.Items[i].FindControl("CLD_ID")).Value;
CLD_SPZT = ((HtmlInputHidden)rptSHFWCLD.Items[i].FindControl("CLD_SPZT")).Value;
CLD_BH = ((Label)rptSHFWCLD.Items[i].FindControl("CLD_BH")).Text.Trim();
break;
}
}
if (CLD_ID == "")
{
Response.Write("<script type='text/javascript'>alert('请勾选一条进行修改！！！')</script>");
return;
}
else if (CLD_SPZT == "1y")
{
string sql = "update CM_SHCLD set CLD_YYFX_TXR='" + hidTXR.Value.Trim() + "',";
sql += "CLD_YYFX_FGR='" + Session["UserName"].ToString() + "'";
sql += " where CLD_ID='" + CLD_ID + "'";
DBCallCommon.ExeSqlText(sql);
Response.Write("<script type='text/javascript'>alert('您已成功将任务分给了“" + hidTXR.Value + "”！！！')</script>");
DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(GetST_ID(hidTXR.Value)), new List <string>(), new List <string>(), "售后质量问题处理通知", "您有售后质量问题处理单“" + CLD_BH + "”需要填写“原因分析”，请登录系统,进入市场管理模块的“售后质量问题处理单页面”进行填写。");
}
else
{
Response.Write("<script type='text/javascript'>alert('市场部长审批通过后您才能分工！！！')</script>");
return;
}
}
//protected string check_ddl_YS()
//{
// Encrypt_Decrypt ed = new Encrypt_Decrypt();
// string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
// string Mar_code = Request.QueryString["Marcode"].ToString();
// string str_ys_name = "";
// if (Mar_code=="01.07")
// {
// if (ddl_YS_name.SelectedItem.Text.ToString()=="定尺板")
// {
// if (DropDownList_mar_type.SelectedItem.Text.ToString()!="定尺板")
// {
// str_ys_name = " and PO_MASHAPE='定尺板'";
// }
// }
// else
// if (ddl_YS_name.SelectedItem.Text.ToString() == "轨道系统")
// {
// str_ys_name = " and marnm like '%轨道%'";
// }
// else if (ddl_YS_name.SelectedItem.Text.ToString() == "普通材料")
// {
// str_ys_name = " and charindex('轨道',marnm)=0 and PO_MASHAPE!='定尺板'";
// }
// }
// if (Mar_code=="01.11"||Mar_code=="01.08")
// {
// str_ys_name = " and charindex('" + ddl_YS_name.SelectedItem.Text.ToString() + "',marnm)>0 ";
// string sql_contain = "select YS_Product_Name from TBBD_Product_type where YS_Product_Tag='1' " +
// "and charindex('-',YS_Product_Code)>0 and YS_Product_Name like '%" + ddl_YS_name.SelectedItem.Text.ToString() + "%' " +
// "and YS_Product_Name!='" + ddl_YS_name.SelectedItem.Text.ToString() + "'";
// System.Data.DataTable dt_contain = DBCallCommon.GetDTUsingSqlText(sql_contain);
// for (int s = 0; s < dt_contain.Rows.Count; s++)
// {
// str_ys_name += " and charindex('" + dt_contain.Rows[s]["YS_Product_Name"] + "',marnm)=0";
// }
// }
// if (Mar_code=="other")
// {
// string sql_mar_type = "select YS_Product_Code from TBBD_Product_type where YS_Product_Name='" + ddl_YS_name.SelectedItem.Text.ToString() + "'";
// System.Data.DataTable dt_mar_type = DBCallCommon.GetDTUsingSqlText(sql_mar_type);
// if (dt_mar_type.Rows.Count > 0)
// {
// str_ys_name += " and marid like '" + dt_mar_type.Rows[0][0].ToString() + "%'";
// }
// }
// return str_ys_name;
//}
//protected void bind_ddl_YSname()
//{
// Encrypt_Decrypt ed = new Encrypt_Decrypt();
// string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
// string Mar_code = Request.QueryString["Marcode"].ToString();
// string name_type = "";
// switch (Mar_code)
// {
// case "01.07": name_type = "FERROUS_METAL"; break;
// case "01.11": name_type = "PURCHASE_PART"; break;
// case "01.08": name_type = "MACHINING_PART"; break;
// case "01.15": name_type = "PAINT_COATING"; break;
// case "01.18": name_type = "ELECTRICAL"; break;
// case "other": name_type = "OTHERMAT_COST"; break;
// default: break;
// }
// string sql_YS_NAME = "select distinct YS_NAME,YS_NAME from YS_COST_BUDGET_DETAIL where YS_CONTRACT_NO='" + ContractNo + "' and YS_FATHER='" + name_type + "' and YS_NAME!='其它'";
// DBCallCommon.FillDroplist(ddl_YS_name, sql_YS_NAME);
//}
protected void bind_ddl_mar()
{
Encrypt_Decrypt ed = new Encrypt_Decrypt();
string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
string Mar_code = Request.QueryString["Marcode"].ToString();
switch (Mar_code)
{
case "01.07": YS_NAME.Text = "黑色金属"; break;
case "01.11": YS_NAME.Text = "外购件"; break;
case "01.08": YS_NAME.Text = "加工件"; break;
case "01.15": YS_NAME.Text = "油漆涂料"; break;
case "01.18": YS_NAME.Text = "电气电料"; break;
case "other": YS_NAME.Text = "其他材料费"; break;
default: break;
}
string sql_where = " engid='" + ContractNo + "'";
//获取材料ID
if (Mar_code != "other")
{
sql_where += " and marid like '" + Mar_code + "%'";
}
else
{
sql_where += " and charindex(substring(marid,1,5),'01.07.01.08.01.11.01.15.01.18')=0";
}
string sqltext_mar_type = "SELECT DISTINCT isnull(PO_MASHAPE,'无') ,PO_MASHAPE FROM View_TBPC_PURORDERDETAIL_PLAN_TOTAL where " + sql_where;
DBCallCommon.FillDroplist(DropDownList_mar_type, sqltext_mar_type);
}
//停用厂商
protected void delete_Click(object sender, CommandEventArgs e)
{
string id = e.CommandName;
// string sql = "select * from TBCS_CUSUP_ADD_DELETE where ID='" + id + "' and CS_ACTION='1'";
//System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
//if (dt.Rows.Count > 0)
//{
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert ('该厂商已提交过停用申请，请查看！！！');window.close();", true);
//}
string sql = "select * from TBCS_CUSUPINFO where cs_code='" + id + "' ";
System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (sfjy.SelectedIndex == 0)
{
// Response.Write("<script>javascript:window.showModalDialog('tbcs_cusup_add_delete.aspx?action=Delete&cs_action=1&id=" + id + "','','DialogWidth=1100px;DialogHeight=1000px')</script>");
if (dt.Rows[0]["CS_TYPE"].ToString() == "2")
{
Response.Redirect("tbcs_cusup_add_delete.aspx?action=Delete&cs_action=1&id=" + id + "");
}
else
{
Response.Redirect("tbcs_cusup_add_delete_old.aspx?action=Delete&cs_action=1&id=" + id + "");
}
}
else if (sfjy.SelectedIndex == 1)
{
// Response.Write("<script>javascript:window.showModalDialog('tbcs_cusup_add_delete.aspx?action=Delete&cs_action=1&id=" + id + "','','DialogWidth=1100px;DialogHeight=1000px')</script>");
if (dt.Rows[0]["CS_TYPE"].ToString() == "2")
{
Response.Redirect("tbcs_cusup_add_delete.aspx?action=Delete&cs_action=0&id=" + id + "");
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert ('该功能是针对采购供应商再起启用的功能，您无法进行此项操作！！！');window.close();", true);
}
}
}
//导出
protected void btndaochu_Click(object sender, EventArgs e)
{
string strwhere = ViewState["sqlText"].ToString().Trim();
string sql = "select PCODE,MARID,MARNM,MARGG,MARCZ,MARGB,NUM,UNIT,substring(TJDATE,1,11) AS SUBMITTM,DEPNM,TJRNM,DETAILNOTE from View_OTHER_PLAN_RVW where " + strwhere + " order by SUBMITTM DESC";
System.Data.DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
string filename = "新增采购申请导出.xls";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename)));
HttpContext.Current.Response.Clear();
using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("新增采购申请导出模板.xls")))
{
IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象
ISheet sheet1 = wk.GetSheetAt(0);
for (int i = 0; i < dt.Rows.Count; i++)
{
IRow row = sheet1.CreateRow(i + 1);
ICell cell0 = row.CreateCell(0);
cell0.SetCellValue(i + 1);
for (int j = 0; j < dt.Columns.Count; j++)
{
string str = dt.Rows[i][j].ToString();
row.CreateCell(j + 1).SetCellValue(str);
}
}
//for (int r = 0; r <= dt.Columns.Count; r++)
//{
// sheet1.AutoSizeColumn(r);
//}
sheet1.ForceFormulaRecalculation = true;
MemoryStream file = new MemoryStream();
wk.Write(file);
HttpContext.Current.Response.BinaryWrite(file.GetBuffer());
HttpContext.Current.Response.End();
}
}
protected void btnSave_Replace(object sender, EventArgs e)
{
string sqltext;
if (((Button)sender).CommandName == "Replace")
{
sqltext = "update " + tablename + " set " + ddlRepType.SelectedValue + "=REPLACE(" + ddlRepType.SelectedValue + ",'" + txtStart.Text.Trim() + "','" + txtEnd.Text.Trim() + "') WHERE " + ViewState["Org"].ToString() + "";
string conStr = DBCallCommon.GetStringValue("connectionStrings");
SqlConnection conn = new SqlConnection(conStr);
SqlCommand sc = new SqlCommand();
sc.CommandType = CommandType.Text;
sc.Connection = conn;
sc.CommandText = sqltext;
DBCallCommon.openConn(conn);
int rowEffected = sc.ExecuteNonQuery();
DBCallCommon.closeConn(conn);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('替换成功！！！\\r\\r影响行数【" + rowEffected + "】');", true);
}
else if (((Button)sender).CommandName == "Add")
{
sqltext = "update " + tablename + " set " + ddlRepType.SelectedValue + "=" + ddlRepType.SelectedValue + "+' " + txtAdd.Text.Trim() + "' WHERE " + ViewState["Org"].ToString() + "";
string conStr = DBCallCommon.GetStringValue("connectionStrings");
SqlConnection conn = new SqlConnection(conStr);
SqlCommand sc = new SqlCommand();
sc.CommandType = CommandType.Text;
sc.Connection = conn;
sc.CommandText = sqltext;
DBCallCommon.openConn(conn);
int rowEffected = sc.ExecuteNonQuery();
DBCallCommon.closeConn(conn);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('追加成功！！！\\r\\r影响行数【" + rowEffected + "】');", true);
}
}
private void SendEmail()
{
foreach (ListItem item in cbxCS.Items)
{
if (item.Selected)
{
DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(item.Value), new List <string>(), new List <string>(), "顾客财产质检", "您有合同号为" + CM_CONTR.Text.Trim() + ",项目名称为" + CM_PJNAME.Text.Trim() + ",顾客为" + CM_COSTERM.Text.Trim() + "的顾客财产需要质检，请登录系统查看。");
}
}
foreach (ListItem item in cbxTH.Items)
{
if (item.Selected)
{
DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(item.Value), new List <string>(), new List <string>(), "新增顾客财产查看", "合同号为" + CM_CONTR.Text.Trim() + ",项目名称为" + CM_PJNAME.Text.Trim() + ",顾客为" + CM_COSTERM.Text.Trim() + "的顾客财产下推至质检，请登录系统查看。");
}
}
foreach (ListItem item in cbxPD.Items)
{
if (item.Selected)
{
DBCallCommon.SendEmail(DBCallCommon.GetEmailAddressByUserID(item.Value), new List <string>(), new List <string>(), "新增顾客财产查看", "合同号为" + CM_CONTR.Text.Trim() + ",项目名称为" + CM_PJNAME.Text.Trim() + ",顾客为" + CM_COSTERM.Text.Trim() + "的顾客财产下推至质检，请登录系统查看。");
}
}
}
protected void btndc_click(object sender, EventArgs e)
{
string condition = ViewState["StrWhere"].ToString();
string sqldif = "select DIFYF_TSAID,DIFYF_YEAR,DIFYF_MONTH,sum(cast(isnull(DIFYF_DIFMONEY,0) as decimal(12,2))) from TBFM_YFDIF where " + condition + " group by DIFYF_TSAID,DIFYF_YEAR,DIFYF_MONTH";
System.Data.DataTable dtdif = DBCallCommon.GetDTUsingSqlText(sqldif);
string filename = "运费差额.xls";
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", System.Web.HttpContext.Current.Server.UrlEncode(filename)));
HttpContext.Current.Response.Clear();
using (FileStream fs = File.OpenRead(System.Web.HttpContext.Current.Server.MapPath("运费差额导出模版.xls")))
{
IWorkbook wk = new HSSFWorkbook(fs);//创建workbook对象
ISheet sheet1 = wk.GetSheetAt(0);
for (int i = 0; i < dtdif.Rows.Count; i++)
{
IRow row = sheet1.CreateRow(i + 1);
row.CreateCell(0).SetCellValue(i + 1);
for (int j = 0; j < dtdif.Columns.Count; j++)
{
string str = dtdif.Rows[i][j].ToString();
row.CreateCell(j + 1).SetCellValue(str);
}
}
for (int r = 0; r <= dtdif.Columns.Count; r++)
{
sheet1.AutoSizeColumn(r);
}
sheet1.ForceFormulaRecalculation = true;
MemoryStream file = new MemoryStream();
wk.Write(file);
HttpContext.Current.Response.BinaryWrite(file.GetBuffer());
HttpContext.Current.Response.End();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
List <string> sql = new List <string>();
string sqltext = "";
foreach (RepeaterItem LabelID in Det_Repeater.Items)
{
System.Web.UI.WebControls.CheckBox chk = (System.Web.UI.WebControls.CheckBox)LabelID.FindControl("CKBOX_SELECT");
if (chk.Checked)
{
string Id = ((HtmlInputHidden)LabelID.FindControl("hidId")).Value;
sqltext = "delete FROM TBDS_KaoHe_JXDetail WHERE Id='" + Id + "'";
sql.Add(sqltext);
}
}
DBCallCommon.ExecuteTrans(sql);
Response.Write("<script>alert('删除成功！')</script>");
ShowData(hidConext.Value);
CaculZongGZ(hidConext.Value);
}
private void Bind_Audit_Info()
{
string sqltext = "select * from View_EQU_AUDIT where DocuNum='" + TextBox_pid.Text.ToString() + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext);
if (dt.Rows.Count > 0)
{
firstid.Value = dt.Rows[0]["Fir_Per"].ToString();
txt_first.Text = dt.Rows[0]["name1"].ToString();
if (dt.Rows[0]["Fir_Jg"].ToString() != "0")
{
rbl_first.SelectedValue = dt.Rows[0]["Fir_Jg"].ToString();
}
first_time.Text = dt.Rows[0]["Fir_Sj"].ToString();
first_opinion.Text = dt.Rows[0]["Fir_Yj"].ToString();
secondid.Value = dt.Rows[0]["Sec_Per"].ToString();
txt_second.Text = dt.Rows[0]["name2"].ToString();
if (dt.Rows[0]["Sec_Jg"].ToString() != "0")
{
rbl_second.SelectedValue = dt.Rows[0]["Sec_Jg"].ToString();
}
second_time.Text = dt.Rows[0]["Sec_Sj"].ToString();
second_opinion.Text = dt.Rows[0]["Sec_Yj"].ToString();
thirdid.Value = dt.Rows[0]["Thi_Per"].ToString();
txt_third.Text = dt.Rows[0]["name3"].ToString();
if (dt.Rows[0]["Thi_Jg"].ToString() != "0")
{
rbl_third.SelectedValue = dt.Rows[0]["Thi_Jg"].ToString();
}
third_time.Text = dt.Rows[0]["Thi_Sj"].ToString();
third_opinion.Text = dt.Rows[0]["Thi_Yj"].ToString();
Control_SHLC();
}
}
private void bindControl()
{
string sql = "select count(*) from TBFM_STORAGEBAL where SI_YEAR='" + DateTime.Now.Year.ToString() + "' and SI_PERIOD='" + DateTime.Now.Month.ToString().PadLeft(2, '0') + "' and SI_BEGNUM=0 and SI_BEGBAL<>0";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (Convert.ToInt16(dt.Rows[0][0]) == 0)
{
btn_adjust.Enabled = false;
}
dt.Clear();
sql = "select count(*) from TBFM_STORAGEBAL where SI_YEAR='" + DateTime.Now.Year.ToString() + "' and SI_PERIOD='" + DateTime.Now.Month.ToString().PadLeft(2, '0') + "' and SI_BEGNUM=0 and SI_BEGDIFF<>0";
dt = DBCallCommon.GetDTUsingSqlText(sql);
if (Convert.ToInt16(dt.Rows[0][0]) == 0)
{
btn_antiadjust.Enabled = false;
}
else
{
GridView1.EmptyDataText = "期初异常金额已调整！";
}
dt.Clear();
sql = "select count(*) from TBFM_HSTOTAL where HS_YEAR='" + DateTime.Now.Year.ToString() + "' and HS_MONTH='" + DateTime.Now.Month.ToString().PadLeft(2, '0') + "' and HS_STATE='2'";
dt = DBCallCommon.GetDTUsingSqlText(sql);
if (Convert.ToInt16(dt.Rows[0][0]) > 0)
{
//期初调整和反期初调整都不能用
btn_adjust.Enabled = false;
btn_antiadjust.Enabled = false;
}
dt.Clear();
}
private void Control_Enable()
{
string sql = "select * from TBCM_ChANLIST where CH_ID='" + chId + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
int n = int.Parse(dr["CM_PSJB"].ToString());
for (int i = 0; i < n; i++)
{
Panel pal = new Panel();
pal = (Panel)TabContainer1.FindControl("Pan_ShenHe").FindControl("Panel" + i.ToString());
TextBox tbyj = (TextBox)TabContainer1.FindControl("Pan_ShenHe").FindControl("txt_shyj" + i.ToString());
Label lb = (Label)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shr" + i.ToString());
HiddenField hd = (HiddenField)TabContainer1.FindControl("Pan_ShenHe").FindControl("lb_shrid" + i.ToString());
if (UserID.Value == hd.Value && tbyj.Text == "")
{
pal.Enabled = true;
tbyj.BorderColor = System.Drawing.Color.Orange;
tbyj.Focus();
LbtnYes.Visible = true;
LbtnNO.Visible = true;
if (action == "look")
{
pal.Enabled = false;
}
}
else
{
pal.Enabled = false;
}
}
}
}
private DataTable GetdetailData()
{
string shape = "";
string sqltext = "";
sqltext = "SELECT mpcode,ptcode,marid,marnm,marguige+'/'+marcaizhi+'/'+marguobiao as marxinxi, cast(cast(num as float) as varchar)+'('+marcgunit+')' as num, cast(cast(fznum as float) as varchar)+'('+fzunit+')' as fznum, " +
" allnote,detailmarid, detailmarnm, detailmarguige+'/'+detailmarcaizhi+'/'+detailmarguobiao as demarxinxi, " +
" cast(cast(detailmarnuma as float) as varchar)+'('+detailmarunit+')' as detailnum,cast(cast(detailmarnumb as float) as varchar)+'('+detailfzunit+')' as detailfznum, " +
" detailnote, length, width, detaillength, detailwidth " +
"FROM View_TBPC_MARREPLACE_total_all_detail " +
"WHERE mpcode='" + gloabsheetno + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext);
int rowsnum = dt.Rows.Count;
for (int i = rowsnum + 1; i <= 1; i++)
{
DataRow dr = dt.NewRow();
dr["mpcode"] = "";
dr["ptcode"] = "";
dr["marid"] = "";
dr["marnm"] = "";
dr["marxinxi"] = "";
dr["num"] = "";
dr["fznum"] = "";
dr["allnote"] = "";
dr["detailmarid"] = "";
dr["detailmarnm"] = "";
dr["demarxinxi"] = "";
dr["detailnum"] = "";
dr["detailfznum"] = "";
dr["detailnote"] = "";
dt.Rows.Add(dr);
}
return(dt);
}
//扣款
//YZ扣款 "-" OK
protected void btnKKZJYZ_Click(object sender, EventArgs e)
{
decimal kkje = 0;
string kkrq = DateTime.Now.ToString("yyyy-MM-dd");
if (txtZZSPJEZJYZ.Text.Trim() != "")
{
kkje = Convert.ToDecimal(txtZZSPJEZJYZ.Text.Trim());
string sqltext1 = "update TBPM_CONPCHSINFO set PCON_SPJE=PCON_SPJE+" + kkje + " where PCON_BCODE='" + HTBH.Text.Trim() + "'";
string sqltext2 = "update TBPM_SUBCLAIM set SPS_ZZSPJE=" + kkje + ",SPS_SFKK=0,SPS_KKRQ='" + kkrq + "' where SPS_HTBH='" + HTBH.Text.Trim() + "' and SPS_ID='" + txtSPDH.Text.Trim() + "' and SPS_SPLB=" + splb;
List <string> sql = new List <string>();
sql.Add(sqltext1);
sql.Add(sqltext2);
DBCallCommon.ExecuteTrans(sql);
btnKKZJYZ.Visible = false;
rblSFKKZJYZ.SelectedIndex = 0;
this.ClientScript.RegisterStartupScript(GetType(), "js", "alert('扣款成功!已扣款" + kkje + "并添加到合同索赔金额中');", true);
}
else
{
this.ClientScript.RegisterStartupScript(GetType(), "js", "alert('索赔金额不能为空!');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
UCPaging1.PageChanged += new UCPaging.PageHandler(Pager_PageChanged);
ViewState["ObjPageSize"] = Convert.ToDouble(DropDownList5.SelectedValue);
if (!IsPostBack)
{
if (Session["UserDeptID"].ToString() == "03")
{
btn_BGdata.Visible = true;
btn_editbeizhu.Visible = true;
}
//hid_filter.Text = "(select top(10000) * from View_TBPC_PLAN_PLACE order by PUR_ID desc)t" + "/" + Session["UserID"].ToString();
//if (DropDownListrange.SelectedIndex == 1)
//{
hid_filter.Text = "View_TBPC_PLAN_PLACE" + "/" + Session["UserID"].ToString();
//}
string sf = "";
if (Request.QueryString["sf"] != null)
{
sf = Request.QueryString["sf"].ToString();
}
if (sf != "1")
{
string sqltext = "";
sqltext = "delete from TBPC_FILTER_INFO where tableuser='******'";
DBCallCommon.ExeSqlText(sqltext);
sqltext = "delete from TBPC_COLUMNFILTER_INFO where tableuser='******'";
DBCallCommon.ExeSqlText(sqltext);
}
bindcloseper();
initpageinfo();
getArticle(true);
//getClassTwo();
}
//CheckUser(ControlFinder);
}
protected void Textname_TextChanged(object sender, EventArgs e)
{
int num = (sender as TextBox).Text.Trim().IndexOf("|", 0);
if (num > 0)
{
string stid = (sender as TextBox).Text.Trim().Substring(0, num);
string sqlText = "select * from View_TBDS_STAFFINFO where ST_ID='" + stid + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText);
if (dt.Rows.Count > 0)
{
lbstid.Text = stid;
txtname.Text = dt.Rows[0]["ST_NAME"].ToString().Trim();
txtdepartment.Text = dt.Rows[0]["DEP_NAME"].ToString().Trim();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('人员不存在，请重新输入！');", true);
}
}
}
protected void getStaffInfo(string st_id, string DEP_NAME, int i)
{
string sql = string.Format("select ST_NAME,ST_ID,ST_DEPID from TBDS_STAFFINFO as a inner join TBCM_HT_SETTING as b on a.ST_ID=b.per_id where a.ST_PD='0'and b.dep_id='{0}' and per_sfjy='0' and per_type='0'", st_id);
//bindInfo(sql, i, DEP_NAME, st_id);
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (st_id == "01")
{
for (int j = 0; j < dt.Rows.Count; j++)
{
DataTable ld = new DataTable();
ld.Columns.Add("ST_NAME");
ld.Columns.Add("ST_ID");
ld.Columns.Add("ST_DEPID");
ld.Rows.Add(dt.Rows[j][0].ToString(), dt.Rows[j][1].ToString(), dt.Rows[j][2].ToString());
bindInfo(ld, st_id + j.ToString(), DEP_NAME, i);
i++;
}
}
else
{
bindInfo(dt, st_id, DEP_NAME, i);
}
}
protected string generatecode()
{
string pi_id = "";
if (gloabptc.Contains("#"))
{
gloabptc = gloabptc.Substring(0, gloabptc.IndexOf("#")).ToString();
}
string tag_pi_id = gloabptc + "#";
string end_pi_id = "";
string sqltext = "SELECT TOP 1 PIC_PTCODE FROM TBPC_IQRCMPPRICE WHERE PIC_PTCODE LIKE '" + tag_pi_id + "%' ORDER BY PIC_PTCODE DESC";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext);
if (dt.Rows.Count > 0)
{
end_pi_id = Convert.ToString(Convert.ToInt32((dt.Rows[0]["PIC_PTCODE"].ToString().Substring(dt.Rows[0]["PIC_PTCODE"].ToString().Length - 1, 1))) + 1);
}
else
{
end_pi_id = "1";
}
pi_id = tag_pi_id + end_pi_id;
return(pi_id);
}
/****************************对绑定已经勾选的评审人*************************************/
private void bindSelectReviewer()
{
string cr_id = LBpsdh.Text;// 评审单号
string sql_psbm = "select distinct dep_id,b.dep_name from TBCM_HT_SETTING as a left join TBDS_DEPINFO as b on a.dep_id=b.DEP_CODE";
DataTable dt_psbm = DBCallCommon.GetDTUsingSqlText(sql_psbm);
for (int i = 0; i < dt_psbm.Rows.Count; i++)
{
CheckBoxList ck = (CheckBoxList)Panel1.FindControl("cki" + i.ToString());
if (ck != null)
{
for (int j = 0; j < ck.Items.Count; j++)
{
string check_select = "select * from TBCR_CONTRACTREVIEW_DETAIL where" +
" CRD_ID='" + cr_id + "' and CRD_PID='" + ck.Items[j].Value + "' and CRD_DEP!='01'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(check_select);
if (dt.Rows.Count > 0)
{
ck.Items[j].Selected = true;
}
}
}
}
}
//创建单号
private string Create_orderid()
{
string id = "";
id = "TJZJ-R-QM-";
string sqlText = "select Top 1 PRO_ID from TBQC_EXTERNAL_AUDIT where PRO_ID like '" + id + "%' Order by PRO_ID desc";//找出的最大号
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.HasRows)
{
dr.Read();
string[] bh = dr["PRO_ID"].ToString().Split('-');
int maxID = Convert.ToInt16(bh[bh.Length - 1]) + 1;//取数组最后一个
dr.Close();
id += maxID.ToString().PadLeft(4, '0');
}
else
{
id += "0001";
}
return(id);
}
protected void btn_daochu_Click(object sender, EventArgs e)
{
int temp = isselected();
List <string> list = new List <string>();
if (temp == 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('您没有选择数据,本次操作无效！');", true);
}
else if (temp == 2)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('您选择的数据包含多条订单,本次操作无效！');", true);
}
else
{
string sqltext = "";
string sqltext2 = "";
string sqltext3 = "";
string docnum = "";
string money = "";
foreach (RepeaterItem Reitem in Purordertotal_list_Repeater.Items)
{
System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)Reitem.FindControl("CKBOX_SELECT");
if (cb.Checked)
{
docnum = ((System.Web.UI.WebControls.Label)Reitem.FindControl("TA_DOCNUM")).Text;
//sqltext = "select TA_DOCNUM, TA_ZDRNAME,CONVERT(varchar, TA_ZDTIME ,23) as TA_ZDTIME,TA_SUPPLYNAME,TA_AMOUNT,TA_TOTALWGHT,TA_TOTALNOTE,TA_PTC,TA_NUM,TA_WXTYPE,TA_PROCESS,TA_UWGHT,TA_WGHT,TA_PRICE,TA_MONEY,TA_JHQ,TA_SJJHQ,TA_NOTE from VIEW_TBMP_ACCOUNTS where TA_DOCNUM='" + docnum + "'";
sqltext = " select TA_ENGID,TA_TUHAO,TA_ZONGXU,TA_MNAME,TA_CAIZHI,TA_UNUM,TA_NUM,TA_UWGHT,TA_WGHT,TA_PROCESS,TA_PRICE,TA_MONEY,PIC_JGNUM ,TA_TOTALNOTE,TA_ZDRNAME,TA_SUPPLYNAME,TA_TOTALWGHT,TA_AMOUNT from VIEW_TBMP_ACCOUNTS where TA_DOCNUM='" + docnum + "' order by TA_ENGID ";
sqltext2 = "select TA_ENGID,TA_WXTYPE,'',TO_ENGNAME, SUM(TA_NUM),SUM(TA_WGHT),SUM(TA_MONEY),TA_JHQ,BJSJ,PIC_JGNUM from VIEW_TBMP_ACCOUNTS AS a left join (select PTC,BJSJ ,ISAGAIN,rn from (select *,row_number() over(partition by PTC order by ISAGAIN ) as rn from View_TBQM_APLYFORITEM) as a where rn<=1 ) as B ON A.TA_PTC=B.PTC WHERE TA_DOCNUM='" + docnum + "' group by TA_ENGID,TA_WXTYPE,TO_ENGNAME,TA_JHQ,BJSJ,PIC_JGNUM";
sqltext3 = "select dbo.MP_Transfor(TA_AMOUNT) as money FROM VIEW_TBMP_ACCOUNTS WHERE TA_DOCNUM='" + docnum + "'";
money = DBCallCommon.GetDTUsingSqlText(sqltext3).Rows[0]["money"].ToString();
}
}
ExportDataItem1(sqltext, sqltext2, docnum, money);
}
}
/// <summary>
/// 发运完成确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnFinsh_Click(object sender, EventArgs e)
{
string ret = this.CanFinish();
if (ret == "Ok")
{
List <string> list_sql = new List <string>();
//更新任务分工中工程的完成状态
sqltext = "update TBPM_TCTSASSGN set TSA_STATUS='1',TSA_STATE='2',TSA_REALFSDATE='" + System.DateTime.Now.ToString("yyyy-MM-dd") + "' where TSA_ID='" + tsaid.Text + "' or TSA_ID like '" + tsaid.Text + "-%'";
list_sql.Add(sqltext);
///以下暂时取消，由生产修改
////////////////////更新主计划的项目工程的完成状态，这里表示完成
//////////////////sqltext = "update TBMP_MAINPLANDETAIL set MP_STATE='1' where MP_MARK='1' and MP_ENGID='" + tsaid.Text + "'";
//////////////////list_sql.Add(sqltext);
////////////////////更新其他计划工程的完成状态。
//////////////////sqltext = "update TBMP_PDCTPLANMTH set PPM_STATE='1' where PPM_MARK='1' and PPM_ENGID='" + tsaid.Text + "'";
//////////////////list_sql.Add(sqltext);
DBCallCommon.ExecuteTrans(list_sql);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已完成确认！！！');", true);
}
else if (ret == "Y/N")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('无法进行完工确认！！！\\r\\r提示:请确认船次已添加并且发运状态为\"Y\"');", true);
}
else if (ret == "Confirmed")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('该生产制号已确认过，无法再进行确认！！！');", true);
}
else if (ret == "WeightError")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('无法确认！！！\\r\\r提示:总重与各船次分项之和不等！');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string result = "";
string wlnum = Request.Form["wlnum"].ToString().Trim();
string sql = "select sum(SQ_NUM) as SQ_NUM from TBWS_STORAGE where SQ_MARID='" + wlnum + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["SQ_NUM"].ToString().Trim() != "")
{
result = "{\"result\":\"" + dt.Rows[0]["SQ_NUM"].ToString().Trim() + "\"}";
}
else
{
result = "{\"result\":\"0\"}";
}
}
else
{
result = "{\"result\":\"0\"}";
}
Response.Write(result);
}
protected void Bind_OTHER(string ContractNo, string FatherCode)
{
string sql_OTHER = "select YS_CODE,YS_NAME,YS_MONEY as YS_MONEY_BG,YS_Union_Amount as YS_Union_Amount_BG," +
"YS_Average_Price as YS_Average_Price_BG from YS_COST_BUDGET_DETAIL where YS_CONTRACT_NO='" + ContractNo + "'" +
" and YS_FATHER='" + FatherCode + "' and YS_NAME is not null and YS_MONEY is not null";
System.Data.DataTable dt_OTHER = DBCallCommon.GetDTUsingSqlText(sql_OTHER);
dt_OTHER.Columns.Add("YS_MONEY");
dt_OTHER.Columns.Add("YS_Union_Amount");
dt_OTHER.Columns.Add("YS_Average_Price");
for (int i = 0; i < dt_OTHER.Rows.Count; i++)
{
string sql_real = "select YS_MONEY from YS_COST_REAL_DETAIL where YS_CONTRACT_NO='" + ContractNo + "'and YS_FATHER='" + FatherCode + "' and YS_NAME='" + dt_OTHER.Rows[i]["YS_NAME"] + "'";
System.Data.DataTable dt_real = DBCallCommon.GetDTUsingSqlText(sql_real);
if (dt_real.Rows.Count > 0)
{
dt_OTHER.Rows[i]["YS_MONEY"] = dt_real.Rows[0][0].ToString();
}
}
string sql_total = "select YS_" + FatherCode + " from YS_COST_REAL_OTHER where YS_CONTRACT_NO='" + ContractNo + "'";
System.Data.DataTable dt_total = DBCallCommon.GetDTUsingSqlText(sql_total);
if (dt_total.Rows.Count > 0)
{
string total = dt_total.Rows[0][0].ToString();
double total_f = (total == "" ? 0 : double.Parse(total));
lbl_total.Text = total_f.ToString("N2");
}
GridView1.DataSource = dt_OTHER;
GridView1.DataBind();
GridView1.Columns[3].Visible = false; //单价数量不显示
GridView1.Columns[4].Visible = false;
GridView1.Columns[6].Visible = false;
GridView1.Columns[7].Visible = false;
}
/// <summary>
/// 初始化页面(基本信息)
/// </summary>
private void InitInfo()
{
string tsa_id = "";
string[] fields;
string sqlText = "";
tsa_id = Request.QueryString["action"];
fields = tsa_id.Split('-');
sqlText = "select CM_PROJ as TSA_PJNAME,TSA_ENGNAME,TSA_ENGSTRTYPE,TSA_PJID ";
sqlText += "from View_TM_TaskAssign where TSA_ID='" + tsa_id + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
tsaid.Text = tsa_id;
proname.Text = dr[0].ToString();
eng_type.Value = dr[2].ToString();
}
engname.Text = dr[1].ToString();
dr.Close();
this.BindLotNums();
}
protected void btnCreat_Click(object sender, EventArgs e)
{
if (dplYear.SelectedIndex == 0 || dplMoth.SelectedIndex == 0)
{
Response.Write("<script>alert('请选择年月！！')</script>");
return;
}
year = dplYear.SelectedValue;
month = dplMoth.SelectedValue;
string sql = "select * from TBOM_BGYP_Month_max where year='" + year + "' and month='" + month + "' and type='1'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('已存在本页额度，请勿重复添加')</script>");
return;
}
else
{
sql = "insert into TBOM_BGYP_Month_max select DEP_CODE, DEP_NAME, MONTH_MAX, '" + year + "', '" + month + "', '1' from TBOM_BGYP_Month_max where type='0'";
DBCallCommon.ExeSqlText(sql);
bindGrid();
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
string TcName_id = "";
string labTcName = "";
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gr = GridView1.Rows[i];
CheckBox chk = (CheckBox)gr.FindControl("CheckBox1");
TcName_id = ((Label)gr.FindControl("lblID")).Text.Trim();
if (chk.Checked)
{
string strsql = "select ST_NAME from TBDS_STAFFINFO where ST_CODE='" + TcName_id + "'";
//SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(strsql);
//while (dr.Read())
//{
// labTcName = dr[0].ToString();
//}
labTcName = DBCallCommon.GetDTUsingSqlText(strsql).Rows[0][0].ToString();
}
}
Response.Write("<script>javascript:window.returnValue ='" + labTcName + "';window.close();</script>");
//Response.Write("<script language=\"javascript\">window.opener.document.getElementById('<%=labperson.ClientID%>').value ='" + labTcName + "';window.close();</script>");
}
