private string SaveReward() { try { Qz_job_reward_list list = new Qz_job_reward_list(); list.OID = Post("OID"); if (list.OID == "") { list.OID = Guid.NewGuid().ToString(); } ds.RetrieveObject(list); list.SEQ_NO = Get("seq_no"); //list.REWARD_STD = comTran.ToDecimal(Post("REWARD_STD")); //list.QUANTITY = comTran.ToDecimal(Post("QUANTITY")); list.REAL_AMOUNT = comTran.ToDecimal(Post("REAL_AMOUNT")); ds.UpdateObject(list); string total_real_amount = JobRewardHandleClass.getInstance().CalculateRealAmount(list.SEQ_NO).ToString(); return(total_real_amount); } catch (Exception ex) { return(string.Empty); } }
private string GetData() { DataTable dt = null; if (string.IsNullOrEmpty(Get("id"))) { return("{}"); } dt = ds.ExecuteTxtDataTable(string.Format("SELECT *, EMPLOYER EMPLOYER2, JOB_SEQ_NO JOB_NAME, '' TOTAL_REAL_AMOUNT FROM QZ_JOB_REWARD_HEAD WHERE OID = '{0}' ", Get("id"))); if (dt == null || dt.Rows.Count == 0) { return("{}"); } var ddl = new Hashtable(); ddl.Add("EMPLOYER2", "ddl_all_department"); ddl.Add("JOB_NAME", "ddl_job_name"); cod.ConvertTabDdl(dt, ddl); dt.Rows[0]["TOTAL_REAL_AMOUNT"] = JobRewardHandleClass.getInstance().CalculateRealAmount(Get("seq_no")).ToString(); return(Json.DatatableToJson(dt)); }