/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(Model.BonusGift model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update BonusGift set ");
strSql.Append(" GiftCode = @GiftCode , ");
strSql.Append(" GiftNum = @GiftNum , ");
strSql.Append(" GiftName = @GiftName , ");
strSql.Append(" Probaly = @Probaly , ");
strSql.Append(" GiftType = @GiftType , ");
strSql.Append(" GiftCount = @GiftCount , ");
strSql.Append(" BonusPlan = @BonusPlan , ");
strSql.Append(" IsAuto = @IsAuto , ");
strSql.Append(" Points = @Points , ");
strSql.Append(" GiftRemark = @GiftRemark ");
strSql.Append(" where GiftCode=@GiftCode ");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@GiftCode", SqlDbType.VarChar, 32),
new SqlParameter("@GiftNum", SqlDbType.Int, 4),
new SqlParameter("@GiftName", SqlDbType.VarChar, 20),
new SqlParameter("@Probaly", SqlDbType.Int, 4),
new SqlParameter("@GiftType", SqlDbType.VarChar, 10),
new SqlParameter("@GiftCount", SqlDbType.Int, 4),
new SqlParameter("@BonusPlan", SqlDbType.VarChar, 10),
new SqlParameter("@IsAuto", SqlDbType.Bit, 1),
new SqlParameter("@Points", SqlDbType.Int, 4),
new SqlParameter("@GiftRemark", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.GiftCode;
parameters[1].Value = model.GiftNum;
parameters[2].Value = model.GiftName;
parameters[3].Value = model.Probaly;
parameters[4].Value = model.GiftType;
parameters[5].Value = model.GiftCount;
parameters[6].Value = model.BonusPlan;
parameters[7].Value = model.IsAuto;
parameters[8].Value = model.Points;
parameters[9].Value = model.GiftRemark;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
private static Model.BonusGift DataRowToModel(DataRow row)
{
if (row != null)
{
Model.BonusGift model = new Model.BonusGift();
model.GiftCode = row["GiftCode"].ToString();
if (row["GiftNum"].ToString() != "")
{
model.GiftNum = int.Parse(row["GiftNum"].ToString());
}
model.GiftName = row["GiftName"].ToString();
if (row["Probaly"].ToString() != "")
{
model.Probaly = int.Parse(row["Probaly"].ToString());
}
model.GiftType = row["GiftType"].ToString();
if (row["GiftCount"].ToString() != "")
{
model.GiftCount = int.Parse(row["GiftCount"].ToString());
}
if (row["Points"].ToString() != "")
{
model.Points = int.Parse(row["Points"].ToString());
}
if (row["IsAuto"].ToString() != "")
{
model.IsAuto = bool.Parse(row["IsAuto"].ToString());
}
model.BonusPlan = row["BonusPlan"].ToString();
model.GiftRemark = row["GiftRemark"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Insert(Model.BonusGift model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BonusGift(");
strSql.Append("GiftCode,GiftNum,GiftName,Probaly,GiftType,GiftCount,BonusPlan,GiftRemark,IsAuto,Points");
strSql.Append(") values (");
strSql.Append("@GiftCode,@GiftNum,@GiftName,@Probaly,@GiftType,@GiftCount,@BonusPlan,@GiftRemark,@IsAuto,@Points");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@GiftCode", SqlDbType.VarChar, 32),
new SqlParameter("@GiftNum", SqlDbType.Int, 4),
new SqlParameter("@GiftName", SqlDbType.VarChar, 20),
new SqlParameter("@Probaly", SqlDbType.Int, 4),
new SqlParameter("@GiftType", SqlDbType.VarChar, 10),
new SqlParameter("@GiftCount", SqlDbType.Int, 4),
new SqlParameter("@BonusPlan", SqlDbType.VarChar, 10),
new SqlParameter("@GiftRemark", SqlDbType.VarChar, 50),
new SqlParameter("@IsAuto", SqlDbType.Bit, 1),
new SqlParameter("@Points", SqlDbType.Int, 4)
};
parameters[0].Value = model.GiftCode;
parameters[1].Value = model.GiftNum;
parameters[2].Value = model.GiftName;
parameters[3].Value = model.Probaly;
parameters[4].Value = model.GiftType;
parameters[5].Value = model.GiftCount;
parameters[6].Value = model.BonusPlan;
parameters[7].Value = model.GiftRemark;
parameters[8].Value = model.IsAuto;
parameters[9].Value = model.Points;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static bool Insert(Model.BonusGift model)
{
return(DAL.CommonBase.RunHashtable(Insert(model, new System.Collections.Hashtable())));
}
public static bool Update(Model.BonusGift model)
{
return(DAL.BonusGift.Update(model));
}
public static System.Collections.Hashtable Update(Model.BonusGift model, System.Collections.Hashtable MyHs)
{
return(DAL.BonusGift.Update(model, MyHs));
}
public static bool Insert(Model.BonusGift model)
{
return(DAL.BonusGift.Insert(model));
}
public static System.Collections.Hashtable Insert(Model.BonusGift model, System.Collections.Hashtable MyHs)
{
return(DAL.BonusGift.Insert(model, MyHs));
}
