/// <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));
}
