/// <summary>
/// 修改商品信息
/// </summary>
/// <param name="TdProduct">商品信息信息</param>
/// <param name="LoginId">管理员登陆标识</param>
/// <returns>修改结果</returns>
public ResultDesc ModifyTradeProduct(TradeProduct TdProduct, String LoginId)
{
ResultDesc rsdc = new ResultDesc();
string operUser = string.Empty;//操作人
try
{
TradeUser TdUser = new TradeUser();
#region 判断登陆标识是否过期
if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser))
{
rsdc.Result = false;
rsdc.Desc = ResCode.UL003Desc;
return rsdc;
}
if (UserType.NormalType == TdUser.UType)
{
rsdc.Result = false;
rsdc.Desc = ComFunction.NotRightUser;
return rsdc;
}
operUser = TdUser.Account;
#endregion
List<string> sqlList = new List<string>();
StringBuilder strbld = new StringBuilder();
strbld.AppendFormat("update Trade_Product set ");
strbld.AppendFormat("ProductName='{0}',", TdProduct.ProductName);
strbld.AppendFormat("Adjustbase={0},", TdProduct.Adjustbase);
//strbld.AppendFormat("Adjustcount={0},", TdProduct.Adjustcount);
strbld.AppendFormat("Expressionfee='{0}',", TdProduct.Expressionfee);
strbld.AppendFormat("Holdbase={0},", TdProduct.Holdbase);
strbld.AppendFormat("Lowerprice={0},", TdProduct.Lowerprice);
strbld.AppendFormat("Maxprice={0},", TdProduct.Maxprice);
strbld.AppendFormat("Maxtime={0},", TdProduct.Maxtime);
strbld.AppendFormat("Minprice={0},", TdProduct.Minprice);
//strbld.AppendFormat("Ordemoney={0},", TdProduct.Ordemoney);
strbld.AppendFormat("Ordemoneyfee='{0}',", TdProduct.Ordemoneyfee);
strbld.AppendFormat("Pricedot={0},", TdProduct.Pricedot);
//strbld.AppendFormat("Sellfee='{0}',", TdProduct.Sellfee);
strbld.AppendFormat("Sellstoragefee='{0}',", TdProduct.Sellstoragefee);
strbld.AppendFormat("SetBase={0},", TdProduct.SetBase);
strbld.AppendFormat("State='{0}',", TdProduct.State);
strbld.AppendFormat("Unit={0},", TdProduct.Unit);
strbld.AppendFormat("Valuedot={0},", TdProduct.Valuedot);
strbld.AppendFormat("Buystoragefee='{0}',", TdProduct.Buystoragefee);
strbld.AppendFormat("Pricecode='{0}',", TdProduct.Pricecode);
//strbld.AppendFormat("Goodscode='{0}',", TdProduct.Goodscode);
strbld.AppendFormat("starttime='{0}',", TdProduct.Starttime);
strbld.AppendFormat("endtime='{0}'", TdProduct.Endtime);
strbld.AppendFormat(" where Productcode='{0}'", TdProduct.Productcode);
sqlList.Add(strbld.ToString());
string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac);
//添加操作记录
sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')",
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}修改商品信息:{0}", TdProduct.ProductName, ipmac)));
if (!ComFunction.SqlTransaction(sqlList))
{
rsdc.Result = false;
rsdc.Desc = "修改商品信息出错";
return rsdc;
}
rsdc.Result = true;
rsdc.Desc = "修该商品信息成功";
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
rsdc.Result = false;
rsdc.Desc = "修改商品信息失败";
}
return rsdc;
}
/// <summary>
/// 获取商品信息列表
/// </summary>
/// <param name="sql">查询SQL</param>
/// <returns>商品信息列表</returns>
public static List<TradeProduct> GetTradeProductList(string sql)
{
System.Data.Common.DbDataReader dbreader = null;
List<TradeProduct> list = new List<TradeProduct>();
try
{
Dictionary<string, ProPrice> prodic = GetProPrice();
dbreader = DbHelper.ExecuteReader(sql);
while (dbreader.Read())
{
TradeProduct tradeProduct = new TradeProduct();
tradeProduct.Adjustbase = System.DBNull.Value != dbreader["Adjustbase"] ? Convert.ToDouble(dbreader["Adjustbase"]) : 0;
tradeProduct.Adjustcount = System.DBNull.Value != dbreader["Adjustcount"] ? Convert.ToInt32(dbreader["Adjustcount"]) : 0;
tradeProduct.Buystoragefee = System.DBNull.Value != dbreader["Buystoragefee"] ? dbreader["Buystoragefee"].ToString() : string.Empty;
tradeProduct.Expressionfee = System.DBNull.Value != dbreader["Expressionfee"] ? dbreader["Expressionfee"].ToString() : string.Empty;
tradeProduct.Goodscode = System.DBNull.Value != dbreader["Goodscode"] ? dbreader["Goodscode"].ToString() : string.Empty;
tradeProduct.Holdbase = System.DBNull.Value != dbreader["Holdbase"] ? Convert.ToInt32(dbreader["Holdbase"]) : 0;
tradeProduct.Lowerprice = System.DBNull.Value != dbreader["Lowerprice"] ? Convert.ToDouble(dbreader["Lowerprice"]) : 0;
tradeProduct.Maxprice = System.DBNull.Value != dbreader["Maxprice"] ? Convert.ToDouble(dbreader["Maxprice"]) : 0;
tradeProduct.Maxtime = System.DBNull.Value != dbreader["Maxtime"] ? Convert.ToInt32(dbreader["Maxtime"]) : 0;
tradeProduct.Minprice = System.DBNull.Value != dbreader["Minprice"] ? Convert.ToDouble(dbreader["Minprice"]) : 0;
tradeProduct.Ordemoney = System.DBNull.Value != dbreader["Ordemoney"] ? Convert.ToDouble(dbreader["Ordemoney"]) : 0;
tradeProduct.Ordemoneyfee = System.DBNull.Value != dbreader["Ordemoneyfee"] ? dbreader["Ordemoneyfee"].ToString() : string.Empty;
tradeProduct.Pricecode = System.DBNull.Value != dbreader["Pricecode"] ? dbreader["Pricecode"].ToString() : string.Empty;
tradeProduct.Pricedot = System.DBNull.Value != dbreader["Pricedot"] ? Convert.ToInt32(dbreader["Pricedot"]) : 0;
tradeProduct.Productcode = System.DBNull.Value != dbreader["Productcode"] ? dbreader["Productcode"].ToString() : string.Empty;
tradeProduct.ProductName = System.DBNull.Value != dbreader["ProductName"] ? dbreader["ProductName"].ToString() : string.Empty;
tradeProduct.Sellfee = System.DBNull.Value != dbreader["Sellfee"] ? dbreader["Sellfee"].ToString() : string.Empty;
tradeProduct.Sellstoragefee = System.DBNull.Value != dbreader["Sellstoragefee"] ? dbreader["Sellstoragefee"].ToString() : string.Empty;
tradeProduct.SetBase = System.DBNull.Value != dbreader["SetBase"] ? Convert.ToInt32(dbreader["SetBase"]) : 0;
tradeProduct.State = System.DBNull.Value != dbreader["State"] ? dbreader["State"].ToString() : string.Empty;
tradeProduct.Unit = System.DBNull.Value != dbreader["Unit"] ? Convert.ToDouble(dbreader["Unit"]) : 0;
tradeProduct.Valuedot = System.DBNull.Value != dbreader["Valuedot"] ? Convert.ToDouble(dbreader["Valuedot"]) : 0;
tradeProduct.Starttime = System.DBNull.Value != dbreader["starttime"] ? dbreader["starttime"].ToString() : string.Empty;
tradeProduct.Endtime = System.DBNull.Value != dbreader["endtime"] ? dbreader["endtime"].ToString() : string.Empty;
if (prodic != null && prodic.ContainsKey(tradeProduct.Pricecode))
{
tradeProduct.weektime = prodic[tradeProduct.Pricecode].weektime;
tradeProduct.realprice = prodic[tradeProduct.Pricecode].realprice;
}
list.Add(tradeProduct);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
if (null != dbreader)
{
dbreader.Close();
dbreader.Dispose();
}
}
return list;
}
/// <summary>
/// 添加商品信息
/// </summary>
/// <param name="TdProduct">商品信息信息</param>
/// <param name="LoginId">管理员登陆标识</param>
/// <returns>添加结果</returns>
public ResultDesc AddTradeProduct(TradeProduct TdProduct, String LoginId)
{
ResultDesc rsdc = new ResultDesc();
string operUser = string.Empty;//操作人
try
{
TradeUser TdUser = new TradeUser();
#region 判断登陆标识是否过期
if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser))
{
rsdc.Result = false;
rsdc.Desc = ResCode.UL003Desc;
return rsdc;
}
if (UserType.NormalType == TdUser.UType)
{
rsdc.Result = false;
rsdc.Desc = ComFunction.NotRightUser;
return rsdc;
}
operUser = TdUser.Account;
#endregion
List<string> sqlList = new List<string>();
TradeDataSource tdsource = ComFunction.GetTradeDataSource(TdProduct.Pricecode);
//Goodscode用Pricecode赋值
sqlList.Add(string.Format("insert into Trade_Product([ProductName],[productcode],[goodscode],[pricecode],[adjustbase],[adjustcount],[pricedot],[valuedot],[setBase],[holdbase],[expressionfee],[sellfee],[maxprice],[minprice],[maxtime],[Ordemoneyfee],[Ordemoney],[buystoragefee],[sellstoragefee],[state],[unit],[lowerprice],[starttime],[endtime]) values('{0}','{1}','{2}','{3}',{4},{5},{6},{7},{8},{9},'{10}','{11}',{12},{13},{14},'{15}',{16},'{17}','{18}','{19}',{20},{21},'{22}','{23}')",
TdProduct.ProductName, TdProduct.Productcode, TdProduct.Pricecode, TdProduct.Pricecode, TdProduct.Adjustbase, tdsource.adjustcount,
TdProduct.Pricedot, TdProduct.Valuedot, TdProduct.SetBase, TdProduct.Holdbase, TdProduct.Expressionfee, TdProduct.Sellfee, TdProduct.Maxprice,
TdProduct.Minprice, TdProduct.Maxtime, TdProduct.Ordemoneyfee, TdProduct.Ordemoney, TdProduct.Buystoragefee, TdProduct.Sellstoragefee,
TdProduct.State, TdProduct.Unit, TdProduct.Lowerprice, TdProduct.Starttime, TdProduct.Endtime));
string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac);
//添加操作记录
sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')",
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}添加商品信息:{0}", TdProduct.ProductName, ipmac)));
if (!ComFunction.SqlTransaction(sqlList))
{
rsdc.Result = false;
rsdc.Desc = "添加商品信息出错";
return rsdc;
}
rsdc.Result = true;
rsdc.Desc = "添加商品信息成功";
}
catch (Exception ex)
{
ComFunction.WriteErr(ex);
rsdc.Result = false;
rsdc.Desc = "添加商品信息失败";
}
return rsdc;
}