//protected void btnModify_OnClick(object sender, EventArgs e)
//{
// string YS_CONTRACT_NO = "";
// string CONTRACT_NO = "";
// foreach (GridViewRow grow in GridView1.Rows)
// {
// System.Web.UI.WebControls.CheckBox ckb = (System.Web.UI.WebControls.CheckBox)grow.FindControl("CheckBox1");
// if (ckb.Checked)
// {
// CONTRACT_NO = ((HiddenField)grow.FindControl("hdfMP_ID")).Value.ToString();
// Encrypt_Decrypt ed = new Encrypt_Decrypt();
// YS_CONTRACT_NO = ed.EncryptText(CONTRACT_NO);
// break;
// }
// }
// if (YS_CONTRACT_NO != "")
// {
// string sql_fin = "select YS_XS_Finished from TBPM_CONPCHSINFO where PCON_BCODE='" + CONTRACT_NO + "'";
// System.Data.DataTable dt_fin = DBCallCommon.GetDTUsingSqlText(sql_fin);
// if (dt_fin.Rows.Count > 0)
// {
// if (dt_fin.Rows[0][0].ToString() == "1")
// {
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('该合同已完成结算！');", true);
// return;
// }
// else
// {
// try
// {
// string sql = DBCallCommon.GetStringValue("connectionStrings");
// sql += "Asynchronous Processing=true;";
// SqlConnection sqlConn = new SqlConnection(sql);
// sqlConn.Open();
// SqlCommand sqlCmd = new SqlCommand("YS_COST_REAL_PROCEDURE", sqlConn);
// sqlCmd.CommandType = CommandType.StoredProcedure;
// sqlCmd.CommandTimeout = 0;
// sqlCmd.Parameters.Add("@retVal", SqlDbType.Int, 1).Direction = ParameterDirection.ReturnValue; //增加返回值参数@retVal
// IAsyncResult result = sqlCmd.BeginExecuteNonQuery();
// sqlCmd.EndExecuteNonQuery(result);
// sqlConn.Close();
// }
// catch (Exception)
// {
// throw;
// }
// string sql1 = "update TBPM_CONPCHSINFO set YS_XS_Finished='1',YS_Finshtime=GETDATE() where PCON_BCODE='" + CONTRACT_NO + "'";
// DBCallCommon.ExeSqlText(sql1);
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('合同结算成功！');", true);
// UCPaging1.CurrentPage = 1;
// InitVar();
// GetTechRequireData();
// }
// }
// }
// else
// {
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择要修改的行！！！');", true);
// }
//}
protected void btn_ShowTask_OnClick(object sender, EventArgs e)
{
string YS_CONTRACT_NO = "";
string CONTRACT_NO = "";
foreach (GridViewRow grow in GridView1.Rows)
{
System.Web.UI.WebControls.CheckBox ckb = (System.Web.UI.WebControls.CheckBox)grow.FindControl("CheckBox1");
if (ckb.Checked)
{
CONTRACT_NO = ((HiddenField)grow.FindControl("hdfMP_ID")).Value.ToString();
Encrypt_Decrypt ed = new Encrypt_Decrypt();
YS_CONTRACT_NO = ed.EncryptText(CONTRACT_NO);
break;
}
}
if (YS_CONTRACT_NO != "")
{
string URL = "YS_Cost_Budget_A_M.aspx?ContractNo=" + YS_CONTRACT_NO;
Response.Redirect(URL);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请选择要查看的行！！！');", true);
}
}
/// <summary>
/// 跳转到预算明细页面
/// </summary>
/// <param name="operate">操作参数</param>
/// <param name="contractno">合同号</param>
/// <returns></returns>
protected string GetEncodeUrl(string operate, string contractno)
{
string url = "";
Encrypt_Decrypt ed = new Encrypt_Decrypt();
url = "YS_Cost_Budget_Audit.aspx?action=" + ed.EncryptText(operate) + "&ContractNo=" + ed.EncryptText(contractno) + "&User=null";
return(url);
}
protected void GridView1_onrowdatabound(object sender, GridViewRowEventArgs e)
{
String controlId = ((GridView)sender).ClientID;
String uniqueId = "";
if (e.Row.RowType == DataControlRowType.DataRow)
{
uniqueId = String.Format("{0}{1}", controlId, e.Row.RowIndex);
e.Row.Attributes.Add("onclick", String.Format("SelectRow('{0}', this);", uniqueId));
//e.Row.Attributes.Add("onclick", "ItemOver(this)"); //单击行变色
string lbl_CONTRACT_NO = ((Label)e.Row.FindControl("lbl_YS_CONTRACT_NO")).Text.ToString();
string lbl_TSA_ID = ((Label)e.Row.FindControl("lbl_YS_TSA_ID")).Text.ToString();
e.Row.Cells[1].Attributes.Add("ondblclick", "ShowContract('" + lbl_CONTRACT_NO + "')");
e.Row.Cells[1].Attributes.Add("title", "双击关联合同信息！");
Encrypt_Decrypt ed = new Encrypt_Decrypt();
string TSA_ID = ed.EncryptText(lbl_TSA_ID);
string CONTRACT_NO = ed.EncryptText(lbl_CONTRACT_NO);
string[] fathername = { "FERROUS_METAL", "PURCHASE_PART", "MACHINING_PART", "PAINT_COATING", "ELECTRICAL", "OTHERMAT_COST", "TEAM_CONTRACT", "FAC_CONTRACT", "PRODUCT_OUT" };
//for (int i = 0; i < fathername.Length; i++)
//{
// e.Row.Cells[i + 5].Attributes.Add("ondblclick", "PurMarView('" + TSA_ID + "','" + ed.EncryptText(fathername[i]) + "')");
// e.Row.Cells[i + 5].Attributes["style"] = "Cursor:hand";
// e.Row.Cells[i + 5].Attributes.Add("title", "双击查看明细");
//}
if (Session["UserDeptID"].ToString() == "08")
{
string lab_JSstate = ((Label)e.Row.FindControl("lab_JSstate")).Text.ToString();
string lab_Finstate = ((Label)e.Row.FindControl("lab_Finstate")).Text.ToString();
if (lab_JSstate == "可结算")
{
e.Row.Cells[0].BackColor = System.Drawing.Color.Red;
}
}
}
}
protected void GridView1_onrowdatabound(object sender, GridViewRowEventArgs e)
{
String controlId = ((GridView)sender).ClientID;
String uniqueId = "";
if (e.Row.RowType == DataControlRowType.DataRow)
{
uniqueId = String.Format("{0}{1}", controlId, e.Row.RowIndex);
e.Row.Attributes.Add("onclick", String.Format("SelectRow('{0}', this);", uniqueId));
e.Row.Attributes.Add("onclick", "ItemOver(this)"); //单击行变色
//string lbl_CONTRACT_NO = ((System.Web.UI.WebControls.Label)e.Row.FindControl("lbl_YS_CONTRACT_NO")).Text.ToString();
string lbl_pcon_sch = ((System.Web.UI.WebControls.Label)e.Row.FindControl("lbl_pcon_sch")).Text.ToString();
//e.Row.Cells[1].Attributes.Add("ondblclick", "ShowContract('" + lbl_CONTRACT_NO + "')");//第二格，即合同号上添加双击事件
//e.Row.Cells[1].Attributes.Add("title", "双击关联合同信息！");
Encrypt_Decrypt ed = new Encrypt_Decrypt();
//string CONTRACT_NO = ed.EncryptText(lbl_CONTRACT_NO);
string PCON_SCH = ed.EncryptText(lbl_pcon_sch);
string[] fathername = { "FERROUS_METAL", "PURCHASE_PART", "CASTING_FORGING", "PAINT_COATING", "ELECTRICAL", "OTHERMAT_COST", "MATERIAL_COST", "TEAM_CONTRACT", "FAC_CONTRACT", "PRODUCT_OUT" };
// 利润总额和净利润的红黄预警
//string[] fathername_profit = { "PROFIT"};
//for (int m = 0; m < fathername_profit.Length; m++)
//{
// //标签提示
// double percent_O_B = ((HiddenField)e.Row.FindControl("hidden_" + fathername_profit[m])).Value.ToString() == "" ? 0 : Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername_profit[m])).Value.ToString());//订单完成百分比
// double db_Budget = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m])).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m])).Text.ToString()) / 10000, 1);//预算费用
// double db_Order = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m] + "_R")).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m] + "_R")).Text.ToString()) / 10000, 1);//实际费用
// double db_pass = Math.Round(db_Order - db_Budget, 1);
// if (db_pass > 0)
// {
// e.Row.Cells[m + 8].Attributes["style"] = "Cursor:hand";
// if (m == 0)
// {
// e.Row.Cells[m + 8].Attributes.Add("title", "毛利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,高出预算" + db_pass.ToString() + "万");
// }
// else
// {
// e.Row.Cells[m + 8].Attributes.Add("title", "净利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,高出预算" + db_pass.ToString() + "万");
// }
// }
// else
// {
// db_pass = Math.Abs(db_pass);
// if (m == 0)
// {
// e.Row.Cells[m + 8].Attributes.Add("title", "毛利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
// }
// else
// {
// e.Row.Cells[m + 8].Attributes.Add("title", "净利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
// }
// }
// //红黄预警
// if (percent_O_B < 0)
// {
// e.Row.Cells[m + 8].BackColor = System.Drawing.Color.Yellow;
// }
// else
// {
// percent_O_B = Math.Abs(percent_O_B);
// if (percent_O_B > 1.0 && percent_O_B < 1.1)
// {
// e.Row.Cells[m + 8].BackColor = System.Drawing.Color.PeachPuff;
// }
// if (percent_O_B < 1.0)
// {
// e.Row.Cells[m + 8].BackColor = System.Drawing.Color.Yellow;
// }
// }
//}
//红黄预警
for (int i = 0; i < fathername.Length; i++)
{
double percent_O_B = ((HiddenField)e.Row.FindControl("hidden_" + fathername[i])).Value.ToString() == "" ? 0 : Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername[i])).Value.ToString());
percent_O_B = Math.Abs(percent_O_B);
if (percent_O_B > 0.9 && percent_O_B < 1.0)
{
e.Row.Cells[i + 3].BackColor = System.Drawing.Color.PeachPuff;
}
if (percent_O_B > 1.0)
{
e.Row.Cells[i + 3].BackColor = System.Drawing.Color.Yellow;
}
}
for (int j = 3; j < 13; j++) //添加双击查看明细、红黄预警、进度显示
{
//if (j < 21)
//{
double percent_O_B = ((HiddenField)e.Row.FindControl("hidden_" + fathername[j - 3])).Value.ToString() == "" ? 0 : Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername[j - 3])).Value.ToString()); //订单完成百分比
double db_Budget = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 3])).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 3])).Text.ToString()) / 10000, 2); //预算费用
double db_Order = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 3] + "_R")).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 3] + "_R")).Text.ToString()) / 10000, 2); //实际费用
double db_pass = Math.Round(db_Order - db_Budget, 2);
if (j < 10)
{
//e.Row.Cells[j].Attributes.Add("ondblclick", "PurMarView('" + PCON_SCH + "','" + ed.EncryptText(fathername[j - 9]) + "')");
e.Row.Cells[j].Attributes["style"] = "Cursor:hand";
if (db_pass > 0)
{
e.Row.Cells[j].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超出预算" + db_pass.ToString() + "万");
//e.Row.Cells[j + 10].Attributes.Add("ondblclick", "PurMarView('" + PCON_SCH + "','" + ed.EncryptText(fathername[j - 9]) + "')");
e.Row.Cells[j + 10].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j + 10].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超出预算" + db_pass.ToString() + "万");
}
else
{
db_pass = Math.Abs(db_pass);
e.Row.Cells[j].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
//e.Row.Cells[j + 10].Attributes.Add("ondblclick", "PurMarView('" + PCON_SCH + "','" + ed.EncryptText(fathername[j - 9]) + "')");
e.Row.Cells[j + 10].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j + 10].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超出预算" + db_pass.ToString() + "万");
}
}
else
{
if (db_pass > 0)
{
e.Row.Cells[j].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超出预算" + db_pass.ToString() + "万");
}
else
{
db_pass = Math.Abs(db_pass);
e.Row.Cells[j].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
}
}
}
}
}
protected void GridView1_onrowdatabound(object sender, GridViewRowEventArgs e)
{
String controlId = ((GridView)sender).ClientID;
String uniqueId = "";
string[] fathername = { "MAR_AMOUNT", "FERROUS_METAL", "PURCHASE_PART", "MACHINING_PART", "PAINT_COATING", "ELECTRICAL", "OTHERMAT_COST" };
if (e.Row.RowType == DataControlRowType.DataRow)
{
uniqueId = String.Format("{0}{1}", controlId, e.Row.RowIndex);
e.Row.Attributes.Add("onclick", String.Format("SelectRow('{0}', this);", uniqueId));
//双击合同号，查看合同详细信息
string lbl_CONTRACT_NO = ((System.Web.UI.WebControls.Label)e.Row.FindControl("lbl_YS_CONTRACT_NO")).Text.ToString();
string lbl_pcon_sch = ((System.Web.UI.WebControls.Label)e.Row.FindControl("lbl_pcon_sch")).Text.ToString();
e.Row.Cells[1].Attributes.Add("ondblclick", "ShowContract('" + lbl_CONTRACT_NO + "')");//第二格，即合同号上添加双击事件
e.Row.Cells[1].Attributes.Add("title", "双击关联合同信息！");
Encrypt_Decrypt ed = new Encrypt_Decrypt();
string CONTRACT_NO = ed.EncryptText(lbl_CONTRACT_NO);
string PCON_SCH = ed.EncryptText(lbl_pcon_sch);
//红黄预警
for (int i = 0; i < fathername.Length; i++)
{
string per = ((HiddenField)e.Row.FindControl("hidden_" + fathername[i])).Value.ToString();
double percent_O_B = Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername[i])).Value.ToString());
if (percent_O_B > 0.9 && percent_O_B < 1.0)
{
e.Row.Cells[i + 5].BackColor = System.Drawing.Color.PeachPuff;
}
if (percent_O_B > 1.0)
{
e.Row.Cells[i + 5].BackColor = System.Drawing.Color.Yellow;
}
}
//双击查看详细
for (int j = 5; j < 12; j++)
{
double percent_O_B = Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername[j - 5])).Value.ToString()); //订单完成百分比
double db_Budget = Math.Round(Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 5])).Text.ToString()) / 10000, 1); //预算费用
double db_Order = Math.Round(Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 5] + "_O")).Text.ToString()) / 10000, 1); //订单费用
double db_pass = Math.Round(db_Order - db_Budget, 1);
if (j < 6)
{
if (db_pass > 0)
{
//e.Row.Cells[j].Attributes.Add("ondblclick", "PurMarView_Amount('" + PCON_SCH + "')");
e.Row.Cells[j].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j].Attributes.Add("title", "订单达到" + db_Order.ToString() + "万,达预算" + (100 * percent_O_B).ToString() + "%,超额" + db_pass.ToString() + "万，双击查看材料总额明细");
}
else
{
//e.Row.Cells[j].Attributes.Add("ondblclick", "PurMarView_Amount('" + PCON_SCH + "')");
e.Row.Cells[j].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j].Attributes.Add("title", "订单达到" + db_Order.ToString() + "万,达预算" + (100 * percent_O_B).ToString() + "%,未超额，双击查看材料总额明细");
}
}
else
{
//e.Row.Cells[j].Attributes.Add("ondblclick", "PurMarView('" + PCON_SCH + "','" + ed.EncryptText(fathername[j - 5]) + "')");
e.Row.Cells[j].Attributes["style"] = "Cursor:hand";
if (db_pass > 0)
{
e.Row.Cells[j].Attributes.Add("title", "订单达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超额" + db_pass.ToString() + "万");
}
else
{
db_pass = Math.Abs(db_pass);
e.Row.Cells[j].Attributes.Add("title", "订单达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,未超额");
}
}
}
}
}
protected void GridView1_onrowdatabound(object sender, GridViewRowEventArgs e)
{
String controlId = ((GridView)sender).ClientID;
String uniqueId = "";
if (e.Row.RowType == DataControlRowType.DataRow)
{
uniqueId = String.Format("{0}{1}", controlId, e.Row.RowIndex);
e.Row.Attributes.Add("onclick", String.Format("SelectRow('{0}', this);", uniqueId));
//e.Row.Attributes.Add("onclick", "ItemOver(this)"); //单击行变色
string lbl_CONTRACT_NO = ((System.Web.UI.WebControls.Label)e.Row.FindControl("lbl_YS_CONTRACT_NO")).Text.ToString();
//string lbl_pcon_sch = ((System.Web.UI.WebControls.Label)e.Row.FindControl("lbl_pcon_sch")).Text.ToString();
e.Row.Cells[1].Attributes.Add("ondblclick", "ShowContract('" + lbl_CONTRACT_NO + "')");//第二格，即合同号上添加双击事件
e.Row.Cells[1].Attributes.Add("title", "双击关联合同信息！");
//结算时间预警
string hidden_deadtime = ((HiddenField)e.Row.FindControl("hidden_YS_Deadtime")).Value.ToString();
DateTime deadtime = Convert.ToDateTime(hidden_deadtime);
DateTime Nowtime = DateTime.Now;
TimeSpan d1 = Nowtime.Subtract(deadtime);
int d2 = d1.Days;
if (d2 <= 7 && Nowtime < deadtime)
{
e.Row.Cells[0].BackColor = System.Drawing.Color.Orange;
}
//结算时间报警
string sql_fin = "select [GS_TIME],[CNFB_TIME],[WX_TIME] from [View_YS_CON_TIME] where [YS_CONTRACT_NO]='" + lbl_CONTRACT_NO + "'";
System.Data.DataTable dt_fin = DBCallCommon.GetDTUsingSqlText(sql_fin);
if (dt_fin.Rows.Count > 0)
{
string gs = dt_fin.Rows[0][0].ToString();
string cnfb = dt_fin.Rows[0][1].ToString();
string wx = dt_fin.Rows[0][2].ToString();
if (gs != "")
{
DateTime gstime = Convert.ToDateTime(gs);
if (gstime > deadtime)
{
e.Row.Cells[0].BackColor = System.Drawing.Color.Red;
}
}
if (cnfb != "")
{
DateTime cnfbtime = Convert.ToDateTime(cnfb);
if (cnfbtime > deadtime)
{
e.Row.Cells[0].BackColor = System.Drawing.Color.Red;
}
}
if (wx != "")
{
DateTime wxtime = Convert.ToDateTime(wx);
if (wxtime > deadtime)
{
e.Row.Cells[0].BackColor = System.Drawing.Color.Red;
}
}
}
Encrypt_Decrypt ed = new Encrypt_Decrypt();
string CONTRACT_NO = ed.EncryptText(lbl_CONTRACT_NO);
//string PCON_SCH = ed.EncryptText(lbl_pcon_sch);
string[] fathername = { "MATERIAL_COST", "TEAM_CONTRACT", "FAC_CONTRACT", "PRODUCT_OUT", "TRANS_COST", "FERROUS_METAL", "PURCHASE_PART", "CASTING_FORGING", "PAINT_COATING", "ELECTRICAL", "OTHERMAT_COST" };
// 利润总额和净利润的红黄预警
string[] fathername_profit = { "PROFIT" };
for (int m = 0; m < fathername_profit.Length; m++)
{
//标签提示
double percent_O_B = ((HiddenField)e.Row.FindControl("hidden_" + fathername_profit[m])).Value.ToString() == "" ? 0 : Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername_profit[m])).Value.ToString()); //订单完成百分比
double db_Budget = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m])).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m])).Text.ToString()) / 10000, 2); //预算费用
double db_Order = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m] + "_R")).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername_profit[m] + "_R")).Text.ToString()) / 10000, 2); //实际费用
double db_pass = Math.Round(db_Order - db_Budget, 2);
if (db_pass > 0)
{
e.Row.Cells[m + 8].Attributes["style"] = "Cursor:hand";
if (m == 0)
{
e.Row.Cells[m + 8].Attributes.Add("title", "毛利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,高出预算" + db_pass.ToString() + "万");
}
else
{
e.Row.Cells[m + 8].Attributes.Add("title", "净利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,高出预算" + db_pass.ToString() + "万");
}
}
else
{
db_pass = Math.Abs(db_pass);
if (m == 0)
{
e.Row.Cells[m + 8].Attributes.Add("title", "毛利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
}
else
{
e.Row.Cells[m + 8].Attributes.Add("title", "净利润达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
}
}
//红黄预警
if (percent_O_B < 0)
{
e.Row.Cells[m + 8].BackColor = System.Drawing.Color.Yellow;
}
else
{
percent_O_B = Math.Abs(percent_O_B);
if (percent_O_B > 1.0)
{
e.Row.Cells[m + 8].BackColor = System.Drawing.Color.Yellow;
}
if (percent_O_B < 1.0 && percent_O_B > 0.9)
{
e.Row.Cells[m + 8].BackColor = System.Drawing.Color.PeachPuff;
}
}
}
//红黄预警
for (int i = 0; i < fathername.Length; i++)
{
double percent_O_B = ((HiddenField)e.Row.FindControl("hidden_" + fathername[i])).Value.ToString() == "" ? 0 : Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername[i])).Value.ToString());
percent_O_B = Math.Abs(percent_O_B);
if (percent_O_B > 0.9 && percent_O_B < 1.0)
{
e.Row.Cells[i + 9].BackColor = System.Drawing.Color.PeachPuff;
}
if (percent_O_B > 1.0)
{
e.Row.Cells[i + 9].BackColor = System.Drawing.Color.Yellow;
}
}
for (int j = 9; j < 20; j++) //添加双击查看明细、红黄预警、进度显示
{
//if (j < 21)
//{
double percent_O_B = ((HiddenField)e.Row.FindControl("hidden_" + fathername[j - 9])).Value.ToString() == "" ? 0 : Convert.ToDouble(((HiddenField)e.Row.FindControl("hidden_" + fathername[j - 9])).Value.ToString()); //订单完成百分比
double db_Budget = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 9])).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 9])).Text.ToString()) / 10000, 2); //预算费用
double db_Order = Math.Round((((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 9] + "_R")).Text.ToString()) == "" ? 0 : Convert.ToDouble(((System.Web.UI.WebControls.Label)e.Row.FindControl("lab_" + fathername[j - 9] + "_R")).Text.ToString()) / 10000, 2); //实际费用
double db_pass = Math.Round(db_Order - db_Budget, 2);
if (j < 20)
{
//e.Row.Cells[j].Attributes.Add("ondblclick", "PurMarView('" + PCON_SCH + "','" + ed.EncryptText(fathername[j - 9]) + "')");
e.Row.Cells[j].Attributes["style"] = "Cursor:hand";
if (db_pass > 0)
{
e.Row.Cells[j].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超出预算" + db_pass.ToString() + "万");
//e.Row.Cells[j + 12].Attributes.Add("ondblclick", "PurMarView('" + PCON_SCH + "','" + ed.EncryptText(fathername[j - 9]) + "')");
e.Row.Cells[j + 12].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j + 12].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超出预算" + db_pass.ToString() + "万");
}
else
{
db_pass = Math.Abs(db_pass);
e.Row.Cells[j].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
//e.Row.Cells[j + 12].Attributes.Add("ondblclick", "PurMarView('" + PCON_SCH + "','" + ed.EncryptText(fathername[j - 9]) + "')");
e.Row.Cells[j + 12].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j + 12].Attributes.Add("title", "实际费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
}
}
else
{
if (db_pass > 0)
{
e.Row.Cells[j].Attributes["style"] = "Cursor:hand";
e.Row.Cells[j].Attributes.Add("title", "费用达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,超出预算" + db_pass.ToString() + "万");
}
else
{
db_pass = Math.Abs(db_pass);
e.Row.Cells[j].Attributes.Add("title", "订单达到" + db_Order.ToString() + "万，达预算" + (100 * percent_O_B).ToString() + "%,低于预算" + db_pass.ToString() + "万");
}
}
}
}
}
protected void BindData()
{
Encrypt_Decrypt ed = new Encrypt_Decrypt();
string ContractNo = ed.DecryptText(Request.QueryString["ContractNo"].ToString());
string[] fathername = { "FERROUS_METAL", "PURCHASE_PART", "MACHINING_PART", "PAINT_COATING", "ELECTRICAL", "OTHERMAT_COST" };
string[] mar_name = { "黑色金属", "外购件", "加工件", "油漆涂料", "电气电料", "其他材料费" };
string sql_mar_amount = "select Convert(decimal(16,2), YS_FERROUS_METAL_BG*1.17) as YS_FERROUS_METAL_BG,YS_FERROUS_METAL," +
"Convert(decimal(16,2), YS_PURCHASE_PART_BG*1.17) as YS_PURCHASE_PART_BG,YS_PURCHASE_PART," +
"Convert(decimal(16,2), YS_MACHINING_PART_BG*1.17) as YS_MACHINING_PART_BG,YS_MACHINING_PART," +
"Convert(decimal(16,2), YS_PAINT_COATING_BG*1.17) as YS_PAINT_COATING_BG,YS_PAINT_COATING," +
"Convert(decimal(16,2), YS_ELECTRICAL_BG*1.17) as YS_ELECTRICAL_BG,YS_ELECTRICAL," +
"Convert(decimal(16,2), YS_OTHERMAT_COST_BG*1.17) as YS_OTHERMAT_COST_BG,YS_OTHERMAT_COST," +
"Convert(decimal(16,2),(YS_FERROUS_METAL_BG+YS_PURCHASE_PART_BG+YS_MACHINING_PART_BG+YS_PAINT_COATING_BG+YS_ELECTRICAL_BG+YS_OTHERMAT_COST_BG)*1.17) AS YS_MAR_AMOUNT_BG," +
"(YS_FERROUS_METAL+YS_PURCHASE_PART+YS_MACHINING_PART+YS_PAINT_COATING+YS_ELECTRICAL+YS_OTHERMAT_COST) AS YS_MAR_AMOUNT," +
"Convert(decimal(16,2), 100*(YS_FERROUS_METAL/(YS_FERROUS_METAL_BG*1.17+1))) as YS_FERROUS_METAL_BG_percent," +
"Convert(decimal(16,2), 100*(YS_PURCHASE_PART/(YS_PURCHASE_PART_BG*1.17+1))) as YS_PURCHASE_PART_BG_percent," +
"Convert(decimal(16,2), 100*(YS_MACHINING_PART/(YS_MACHINING_PART_BG*1.17+1))) as YS_MACHINING_PART_BG_percent," +
"Convert(decimal(16,2), 100*(YS_PAINT_COATING/(YS_PAINT_COATING_BG*1.17+1))) as YS_PAINT_COATING_BG_percent," +
"Convert(decimal(16,2), 100*(YS_ELECTRICAL/(YS_ELECTRICAL_BG*1.17+1))) as YS_ELECTRICAL_BG_percent," +
"Convert(decimal(16,2), 100*(YS_OTHERMAT_COST/(YS_OTHERMAT_COST_BG*1.17+1))) as YS_OTHERMAT_COST_BG_percent," +
"Convert(decimal(16,2), 100*((YS_FERROUS_METAL+YS_PURCHASE_PART+YS_MACHINING_PART+YS_PAINT_COATING+YS_ELECTRICAL+YS_OTHERMAT_COST)/((YS_FERROUS_METAL_BG+YS_PURCHASE_PART_BG+YS_MACHINING_PART_BG+YS_PAINT_COATING_BG+YS_ELECTRICAL_BG+YS_OTHERMAT_COST_BG)*1.17+1))) from View_YS_COST_BUDGET_ORDER where PCON_SCH='" + ContractNo + "'";
System.Data.DataTable dt_mar_amount = DBCallCommon.GetDTUsingSqlText(sql_mar_amount);
string CONTRACT_NO = ed.EncryptText(ContractNo);
CreateNewRow(7);
int i = 0;
foreach (RepeaterItem Item in tbpc_otherpurbillRepeater.Items)
{
switch (i)
{
case 0:
((Label)Item.FindControl("lab_YS_NAME")).Text = "黑色金属";
((Label)Item.FindControl("lab_YS_MAR_BG")).Text = dt_mar_amount.Rows[0][0].ToString();
((Label)Item.FindControl("lab_YS_MAR")).Text = dt_mar_amount.Rows[0][1].ToString();
((Label)Item.FindControl("lab_YS_MAR_Percent")).Text = dt_mar_amount.Rows[0][14].ToString() + "%";
((HyperLink)Item.FindControl("Hpl_detail")).NavigateUrl = "../YS_Data/YS_Cost_Budget_O_M_Detail.aspx?ContractNo=" + CONTRACT_NO + "&FatherCode=" + ed.EncryptText("FERROUS_METAL") + "";
break;
case 1:
((Label)Item.FindControl("lab_YS_NAME")).Text = "外购件";
((Label)Item.FindControl("lab_YS_MAR_BG")).Text = dt_mar_amount.Rows[0][2].ToString();
((Label)Item.FindControl("lab_YS_MAR")).Text = dt_mar_amount.Rows[0][3].ToString();
((Label)Item.FindControl("lab_YS_MAR_Percent")).Text = dt_mar_amount.Rows[0][15].ToString() + "%";
((HyperLink)Item.FindControl("Hpl_detail")).NavigateUrl = "../YS_Data/YS_Cost_Budget_O_M_Detail.aspx?ContractNo=" + CONTRACT_NO + "&FatherCode=" + ed.EncryptText("PURCHASE_PART") + "";
break;
case 2:
((Label)Item.FindControl("lab_YS_NAME")).Text = "加工件";
((Label)Item.FindControl("lab_YS_MAR_BG")).Text = dt_mar_amount.Rows[0][4].ToString();
((Label)Item.FindControl("lab_YS_MAR")).Text = dt_mar_amount.Rows[0][5].ToString();
((Label)Item.FindControl("lab_YS_MAR_Percent")).Text = dt_mar_amount.Rows[0][16].ToString() + "%";
((HyperLink)Item.FindControl("Hpl_detail")).NavigateUrl = "../YS_Data/YS_Cost_Budget_O_M_Detail.aspx?ContractNo=" + CONTRACT_NO + "&FatherCode=" + ed.EncryptText("MACHINING_PART") + "";
break;
case 3:
((Label)Item.FindControl("lab_YS_NAME")).Text = "油漆涂料";
((Label)Item.FindControl("lab_YS_MAR_BG")).Text = dt_mar_amount.Rows[0][6].ToString();
((Label)Item.FindControl("lab_YS_MAR")).Text = dt_mar_amount.Rows[0][7].ToString();
((Label)Item.FindControl("lab_YS_MAR_Percent")).Text = dt_mar_amount.Rows[0][17].ToString() + "%";
((HyperLink)Item.FindControl("Hpl_detail")).NavigateUrl = "../YS_Data/YS_Cost_Budget_O_M_Detail.aspx?ContractNo=" + CONTRACT_NO + "&FatherCode=" + ed.EncryptText("PAINT_COATING") + "";
break;
case 4:
((Label)Item.FindControl("lab_YS_NAME")).Text = "电气电料";
((Label)Item.FindControl("lab_YS_MAR_BG")).Text = dt_mar_amount.Rows[0][8].ToString();
((Label)Item.FindControl("lab_YS_MAR")).Text = dt_mar_amount.Rows[0][9].ToString();
((Label)Item.FindControl("lab_YS_MAR_Percent")).Text = dt_mar_amount.Rows[0][18].ToString() + "%";
((HyperLink)Item.FindControl("Hpl_detail")).NavigateUrl = "../YS_Data/YS_Cost_Budget_O_M_Detail.aspx?ContractNo=" + CONTRACT_NO + "&FatherCode=" + ed.EncryptText("ELECTRICAL") + "";
break;
case 5:
((Label)Item.FindControl("lab_YS_NAME")).Text = "其他材料费";
((Label)Item.FindControl("lab_YS_MAR_BG")).Text = dt_mar_amount.Rows[0][10].ToString();
((Label)Item.FindControl("lab_YS_MAR")).Text = dt_mar_amount.Rows[0][11].ToString();
((Label)Item.FindControl("lab_YS_MAR_Percent")).Text = dt_mar_amount.Rows[0][19].ToString() + "%";
((HyperLink)Item.FindControl("Hpl_detail")).NavigateUrl = "../YS_Data/YS_Cost_Budget_O_M_Detail.aspx?ContractNo=" + CONTRACT_NO + "&FatherCode=" + ed.EncryptText("OTHERMAT_COST") + "";
break;
case 6:
((Label)Item.FindControl("lab_YS_NAME")).Text = "合计";
((Label)Item.FindControl("lab_YS_MAR_BG")).Text = dt_mar_amount.Rows[0][12].ToString();
((Label)Item.FindControl("lab_YS_MAR")).Text = dt_mar_amount.Rows[0][13].ToString();
((Label)Item.FindControl("lab_YS_MAR_Percent")).Text = dt_mar_amount.Rows[0][20].ToString() + "%";
((HyperLink)Item.FindControl("Hpl_detail")).NavigateUrl = "";
((Label)Item.FindControl("check_look")).Text = "";
((Image)Item.FindControl("Image1")).Visible = false;
break;
default: break;
}
i++;
}
}
