public string AddSpxx([FromBody] SpxxModel model)
{
Result <string> result = new Result <string>();
try
{
if (spxxManage.AddSpxx(model))
{
result.status = 1;
result.msg = "添加成功！";
}
else
{
result.status = 0;
result.msg = "添加失败！";
}
}
catch (Exception ex)
{
result.status = 0;
result.msg = "信息异常！商品信息新增：" + ex.Message;
LogHelper.WriteLog(this.GetType(), "商品信息新增出错了！错误信息：" + ex.Message, LogHelper.logLevel.ERROR);
}
return(JsonHelper.ConvertToJosnString(result));
}
/// <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;
}
}
public bool AddSpxx(SpxxModel model)
{
try
{
return(spxxServices.AddSpxx(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加商品信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddSpxx(SpxxModel model)
{
StringBuilder strSql = new StringBuilder();
try
{
strSql.Append("INSERT INTO tbl_Spxx(");
strSql.Append("spId,");
strSql.Append("spName,");
strSql.Append("spHPH,");
strSql.Append("spCPRQ,");
strSql.Append("spHPDQR,");
strSql.Append("spCPRQC,");
strSql.Append("spPJJE,");
strSql.Append("spCDRQC,");
strSql.Append("IsKZR,");
strSql.Append("spPJZT,");
strSql.Append("spSPRQC,");
strSql.Append("spCPRCN,");
strSql.Append("spCDRCN,");
strSql.Append("IsBLJ,");
strSql.Append("spPMFS,");
strSql.Append("spQPJ,");
strSql.Append("spJJFD,");
strSql.Append("spPMKSSJ,");
strSql.Append("spPMJSSJ,");
strSql.Append("spMS,");
strSql.Append("spFKFS,");
strSql.Append("spUrl,");
strSql.Append("spBZJYQ,");
strSql.Append("spPJGY)");
strSql.Append(" VALUES(");
strSql.Append("@spId,");
strSql.Append("@spName,");
strSql.Append("@spHPH,");
strSql.Append("@spCPRQ,");
strSql.Append("@spHPDQR,");
strSql.Append("@spCPRQC,");
strSql.Append("@spPJJE,");
strSql.Append("@spCDRQC,");
strSql.Append("@IsKZR,");
strSql.Append("@spPJZT,");
strSql.Append("@spSPRQC,");
strSql.Append("@spCPRCN,");
strSql.Append("@spCDRCN,");
strSql.Append("@IsBLJ,");
strSql.Append("@spPMFS,");
strSql.Append("@spQPJ,");
strSql.Append("@spJJFD,");
strSql.Append("@spPMKSSJ,");
strSql.Append("@spPMJSSJ,");
strSql.Append("@spMS,");
strSql.Append("@spFKFS,");
strSql.Append("@spUrl,");
strSql.Append("@spBZJYQ,");
strSql.Append("@spPJGY)");
#region 参数
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@spId", DbType.String)
{
Value = System.Guid.NewGuid().ToString().Replace("-", "")
},
new SqlParameter("@spName", SqlDbType.VarChar, 50)
{
Value = model.SpName
},
new SqlParameter("@spHPH", SqlDbType.VarChar, 50)
{
Value = model.SpHPH
},
new SqlParameter("@spCPRQ", SqlDbType.DateTime, 8)
{
Value = model.SpCPRQ
},
new SqlParameter("@spHPDQR", SqlDbType.DateTime, 8)
{
Value = model.SpHPDQR
},
new SqlParameter("@spCPRQC", SqlDbType.VarChar, 50)
{
Value = model.SpCPRQC
},
new SqlParameter("@spPJJE", SqlDbType.Decimal)
{
Value = model.SpPJJE
},
new SqlParameter("@spCDRQC", SqlDbType.VarChar, 50)
{
Value = model.SpCDRQC
},
new SqlParameter("@IsKZR", SqlDbType.Int)
{
Value = model.IsKZR
},
new SqlParameter("@spPJZT", SqlDbType.Int)
{
Value = model.SpPJZT
},
new SqlParameter("@spSPRQC", SqlDbType.VarChar, 50)
{
Value = model.SpSPRQC
},
new SqlParameter("@spCPRCN", SqlDbType.Int)
{
Value = model.SpCPRCN
},
new SqlParameter("@spCDRCN", SqlDbType.Int)
{
Value = model.SpCDRCN
},
new SqlParameter("@IsBLJ", SqlDbType.Int)
{
Value = model.IsBLJ
},
new SqlParameter("@spPMFS", SqlDbType.Int)
{
Value = model.SpPMFS
},
new SqlParameter("@spQPJ", SqlDbType.VarChar, 50)
{
Value = model.SpQPJ
},
new SqlParameter("@spJJFD", SqlDbType.Int)
{
Value = model.SpJJFD
},
new SqlParameter("@spPMKSSJ", SqlDbType.DateTime, 8)
{
Value = model.SpPMKSSJ
},
new SqlParameter("@spPMJSSJ", SqlDbType.DateTime, 8)
{
Value = model.SpPMJSSJ
},
new SqlParameter("@spMS", SqlDbType.VarChar, 200)
{
Value = model.SpMS
},
new SqlParameter("@spFKFS", SqlDbType.Int)
{
Value = model.SpFKFS
},
new SqlParameter("@spUrl", SqlDbType.VarChar, 50)
{
Value = model.SpUrl
},
new SqlParameter("@spBZJYQ", SqlDbType.VarChar, 50)
{
Value = model.SpBZJYQ
},
new SqlParameter("@spPJGY", SqlDbType.VarChar, 50)
{
Value = model.SpPJGY
}
};
#endregion
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters.ToArray()) > 0);
}
catch (Exception ex)
{
throw ex;
}
}
