public AjaxResult SaveWWZZH([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_ZZS_REPRINT();
#region 参数
string strWhere = " and t.C_TYPE=2 and t.C_SPEC='" + Json.spec + "' and t.C_STL_GRD='" + Json.stlgrd
+ "' and t.C_STD_CODE='" + Json.stdcode + "' and t.C_DISPATCH_ID='" + Json.fyd + "' and t.C_LIC_PLA_NO='" + Json.flaNo + "'";
DataTable dt = tmd_dispatch.GetRePrintList(strWhere).Tables[0];
if (dt.Rows.Count > 0)
{
mod.C_certificate_no = dt.Rows[0]["c_certificate_no"].ToString();
mod.C_attestor = dt.Rows[0]["c_attestor"].ToString();
mod.D_visa_dt = DateTime.Parse(dt.Rows[0]["d_visa_dt"].ToString());
}
else
{
mod = new Mod_TMD_ZZS_REPRINT()
{
C_lic_pla_no = Json.flaNo,
C_stl_grd = Json.stlgrd, //钢种
C_std_code = Json.stdcode, //执行标准
C_dispatch_id = Json.fyd, //发运单号
C_spec = Json.spec, //规格
C_attestor = Json.empname, //签证人
C_print_templates = Json.mb, //模板
C_print_type = Json.printType, //打印
C_certificate_no = Json.zsNo,
D_mod_dt = DateTime.Now,
D_visa_dt = Json.visTime,
C_remark = Json.bz,
N_status = 1,
N_type = 2,
C_emp_id = vUser.Name
};
tmd_dispatch.AddRePrint(mod);
}
#endregion
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(mod);
return(result);
}
/// <summary>
/// 添加打印批号
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddRePrint(Mod_TMD_ZZS_REPRINT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"insert into tmd_zzs_reprint (
c_certificate_no,
c_attestor,
d_visa_dt,
c_print_type,
c_print_templates,
n_status,
c_remark,
c_emp_id,
d_mod_dt,
c_spec,
c_stl_grd,
c_std_code,
c_dispatch_id,
c_lic_pla_no,
C_TYPE)
values(
:c_certificate_no,
:c_attestor,
:d_visa_dt,
:c_print_type,
:c_print_templates,
:n_status,
:c_remark,
:c_emp_id,
:d_mod_dt,
:c_spec,
:c_stl_grd,
:c_std_code,
:c_dispatch_id,
:c_lic_pla_no,
:C_TYPE )");
OracleParameter[] parameters =
{
new OracleParameter(":c_certificate_no", OracleDbType.Varchar2, 100),
new OracleParameter(":c_attestor", OracleDbType.Varchar2, 100),
new OracleParameter(":d_visa_dt", OracleDbType.Date),
new OracleParameter(":c_print_type", OracleDbType.Varchar2, 100),
new OracleParameter(":c_print_templates", OracleDbType.Varchar2, 100),
new OracleParameter(":n_status", OracleDbType.Decimal, 1),
new OracleParameter(":c_remark", OracleDbType.Varchar2, 500),
new OracleParameter(":c_emp_id", OracleDbType.Varchar2, 100),
new OracleParameter(":d_mod_dt", OracleDbType.Date),
new OracleParameter(":c_spec", OracleDbType.Varchar2, 100),
new OracleParameter(":c_stl_grd", OracleDbType.Varchar2, 100),
new OracleParameter(":c_std_code", OracleDbType.Varchar2, 100),
new OracleParameter(":c_dispatch_id", OracleDbType.Varchar2, 100),
new OracleParameter(":c_lic_pla_no", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TYPE", OracleDbType.Decimal, 1)
};
parameters[0].Value = model.C_certificate_no;
parameters[1].Value = model.C_attestor;
parameters[2].Value = model.D_visa_dt;
parameters[3].Value = model.C_print_type;
parameters[4].Value = model.C_print_templates;
parameters[5].Value = model.N_status;
parameters[6].Value = model.C_remark;
parameters[7].Value = model.C_emp_id;
parameters[8].Value = model.D_mod_dt;
parameters[9].Value = model.C_spec;
parameters[10].Value = model.C_stl_grd;
parameters[11].Value = model.C_std_code;
parameters[12].Value = model.C_dispatch_id;
parameters[13].Value = model.C_lic_pla_no;
parameters[14].Value = model.N_type;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public AjaxResult GetZZH([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 zsNo = "";
var mod = new Mod_TMD_ZZS_REPRINT();
#region 参数
string strWhere = " and t.C_TYPE=1 and t.C_SPEC='" + Json.spec + "' and t.C_STL_GRD='" + Json.stlgrd
+ "' and t.C_STD_CODE='" + Json.stdcode + "' and t.C_DISPATCH_ID='" + Json.fyd + "' and t.C_LIC_PLA_NO='" + Json.flaNo + "'";
DataTable dt = tmd_dispatch.GetRePrintList(strWhere).Tables[0];
if (dt.Rows.Count > 0)
{
mod.C_certificate_no = dt.Rows[0]["c_certificate_no"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["C_REMARK"].ToString()) || string.IsNullOrEmpty(dt.Rows[0]["C_REMARK"].ToString()) && dt.Rows[0]["N_UPDATE"].ToString() == "0")
{
mod.C_remark = dt.Rows[0]["C_REMARK"].ToString();
}
// 如果之前加过记录且备注信息为空 状态是修改，则修改备注信息
else if (dt.Rows[0]["N_UPDATE"].ToString() == "1" && string.IsNullOrEmpty(dt.Rows[0]["C_REMARK"].ToString()))
{
string strBz = Json.bz;
mod.C_remark = strBz;
tmd_dispatch.UpdateReprintRemark(strWhere, strBz);
}
}
else
{
zsNo = randomnumber.GetZZS();
mod = new Mod_TMD_ZZS_REPRINT()
{
C_lic_pla_no = Json.flaNo,
C_stl_grd = Json.stlgrd, //钢种
C_std_code = Json.stdcode, //执行标准
C_dispatch_id = Json.fyd, //发运单号
C_spec = Json.spec, //规格
C_attestor = Json.empname, //签证人
C_print_templates = Json.mb, //模板
C_print_type = Json.printType, //打印
C_certificate_no = zsNo,
D_mod_dt = DateTime.Now,
D_visa_dt = DateTime.Now,
C_remark = Json.bz,
N_status = 1,
N_type = 1,
C_emp_id = vUser.Name
};
if (!string.IsNullOrEmpty(mod.C_attestor))
{
tmd_dispatch.AddRePrint(mod);
}
}
string strCKDWhere = " and t.C_DISPATCH_ID='" + Json.fyd + "'";
DataTable dtCKDPrint = tmd_dispatch.GetCKDRePrintList(strCKDWhere).Tables[0];
if (dtCKDPrint.Rows.Count > 0)
{
mod.C_attestor = dtCKDPrint.Rows[0]["c_attestor"].ToString();
mod.D_visa_dt = DateTime.Parse(dtCKDPrint.Rows[0]["d_visa_dt"].ToString());
}
else
{
mod.C_attestor = Json.empname;
mod.D_visa_dt = DateTime.Now;
}
#endregion
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(mod);
return(result);
}
/// <summary>
/// 添加打印批号
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddRePrint(Mod_TMD_ZZS_REPRINT model)
{
return(dal.AddRePrint(model));
}
