public string SaveData(M12281 t12281, string lang, string user) { //var Data = obj.SaveData(t12281, user,lang); //return Data; var data = ""; try { data = obj.SaveData(t12281, user, lang); } catch (Exception e) { MethodBase m = MethodBase.GetCurrentMethod(); obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message); } return(data); //string msg = ""; //obj.BeginTransaction(); //if (obj.InsertT12281(t12281, user)) //{ // obj.CommitTransaction(); // msg = obj.GetUserMsg("N0040", "LANG" + lang); //} //return msg; }
public ActionResult SaveData(M12281 t12281) { var lang = Session["T_LANG"].ToString(); var user = Session["T_EMP_CODE"].ToString(); var data = repository.SaveData(t12281, lang, user); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(data); return(Json(JSONString, JsonRequestBehavior.AllowGet)); }
public string SaveData(M12281 t12281, string user, string lang) { string msg = ""; int count = 0; var collection = Query($"SELECT (SELECT MAX(CASE WHEN T_WEIGHT_CODE = '{t12281.T_WEIGHT_CODE}' AND T_ACTION ='{t12281.T_ACTION}' THEN '1' ELSE '0' END) FROM t12081)COLLECTION from dual").Rows[0]["COLLECTION"].ToString(); BeginTransaction(); if (collection == "0") { Command("INSERT INTO T12081(T_ENTRY_DATE,T_ENTRY_USER, T_WEIGHT_CODE, T_LANG2_NAME,T_WEIGHT_FR,T_WEIGHT_TO,T_WEIGHT_GM,T_WEIGHT_GMT,T_DISCARD_REASON_CODE,T_ACTION)" + $" VALUES (SYSDATE, '{user}', '{t12281.T_WEIGHT_CODE}','{t12281.T_WEIGHT_NAME}','{t12281.T_WEIGHT_FR}','{t12281.T_WEIGHT_TO}','{t12281.T_WEIGHT_GM}','{t12281.T_WEIGHT_GMT}','{t12281.T_DISCARD_REASON_CODE}','{t12281.T_ACTION}')"); // CommitTransaction(); count = 1; msg = GetUserMsg("N0040", "LANG" + lang); } else { Command($"UPDATE T12081 SET T_UPD_DATE=SYSDATE,T_UPD_USER='******',T_LANG2_NAME = '{t12281.T_WEIGHT_NAME}',T_WEIGHT_FR='{t12281.T_WEIGHT_FR}',T_WEIGHT_TO='{t12281.T_WEIGHT_TO}',T_WEIGHT_GM ='{t12281.T_WEIGHT_GMT}',T_WEIGHT_GMT='{t12281.T_WEIGHT_GMT}'," + $"T_DISCARD_REASON_CODE='{t12281.T_DISCARD_REASON_CODE}' WHERE T_ACTION='{t12281.T_ACTION}' AND T_WEIGHT_CODE = '{t12281.T_WEIGHT_CODE}'"); // CommitTransaction(); count = 1; msg = GetUserMsg("N0041", "LANG" + lang); } if (count == 1) { CommitTransaction(); } else { RollbackTransaction(); } return(msg); // Command($"INSERT INTO T12075(T_ENTRY_DATE, T_UNIT_NO, T_SEGMENT_NO,T_BLD_STORE_ID,T_DONATION_DATE)" // + $" VALUES (SYSDATE, '{t12022.T_UNIT_NO}', '{t12022.T_SEGMENT_NO}','{storeId}',SYSDATE)"); // Command($"UPDATE T12035 SET T_SEQ_NO = '{t12022.T_SEQ_NO}' WHERE T_HOSPITAL ='1' AND T_WS_CODE = '12'"); }