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, "ºÑ¹·Ö¡¢éÍÁÙÅàÃÕºÃéÍÂáÅéÇ"); }