public AjaxResult CheckStdCodeRemark([FromBody] dynamic Json)
{
AjaxResult result = new AjaxResult();
Bll_TQB_REMARKPRINT tmd = new Bll_TQB_REMARKPRINT();
DataSet ds = new DataSet();
string str = Json.stdcode;
string flaNo = Json.flaNo;
string grd = Json.stlgrd; //钢种
string stdCode = Json.stdcode; //执行标准
string fyd = Json.fyd; //发运单号
string spec = Json.spec; //规格
if (!string.IsNullOrEmpty(str))
{
string stdgrd = str.Trim() + "+" + grd.Trim();
ds = tmd.GetList(" and UPPER(REPLACE(C_KEY,' ','')) = '" + stdgrd.ToUpper() + "'");
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
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 + "'";
var dsPatch = tmd_dispatch.GetRePrintList(strWhere);
if (dsPatch != null && dsPatch.Tables[0].Rows.Count > 0)
{
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(2);
}
else
{
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(1);
}
}
else
{
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(2);
}
return(result);
}
public AjaxResult GetRemarkddl([FromBody] dynamic Json)
{
AjaxResult result = new AjaxResult();
Bll_TQB_REMARKPRINT tmd = new Bll_TQB_REMARKPRINT();
var strWhere = "";
string type = Json.type;
if (type != "")
{
strWhere += " and N_TYPE=" + type;
}
DataTable dt = tmd.GetList(strWhere).Tables[0];
if (dt.Rows.Count > 0)
{
result.Code = DoResult.Success;
result.Result = JsonConvert.SerializeObject(dt);
}
else
{
result.Code = DoResult.Failed;
}
return(result);
}