/// <summary>
/// 获取单个商品信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public SpxxModel GetSpxxDetailById(string spId)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select spId,spName,spHPH,spCPRQ,spCPRQC,spHPDQR,spPJJE,spCDRQC,IsKZR,spPJZT,spSPRQC,spCPRCN,spCDRCN,IsBLJ,spPMFS,spQPJ,spJJFD,spPMKSSJ,spPMJSSJ,spMS,spFKFS,spUrl,spBZJYQ,spPJGY,AddTime,IsDel from tbl_Spxx ");
strSql.Append(" where spId=@spId and IsDel <> '1'");
SqlParameter[] parameters =
{
new SqlParameter("@spId", SqlDbType.Char, 32)
};
parameters[0].Value = spId;
SpxxModel model = new SpxxModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(ModelEx.SetValueFromDB <SpxxModel>(model, ds.Tables[0]));
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="userName"></param>
/// <param name="passWord"></param>
/// <returns></returns>
public UserModel GetSysUser(string userName, string passWord)
{
string strSql = "select * from tbl_User Where IsDel <> '1'";
try
{
if (!string.IsNullOrWhiteSpace(userName))
{
strSql += " and UserName = '******'";
}
if (!string.IsNullOrWhiteSpace(passWord))
{
strSql += " and PassWord = '******'";
}
return(ModelEx.SetValueFromDB <UserModel>(new UserModel(), DbHelperSQL.Query(strSql).Tables[0]));
}
catch (Exception ex)
{
throw ex;
}
}
public string QuerySpxxListByPage([FromBody] SpxxReq req)
{
Result <ResultData <SpxxRes> > result = new Result <ResultData <SpxxRes> >();
try
{
DataTable dt = spxxManage.GetListByPage(req, string.Empty, req.rows, req.page);
ResultData <SpxxRes> data = new ResultData <SpxxRes>();
data.total = spxxManage.GetRecordCount(req);
data.rows = ModelEx.SetListValueFromDB <SpxxRes>(new List <SpxxRes>(), dt);
result.status = 1;
result.data = data;
}
catch (Exception ex)
{
result.status = 0;
result.msg = "信息异常!查询商品信息：" + ex.Message;
LogHelper.WriteLog(this.GetType(), "查询部门信息列表出错了！错误信息：" + ex.Message, LogHelper.logLevel.ERROR);
}
return(JsonHelper.ConvertToJosnString(result));
}
