/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.MemberPermission model) { StringBuilder strSql = new StringBuilder(); strSql.Append("if (not exists(select top(1) * from memberpermission where UID=@UID)) insert into memberpermission("); strSql.Append("UID, IsTrade, IsLookStock, IsLookPrice_01, IsLookPrice_02, IsLookProduct_01, IsLookProduct_02, IsPeriodicalSettle, IsMoneyAndShipping, IsCOD, IsPriorDistribution, IsShippingFor48h, IsSpecialTrade)"); strSql.Append(" values ("); strSql.Append("@UID, @IsTrade, @IsLookStock, @IsLookPrice_01, @IsLookPrice_02, @IsLookProduct_01, @IsLookProduct_02, @IsPeriodicalSettle, @IsMoneyAndShipping, @IsCOD, @IsPriorDistribution, @IsShippingFor48h, @IsSpecialTrade)"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID); db.AddInParameter(dbCommand, "IsTrade", DbType.Int32, model.IsTrade ? 1 : 0); db.AddInParameter(dbCommand, "IsLookStock", DbType.Int32, model.IsLookStock ? 1 : 0); db.AddInParameter(dbCommand, "IsLookPrice_01", DbType.Int32, model.IsLookPrice_01 ? 1 : 0); db.AddInParameter(dbCommand, "IsLookPrice_02", DbType.Int32, model.IsLookPrice_02 ? 1 : 0); db.AddInParameter(dbCommand, "IsLookProduct_01", DbType.Int32, model.IsLookProduct_01 ? 1 : 0); db.AddInParameter(dbCommand, "IsLookProduct_02", DbType.Int32, model.IsLookProduct_02 ? 1 : 0); db.AddInParameter(dbCommand, "IsPeriodicalSettle", DbType.Int32, model.IsPeriodicalSettle ? 1 : 0); db.AddInParameter(dbCommand, "IsMoneyAndShipping", DbType.Int32, model.IsMoneyAndShipping ? 1 : 0); db.AddInParameter(dbCommand, "IsCOD", DbType.Int32, model.IsCOD ? 1 : 0); db.AddInParameter(dbCommand, "IsPriorDistribution", DbType.Int32, model.IsPriorDistribution ? 1 : 0); db.AddInParameter(dbCommand, "IsShippingFor48h", DbType.Int32, model.IsShippingFor48h ? 1 : 0); db.AddInParameter(dbCommand, "IsSpecialTrade", DbType.Int32, model.IsSpecialTrade ? 1 : 0); return(0 < db.ExecuteNonQuery(dbCommand)); }
/// <summary> /// 自动更新买家[类别 ?批发客户或OTC拆零客户]的权限 /// </summary> public bool AutoUpdate(int UID, MemberKeyValue.Member_Class member_Class) { Model.MemberPermission model = GetModel(UID); switch (member_Class) { case MemberKeyValue.Member_Class.批发客户: model.IsLookPrice_01 = true; model.IsLookPrice_02 = false; model.IsLookProduct_01 = true; model.IsLookProduct_02 = false; model.IsPriorDistribution = true; model.IsMoneyAndShipping = true; model.IsCOD = false; break; case MemberKeyValue.Member_Class.OTC客户: model.IsLookPrice_01 = false; model.IsLookPrice_02 = true; model.IsLookProduct_01 = false; model.IsLookProduct_02 = true; model.IsMoneyAndShipping = false; model.IsCOD = true; break; } return(Update(model)); }
private Model.MemberPermission GetModelByDataSet(DataSet ds) { Model.MemberPermission model = null; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { model = GetModelByDataRow(ds.Tables[0].Rows[0]); } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.MemberPermission GetModel(int UID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from memberpermission "); strSql.Append(" where UID=" + UID); DataSet ds = base.ExecuteDataSetForCache(strSql.ToString(), "bll_MemberPermission_" + UID, DateTime.Now.AddMinutes(1)); var model = GetModelByDataSet(ds); if (model == null) { model = new Model.MemberPermission(); model.IsMoneyAndShipping = true; model.IsBuyFilingStatus = true; model.IsMoneyAndShipping = true; } return(model); }
public Model.MemberPermission GetModelByDataReader(IDataReader dr) { Model.MemberPermission model = new Model.MemberPermission(); model.UID = int.Parse(dr["UID"].ToString()); model.IsTrade = int.Parse(dr["IsTrade"].ToString()) == 1; model.IsLookStock = int.Parse(dr["IsLookStock"].ToString()) == 1; model.IsLookPrice_01 = int.Parse(dr["IsLookPrice_01"].ToString()) == 1; model.IsLookPrice_02 = int.Parse(dr["IsLookPrice_02"].ToString()) == 1; model.IsLookProduct_01 = int.Parse(dr["IsLookProduct_01"].ToString()) == 1; model.IsLookProduct_02 = int.Parse(dr["IsLookProduct_02"].ToString()) == 1; model.IsPeriodicalSettle = int.Parse(dr["IsPeriodicalSettle"].ToString()) == 1; model.IsMoneyAndShipping = int.Parse(dr["IsMoneyAndShipping"].ToString()) == 1; model.IsCOD = int.Parse(dr["IsCOD"].ToString()) == 1; model.IsPriorDistribution = int.Parse(dr["IsPriorDistribution"].ToString()) == 1; model.IsShippingFor48h = int.Parse(dr["IsShippingFor48h"].ToString()) == 1; model.IsSpecialTrade = int.Parse(dr["IsSpecialTrade"].ToString()) == 1; model.IsBuyFilingStatus = GetBuyFilingStatus(model.UID); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.MemberPermission GetModelWithNoCache(int UID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from memberpermission "); strSql.Append(" where UID=" + UID); DataSet ds = base.ExecuteDataSet(strSql.ToString()); var model = GetModelByDataSet(ds); if (model == null) { if (model == null) { model = new Model.MemberPermission(); model.IsMoneyAndShipping = true; model.IsBuyFilingStatus = true; model.IsMoneyAndShipping = true; model.UID = UID; Add(model); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.MemberPermission model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update memberpermission set "); strSql.Append("IsTrade=@IsTrade,"); strSql.Append("IsLookStock=@IsLookStock,"); strSql.Append("IsLookPrice_01=@IsLookPrice_01,"); strSql.Append("IsLookPrice_02=@IsLookPrice_02,"); strSql.Append("IsLookProduct_01=@IsLookProduct_01,"); strSql.Append("IsLookProduct_02=@IsLookProduct_02,"); strSql.Append("IsPeriodicalSettle=@IsPeriodicalSettle,"); strSql.Append("IsMoneyAndShipping=@IsMoneyAndShipping,"); strSql.Append("IsCOD=@IsCOD,"); strSql.Append("IsPriorDistribution=@IsPriorDistribution,"); strSql.Append("IsShippingFor48h=@IsShippingFor48h,"); strSql.Append("IsSpecialTrade=@IsSpecialTrade"); strSql.Append(" where UID=@UID "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID); db.AddInParameter(dbCommand, "IsTrade", DbType.Int32, model.IsTrade ? 1 : 0); db.AddInParameter(dbCommand, "IsLookStock", DbType.Int32, model.IsLookStock ? 1 : 0); db.AddInParameter(dbCommand, "IsLookPrice_01", DbType.Int32, model.IsLookPrice_01 ? 1 : 0); db.AddInParameter(dbCommand, "IsLookPrice_02", DbType.Int32, model.IsLookPrice_02 ? 1 : 0); db.AddInParameter(dbCommand, "IsLookProduct_01", DbType.Int32, model.IsLookProduct_01 ? 1 : 0); db.AddInParameter(dbCommand, "IsLookProduct_02", DbType.Int32, model.IsLookProduct_02 ? 1 : 0); db.AddInParameter(dbCommand, "IsPeriodicalSettle", DbType.Int32, model.IsPeriodicalSettle ? 1 : 0); db.AddInParameter(dbCommand, "IsMoneyAndShipping", DbType.Int32, model.IsMoneyAndShipping ? 1 : 0); db.AddInParameter(dbCommand, "IsCOD", DbType.Int32, model.IsCOD ? 1 : 0); db.AddInParameter(dbCommand, "IsPriorDistribution", DbType.Int32, model.IsPriorDistribution ? 1 : 0); db.AddInParameter(dbCommand, "IsShippingFor48h", DbType.Int32, model.IsShippingFor48h ? 1 : 0); db.AddInParameter(dbCommand, "IsSpecialTrade", DbType.Int32, model.IsSpecialTrade ? 1 : 0); return(0 < db.ExecuteNonQuery(dbCommand)); }