/// <summary>
/// 积分商品修改，返回1成功，其它失败
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdateJiFenShangPin(EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo info)
{
if (info == null ||
string.IsNullOrEmpty(info.CompanyId) ||
string.IsNullOrEmpty(info.OperatorId) ||
info.FangShis == null ||
info.FangShis.Count == 0 ||
string.IsNullOrEmpty(info.ShangPinId))
{
return(0);
}
info.IssueTime = DateTime.Now;
int dalRetCode = dal.JiFenShangPin_CU(info);
return(dalRetCode);
}
/// <summary>
/// 积分商品新增、修改，返回1成功，其它失败
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int JiFenShangPin_CU(EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo info)
{
DbCommand cmd = _db.GetStoredProcCommand("proc_YL_JiFenShangPin_CU");
_db.AddInParameter(cmd, "@ShangPinId", DbType.AnsiStringFixedLength, info.ShangPinId);
_db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, info.CompanyId);
_db.AddInParameter(cmd, "@MingCheng", DbType.String, info.MingCheng);
_db.AddInParameter(cmd, "@ShuoMing", DbType.String, info.ShuoMing);
_db.AddInParameter(cmd, "@XuZhi", DbType.String, info.XuZhi);
_db.AddInParameter(cmd, "@OperatorId", DbType.AnsiStringFixedLength, info.OperatorId);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime);
_db.AddInParameter(cmd, "@FuJianXml", DbType.String, CreateFuJianXml(info.FuJians));
_db.AddInParameter(cmd, "@FangShiXml", DbType.String, CreateJiFenShangPinFangShiXml(info.FangShis));
_db.AddInParameter(cmd, "@PeiSongFangShi", DbType.String, info.PeiSongFangShi);
_db.AddInParameter(cmd, "@Status", DbType.Byte, info.Status);
_db.AddInParameter(cmd, "@ShuLiang", DbType.Int32, info.ShuLiang);
_db.AddInParameter(cmd, "@FaPiaoKuaiDiJinE", DbType.Decimal, info.FaPiaoKuaiDiJinE);
_db.AddInParameter(cmd, "@ShangPinJinE", DbType.Decimal, info.ShangPinJinE);
_db.AddOutParameter(cmd, "RetCode", DbType.Int32, 4);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
else
{
return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")));
}
}
/// <summary>
/// 获取积分商品信息
/// </summary>
/// <param name="shangPinId">商品编号</param>
/// <returns></returns>
public EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo GetJiFenShangPinInfo(string shangPinId)
{
EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo info = null;
DbCommand cmd = _db.GetSqlStringCommand(SQL_SELECT_GetJiFenShangPinInfo);
_db.AddInParameter(cmd, "@ShangPinId", DbType.AnsiStringFixedLength, shangPinId);
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
info = new EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo();
info.CompanyId = rdr["CompanyId"].ToString();
info.FangShis = null;
info.FuJians = null;
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.MingCheng = rdr["MingCheng"].ToString();
info.OperatorId = rdr["OperatorId"].ToString();
info.ShangPinId = rdr["ShangPinId"].ToString();
info.ShuoMing = rdr["ShuoMing"].ToString();
info.XuZhi = rdr["XuZhi"].ToString();
info.PeiSongFangShi = rdr["PeiSongFangShi"].ToString();
info.Status = (EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus)rdr.GetByte(rdr.GetOrdinal("Status"));
info.ShuLiang = rdr.GetInt32(rdr.GetOrdinal("ShuLiang"));
info.ChengJiaoShuLiang = rdr.GetInt32(rdr.GetOrdinal("ChengJiaoShuLiang"));
info.FaPiaoKuaiDiJinE = rdr.GetDecimal(rdr.GetOrdinal("FaPiaoKuaiDiJinE"));
info.ShangPinJinE = rdr.GetDecimal(rdr.GetOrdinal("ShangPinJinE"));
}
}
if (info != null)
{
info.FangShis = GetJiFenShangPinFangShis(info.ShangPinId);
info.FuJians = GetJiFenShangPinFuJians(info.ShangPinId);
}
return(info);
}
/// <summary>
/// baocun
/// </summary>
void BaoCun()
{
var info = new EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo();
info.CompanyId = CurrentUserCompanyID;
info.FangShis = new List <EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo>();
info.FuJians = null;
info.IssueTime = DateTime.Now;
info.MingCheng = Utils.GetFormValue(txtMingCheng.UniqueID);
info.OperatorId = SiteUserInfo.UserId;
info.PeiSongFangShi = Utils.GetFormValue(txtPeiSongFangShi.UniqueID);
info.ShangPinId = ShangPinId;
info.ShuoMing = Utils.GetYlEditorText(Request.Form[txtShuoMing.UniqueID]);
info.Status = Utils.GetEnumValue <EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus>(Utils.GetFormValue("txtStatus"), EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus.架);
info.XuZhi = Utils.GetYlEditorText(Request.Form[txtXuZhi.UniqueID]);
info.ShuLiang = Utils.GetInt(Utils.GetFormValue(txtShuLiang.UniqueID));
info.FaPiaoKuaiDiJinE = Utils.GetDecimal(Utils.GetFormValue(txtFaPiaoKuaiDiJinE.UniqueID));
info.ShangPinJinE = Utils.GetDecimal(Utils.GetFormValue(txtShangPinJinE.UniqueID));
var items1 = upload1.Files;
var items2 = upload1.YuanFiles;
var items3 = new List <EyouSoft.Model.YlStructure.MFuJianInfo>();
if (items1 != null && items1.Count > 0)
{
foreach (var item in items1)
{
var item1 = new EyouSoft.Model.YlStructure.MFuJianInfo();
item1.Filepath = item.FilePath;
items3.Add(item1);
}
}
if (items2 != null && items2.Count > 0)
{
foreach (var item in items2)
{
var item1 = new EyouSoft.Model.YlStructure.MFuJianInfo();
item1.Filepath = item.FilePath;
items3.Add(item1);
}
}
info.FuJians = items3;
var fangShi1 = new EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo();
var fangShi2 = new EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo();
var fangShi3 = new EyouSoft.Model.YlStructure.MWzJiFenShangPinFangShiInfo();
decimal jiFen1 = Utils.GetDecimal(Utils.GetFormValue(txtJiFen1.UniqueID));
//decimal jiFen2 = Utils.GetDecimal(Utils.GetFormValue(txtJiFen2.UniqueID));
decimal jiFen3 = Utils.GetDecimal(Utils.GetFormValue(txtJiFen3.UniqueID));
//decimal jinE2 = Utils.GetDecimal(Utils.GetFormValue(txtJinE2.UniqueID));
decimal jinE3 = Utils.GetDecimal(Utils.GetFormValue(txtJinE3.UniqueID));
if (jiFen1 > 0)
{
fangShi1.FangShi = EyouSoft.Model.EnumType.YlStructure.JiFenDuiHuanFangShi.积分;
fangShi1.JiFen = jiFen1;
info.FangShis.Add(fangShi1);
}
/*if (jiFen2 > 0 || jinE2 > 0)
* {
* fangShi2.FangShi = EyouSoft.Model.EnumType.YlStructure.JiFenDuiHuanFangShi.积分礼品卡;
* fangShi2.JiFen = jiFen2;
* fangShi2.JinE = jinE2;
*
* info.FangShis.Add(fangShi2);
* }*/
if (jiFen3 > 0 || jinE3 > 0)
{
fangShi3.FangShi = EyouSoft.Model.EnumType.YlStructure.JiFenDuiHuanFangShi.积分现金;
fangShi3.JiFen = jiFen3;
fangShi3.JinE = jinE3;
info.FangShis.Add(fangShi3);
}
if (info.FangShis.Count == 0)
{
RCWE(UtilsCommons.AjaxReturnJson("0", "请填写积分兑换方式"));
}
int bllRetCode = 0;
if (string.IsNullOrEmpty(ShangPinId))
{
bllRetCode = new EyouSoft.BLL.YlStructure.BDuiHuan().InsertJiFenShangPin(info);
}
else
{
bllRetCode = new EyouSoft.BLL.YlStructure.BDuiHuan().UpdateJiFenShangPin(info);
}
if (bllRetCode == 1)
{
RCWE(UtilsCommons.AjaxReturnJson("1", "操作成功"));
}
else
{
RCWE(UtilsCommons.AjaxReturnJson("0", "操作失败"));
}
}
/// <summary>
/// 获取积分商品信息集合
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo> GetJiFenShangPins(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MWzJiFenShangPinChaXunInfo chaXun)
{
IList <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo> items = new List <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo>();
string tableName = "view_YL_JiFenShangPin";
string fields = "*";
string orderByString = "IssueTime DESC";
string sumString = string.Empty;
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" CompanyId='{0}' ", companyId);
if (chaXun != null)
{
switch (chaXun.PaiXu)
{
case 0: orderByString = "JiFen DESC"; break;
case 1: orderByString = "JiFen ASC"; break;
case 2: orderByString = "LiPinKaJinE DESC"; break;
case 3: orderByString = "LiPinKaJinE ASC"; break;
case 4: orderByString = "XianJinJinE DESC"; break;
case 5: orderByString = "XianJinJinE ASC"; break;
case 6: orderByString = "IssueTime DESC"; break;
case 7: orderByString = "IssueTime ASC"; break;
default: orderByString = "IssueTime DESC"; break;
}
if (!string.IsNullOrEmpty(chaXun.MingCheng))
{
sql.AppendFormat(" AND MingCheng LIKE '%{0}%' ", chaXun.MingCheng);
}
if (chaXun.Status.HasValue)
{
sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value);
}
}
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo();
info.CompanyId = rdr["CompanyId"].ToString();
info.FangShis = null;
info.FuJians = null;
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.MingCheng = rdr["MingCheng"].ToString();
info.OperatorId = rdr["OperatorId"].ToString();
info.ShangPinId = rdr["ShangPinId"].ToString();
info.ShuoMing = rdr["ShuoMing"].ToString();
info.XuZhi = rdr["XuZhi"].ToString();
info.Status = (EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus)rdr.GetByte(rdr.GetOrdinal("Status"));
info.ShuLiang = rdr.GetInt32(rdr.GetOrdinal("ShuLiang"));
info.ChengJiaoShuLiang = rdr.GetInt32(rdr.GetOrdinal("ChengJiaoShuLiang"));
info.ShangPinJinE = rdr.GetDecimal(rdr.GetOrdinal("ShangPinJinE"));
items.Add(info);
}
}
if (items != null && items.Count > 0)
{
foreach (var item in items)
{
item.FangShis = GetJiFenShangPinFangShis(item.ShangPinId);
item.FuJians = GetJiFenShangPinFuJians(item.ShangPinId);
}
}
return(items);
}
