예제 #1
0
        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);
            }
        }
예제 #2
0
        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));
        }