public JsonResult save_jpxmcs(string[] zt, string[] qy, string [] kfs, string[] lpmc, string[] yt, string[] xfyt, string[] hx, string [] zlmjqj, int id)
{
if (zt != null || qy != null || kfs != null || lpmc != null || yt != null || xfyt != null || hx != null || zlmjqj != null)
{
JP_ParamValueModel param = new JP_ParamValueModel();
param.zt = zt;
param.qy = qy;
param.lpmc = lpmc;
param.kfs = kfs;
param.yt = yt;
param.xfyt = xfyt;
param.hx = hx;
param.zlmjqj = zlmjqj;
if (Param_DataProvider.SAVE_JP_JPXMCS(id, param))
{
return(Json(SResult.Success));
}
else
{
return(Json(SResult.Error("保存失败")));
}
}
else
{
return(Json(SResult.Error("竞品参数为空")));
}
}
/// <summary>
/// 通用成交备案数据查询接口
/// </summary>
/// <param name="nf"></param>
/// <param name="zc"></param>
/// <param name="zt"></param>
/// <param name="qy"></param>
/// <param name="lpmc"></param>
/// <param name="yt"></param>
/// <param name="xfyt"></param>
/// <param name="hx"></param>
/// <param name="pagesize"></param>
/// <param name="pagenow"></param>
/// <returns></returns>
public JsonResult cxjg(int nf, int zc, string[] zt, string[] qy, string[] kfs, string[] lpmc, string[] yt, string[] xfyt, string[] hx, int?pagesize, int?pagenow)
{
IPageList <Data_Cjba_Default> list = null;
if (zt != null || qy != null || kfs != null || lpmc != null || yt != null || xfyt != null || hx != null)
{
JP_ParamValueModel param = new JP_ParamValueModel();
param.zt = zt;
param.qy = qy;
param.kfs = kfs;
param.lpmc = lpmc;
param.yt = yt;
param.xfyt = xfyt;
param.hx = hx;
list = Param_DataProvider.GET_JP_CJBAXX(nf, zc, param, pagesize.HasValue ? pagesize.Value : 10, pagenow.HasValue ? pagenow.Value : 1);
}
else
{
list = Param_DataProvider.GET_JP_CJBAXX(nf, zc, pagesize.HasValue ? pagesize.Value : 10, pagenow.HasValue ? pagenow.Value : 1);
}
var s = new
{
pagenow = list.PageNumber,
datacount = list.TotalPageCount,
data = list
};
return(Json(s));
}
public static bool SAVE_JP_JPXMCS(int id, JP_ParamValueModel p)
{
string sql = @"update calculation.xtgl_param_jpgj set ztcs=@ztcs,qycs=@qycs,kfs=@kfs,lpcs=@lpcs,ytcs=@ytcs,xfytcs=@xfytcs,hxcs=@hxcs,zlmjqj=@zlmjqj where id=@id";
MySqlParameter[] par = { new MySqlParameter("id", id),
new MySqlParameter("ztcs", p.zt == null || p.zt.Count() == 0?"": string.Join(",", p.zt)),
new MySqlParameter("qycs", p.qy == null || p.qy.Count() == 0?"": string.Join(",", p.qy)),
new MySqlParameter("kfs", p.kfs == null || p.kfs.Count() == 0?"": string.Join(",", p.kfs)),
new MySqlParameter("lpcs", p.lpmc == null || p.lpmc.Count() == 0?"": string.Join(",", p.lpmc)),
new MySqlParameter("ytcs", p.yt == null || p.yt.Count() == 0?"": string.Join(",", p.yt)),
new MySqlParameter("xfytcs", p.xfyt == null || p.xfyt.Count() == 0?"": string.Join(",", p.xfyt)),
new MySqlParameter("hxcs", p.hx == null || p.hx.Count() == 0?"": string.Join(",", p.hx)),
new MySqlParameter("zlmjqj", p.zlmjqj == null || p.zlmjqj.Count() == 0?"": string.Join(",",p.zlmjqj)) };
return(MySqlDbhelper.ExecuteNonQuery(sql, par) > 0);
}
public static IPageList <Data_Cjba_Default> GET_JP_CJBAXX(int nf, int zc, JP_ParamValueModel param, int pagesize, int pagenow)
{
string sql = "select * from calculation.xtgl_data_zb_cjba where nf=@nf and zc=@zc";
string tempsql = "";
if (param.qy != null)
{
tempsql += " and qy in ('" + string.Join("','", param.qy) + "')";
}
if (param.kfs != null)
{
tempsql += " and kfs in ('" + string.Join("','", param.kfs) + "')";
}
if (param.zt != null)
{
tempsql += " and zt in ('" + string.Join("','", param.zt) + "')";
}
if (param.lpmc != null)
{
tempsql += " and lpmc in ('" + string.Join("','", param.lpmc) + "')";
}
if (param.yt != null)
{
tempsql += " and yt in ('" + string.Join("','", param.yt) + "')";
}
if (param.xfyt != null)
{
tempsql += " and xfyt in ('" + string.Join("','", param.xfyt) + "')";
}
if (param.hx != null)
{
tempsql += " and hx in ('" + string.Join("','", param.hx) + "')";
}
sql += tempsql;
MySqlParameter[] p = { new MySqlParameter("nf", nf), new MySqlParameter("zc", zc) };
return(MySqlDbhelper.GetPagedList <Data_Cjba_Default>(sql, p, pagesize, pagenow));
}