public ActionResult Insert_T12033(t12033 t12033) { var user = Session["T_EMP_CODE"].ToString(); var data = repository.Insert_T12033(t12033, user); string JSONString = string.Empty; JSONString = JsonConvert.SerializeObject(data); return(Json(JSONString, JsonRequestBehavior.AllowGet)); }
public string Insert_T12033(t12033 t12033, string user) { //var Data = obj.Insert_T12033(t12033, user); //return Data; var data = ""; try { data = obj.Insert_T12033(t12033, user); } catch (Exception e) { MethodBase m = MethodBase.GetCurrentMethod(); obj.Log(m.ReflectedType.Name + "." + m.Name, "1", e.Message); } return(data); }
public string Insert_T12033(t12033 t12033, string user) { string msg = ""; int count = Query($"SELECT T_VIRUS_CODE FROM T12033 WHERE T_VIRUS_CODE = '{t12033.T_VIRUS_CODE}'").Rows.Count; var max = Query($"select lpad((MAX(T_VIRUS_CODE)+1),2,'0') T_VIRUS_CODE FROM T12033"); var maxviruscode = max.Rows[0]["T_VIRUS_CODE"]; BeginTransaction(); if (count == 0) { if (Command($"INSERT INTO T12033 (T_ENTRY_USER,T_ENTRY_DATE,T_VIRUS_CODE,T_LANG2_NAME,T_LANG1_NAME,T_PN,T_ACTIVE) VALUES ('{user}', TRUNC(SYSDATE), '{maxviruscode}', '{t12033.T_LANG2_NAME}', '{t12033.T_LANG1_NAME}', '{t12033.T_PN}','{t12033.T_ACTIVE}')")) { CommitTransaction(); msg = "N0040"; } else { RollbackTransaction(); msg = "N0071"; } } else { if (Command( $"UPDATE T12033 SET T_UPD_USER='******',T_UPD_DATE=TRUNC(SYSDATE),T_LANG2_NAME='{t12033.T_LANG2_NAME}',T_LANG1_NAME='{t12033.T_LANG1_NAME}',T_PN='{t12033.T_PN}',T_ACTIVE='{t12033.T_ACTIVE}' WHERE T_VIRUS_CODE='{t12033.T_VIRUS_CODE}' ")) { CommitTransaction(); msg = "N0041"; } else { RollbackTransaction(); msg = "N0072"; } } return(msg); }