/// <summary> /// 添加打印批号 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddCKDPrint(Mod_TMD_CKD_REPRINT model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"insert into tmd_ckd_reprint ( c_dispatch_id, c_attestor, d_visa_dt, n_status, c_type) values( :c_dispatch_id, :c_attestor, :d_visa_dt, :n_status, :C_TYPE )"); OracleParameter[] parameters = { new OracleParameter(":c_dispatch_id", OracleDbType.Varchar2, 100), new OracleParameter(":c_attestor", OracleDbType.Varchar2, 100), new OracleParameter(":d_visa_dt", OracleDbType.Date), new OracleParameter(":n_status", OracleDbType.Decimal, 1), new OracleParameter(":C_TYPE", OracleDbType.Decimal, 1) }; parameters[0].Value = model.C_dispatch_id; parameters[1].Value = model.C_attestor; parameters[2].Value = model.D_visa_dt; parameters[3].Value = model.N_status; parameters[4].Value = model.N_type; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public AjaxResult SaveCKDPrint([FromBody] dynamic Json) { AjaxResult result = new AjaxResult(); var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"]; if (vUser == null) { result.Code = DoResult.OverTime; result.Result = JsonConvert.SerializeObject(""); return(result); } var mod = new Mod_TMD_CKD_REPRINT(); mod = new Mod_TMD_CKD_REPRINT() { C_dispatch_id = Json.fyd, C_attestor = Json.empname,//签证人 D_visa_dt = DateTime.Now, N_status = 1, N_type = 1 }; if (!string.IsNullOrEmpty(mod.C_attestor)) { var ds = tmd_dispatch.ListPrintFyd(mod.C_dispatch_id); if (ds.Tables[0].Rows.Count == 0) { tmd_dispatch.AddCKDPrint(mod); } else { mod.C_attestor = ds.Tables[0].Rows[0]["C_ATTESTOR"].ToString(); mod.D_visa_dt = DateTime.Parse(ds.Tables[0].Rows[0]["D_VISA_DT"].ToString()); } } result.Code = DoResult.Success; result.Result = JsonConvert.SerializeObject(mod); return(result); }
public bool AddCKDPrint(Mod_TMD_CKD_REPRINT model) { return(dal.AddCKDPrint(model)); }