public PlanMarketingData DoGetValue(int year,double customer)
{
string sql = "SELECT ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '01' THEN GRANDTOT ELSE 0 END) M1, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '02' THEN GRANDTOT ELSE 0 END) M2, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '03' THEN GRANDTOT ELSE 0 END) M3, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '04' THEN GRANDTOT ELSE 0 END) M4, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '05' THEN GRANDTOT ELSE 0 END) M5, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '06' THEN GRANDTOT ELSE 0 END) M6, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '07' THEN GRANDTOT ELSE 0 END) M7, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '08' THEN GRANDTOT ELSE 0 END) M8, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '09' THEN GRANDTOT ELSE 0 END) M9, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '10' THEN GRANDTOT ELSE 0 END) M10, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '11' THEN GRANDTOT ELSE 0 END) M11, ";
sql += "SUM(CASE TO_CHAR(REQDATE,'MM') WHEN '12' THEN GRANDTOT ELSE 0 END) M12 ";
sql += "FROM REQUISITION ";
sql += "WHERE REQUISITIONTYPE = 11 AND CUSTOMER = " + customer.ToString()+ " AND TO_CHAR(REQDATE,'YYYY') = '" + year + "' ";
DataTable dt = OracleDB.ExecListCmd(sql);
PlanMarketingData data = new PlanMarketingData();
if (dt.Rows.Count > 0)
{
if (!Convert.IsDBNull(dt.Rows[0]["M1"])) data.M1 = Convert.ToDouble(dt.Rows[0]["M1"]);
if (!Convert.IsDBNull(dt.Rows[0]["M2"])) data.M2 = Convert.ToDouble(dt.Rows[0]["M2"]);
if (!Convert.IsDBNull(dt.Rows[0]["M3"])) data.M3 = Convert.ToDouble(dt.Rows[0]["M3"]);
if (!Convert.IsDBNull(dt.Rows[0]["M4"])) data.M4 = Convert.ToDouble(dt.Rows[0]["M4"]);
if (!Convert.IsDBNull(dt.Rows[0]["M5"])) data.M5 = Convert.ToDouble(dt.Rows[0]["M5"]);
if (!Convert.IsDBNull(dt.Rows[0]["M6"])) data.M6 = Convert.ToDouble(dt.Rows[0]["M6"]);
if (!Convert.IsDBNull(dt.Rows[0]["M7"])) data.M7 = Convert.ToDouble(dt.Rows[0]["M7"]);
if (!Convert.IsDBNull(dt.Rows[0]["M8"])) data.M8 = Convert.ToDouble(dt.Rows[0]["M8"]);
if (!Convert.IsDBNull(dt.Rows[0]["M9"])) data.M9 = Convert.ToDouble(dt.Rows[0]["M9"]);
if (!Convert.IsDBNull(dt.Rows[0]["M10"])) data.M10 = Convert.ToDouble(dt.Rows[0]["M10"]);
if (!Convert.IsDBNull(dt.Rows[0]["M11"])) data.M11 = Convert.ToDouble(dt.Rows[0]["M11"]);
if (!Convert.IsDBNull(dt.Rows[0]["M12"])) data.M12 = Convert.ToDouble(dt.Rows[0]["M12"]);
}
return data;
}
private void UpdatePlanMarketing(string userID, double loid,PlanMarketingData data, OracleTransaction trans)
{
bool ret = true;
DALItemObjMK.OnDB = false;
DALItemObjMK.GetDataByLOID(loid, trans);
//PlanMarketingData PMdata = new PlanMarketingData();
DALItemObjMK.PERCENT = data.PERCENT;
DALItemObjMK.M1 = data.M1;
DALItemObjMK.M2 = data.M2;
DALItemObjMK.M3 = data.M3;
DALItemObjMK.M4 = data.M4;
DALItemObjMK.M5 = data.M5;
DALItemObjMK.M6 = data.M6;
DALItemObjMK.M7 = data.M7;
DALItemObjMK.M8 = data.M8;
DALItemObjMK.M9 = data.M9;
DALItemObjMK.M10 = data.M10;
DALItemObjMK.M11 = data.M11;
DALItemObjMK.M12 = data.M12;
ret = DALItemObjMK.UpdateCurrentData(userID, trans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
public bool UpdateData(string userID, double loid, PlanMarketingData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
UpdatePlanMarketing(userID, loid, data, obj.zTrans);
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
protected void SaveClick(object sender, EventArgs e)
{
foreach (GridViewRow row in grvPlanitem.Rows)
{
string customer = row.Cells[2].Text.Trim();
double LOID = Convert.ToDouble(row.Cells[1].Text);
double percent = Convert.ToDouble(((TextBox)row.Cells[4].FindControl("txtPercent")).Text);
PlanMarketingData PMdata = new PlanMarketingData();
switch (customer)
{
case "1":
PMdata = FlowObj.DoGetValueFront(DateTime.Now.Year);
break;
case "-1":
PMdata = FlowObj.DoGetValueOther(DateTime.Now.Year);
break;
default:
PMdata = FlowObj.DoGetValue(DateTime.Now.Year, Convert.ToDouble(customer));
break;
}
PMdata.M1 += PMdata.M1 * percent / 100;
PMdata.M2 += PMdata.M2 * percent / 100;
PMdata.M3 += PMdata.M3 * percent / 100;
PMdata.M4 += PMdata.M4 * percent / 100;
PMdata.M5 += PMdata.M5 * percent / 100;
PMdata.M6 += PMdata.M6 * percent / 100;
PMdata.M7 += PMdata.M7 * percent / 100;
PMdata.M8 += PMdata.M8 * percent / 100;
PMdata.M9 += PMdata.M9 * percent / 100;
PMdata.M10 += PMdata.M10 * percent / 100;
PMdata.M11 += PMdata.M11 * percent / 100;
PMdata.M12 += PMdata.M12 * percent / 100;
PMdata.PERCENT = percent;
FlowObj.UpdateData(Authz.CurrentUserInfo.UserID, LOID, PMdata);
}
ResetState(Convert.ToDouble(Request["loid"] == null ? "0" : Request["loid"]));
Appz.ClientAlert(this, "ºÑ¹·Ö¡¢éÍÁÙÅàÃÕºÃéÍÂáÅéÇ");
}
