/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_Users model)
{
db.Parameters.Clear();
db.Parameters.Append("@UserID",model.UserID);
db.Parameters.Append("@NickName",model.NickName);
db.Parameters.Append("@HeadPic",model.HeadPic);
db.Parameters.Append("@Sex",model.Sex);
db.Parameters.Append("@SignText",model.SignText);
db.Parameters.Append("@Birthday",model.Birthday.HasValue ? (object)model.Birthday.Value : (object)DBNull.Value );
db.Parameters.Append("@Tel",model.Tel);
db.Parameters.Append("@Email",model.Email);
db.Parameters.Append("@ProvinceID",model.ProvinceID);
db.Parameters.Append("@CityID",model.CityID);
db.Parameters.Append("@AreaID",model.AreaID);
db.Parameters.Append("@Province",model.Province);
db.Parameters.Append("@City",model.City);
db.Parameters.Append("@Area",model.Area);
db.Parameters.Append("@Profession",model.Profession);
db.Parameters.Append("@School",model.School);
db.Parameters.Append("@HomePage",model.HomePage);
db.Parameters.Append("@Introduce",model.Introduce);
db.Parameters.Append("@CheckState",model.CheckState);
db.Parameters.Append("@LastLoginTime",model.LastLoginTime);
db.Parameters.Append("@LastLoginIP",model.LastLoginIP);
db.Parameters.Append("@LoginTimes",model.LoginTimes);
db.Parameters.Append("@LoginState",model.LoginState);
db.Parameters.Append("@CreateTime",model.CreateTime);
db.Parameters.Append("@ModifyTime",model.ModifyTime);
DataTable dt = db.Select("insert into [IM_Users]([UIN],[UserID],[NickName],[HeadPic],[Sex],[SignText],[Birthday],[Tel],[Email],[ProvinceID],[CityID],[AreaID],[Province],[City],[Area],[Profession],[School],[HomePage],[Introduce],[CheckState],[LastLoginTime],[LastLoginIP],[LoginTimes],[LoginState],[CreateTime],[ModifyTime]) values (@UIN,@UserID,@NickName,@HeadPic,@Sex,@SignText,@Birthday,@Tel,@Email,@ProvinceID,@CityID,@AreaID,@Province,@City,@Area,@Profession,@School,@HomePage,@Introduce,@CheckState,@LastLoginTime,@LastLoginIP,@LoginTimes,@LoginState,@CreateTime,@ModifyTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.Users model)
{
db.Parameters.Clear();
db.Parameters.Append("@UserType",model.UserType);
db.Parameters.Append("@UIN",model.UIN);
db.Parameters.Append("@LoginName",model.LoginName);
db.Parameters.Append("@LoginPwd",model.LoginPwd);
db.Parameters.Append("@Money",model.Money);
db.Parameters.Append("@Coins",model.Coins);
db.Parameters.Append("@Points",model.Points);
db.Parameters.Append("@AlipayAccount",model.AlipayAccount);
db.Parameters.Append("@ProvinceID",model.ProvinceID);
db.Parameters.Append("@CityID",model.CityID);
db.Parameters.Append("@AreaID",model.AreaID);
db.Parameters.Append("@Province",model.Province);
db.Parameters.Append("@City",model.City);
db.Parameters.Append("@Area",model.Area);
db.Parameters.Append("@CheckState",model.CheckState);
db.Parameters.Append("@LastLoginIP",model.LastLoginIP);
db.Parameters.Append("@LastLogin",model.LastLogin);
db.Parameters.Append("@LoginTimes",model.LoginTimes);
db.Parameters.Append("@RegTime",model.RegTime);
db.Parameters.Append("@Name",model.Name);
db.Parameters.Append("@Tel",model.Tel);
db.Parameters.Append("@Email",model.Email);
DataTable dt = db.Select("insert into [Users]([UserType],[UIN],[LoginName],[LoginPwd],[Money],[Coins],[Points],[AlipayAccount],[ProvinceID],[CityID],[AreaID],[Province],[City],[Area],[CheckState],[LastLoginIP],[LastLogin],[LoginTimes],[RegTime],[Name],[Tel],[Email]) values (@UserType,@UIN,@LoginName,@LoginPwd,@Money,@Coins,@Points,@AlipayAccount,@ProvinceID,@CityID,@AreaID,@Province,@City,@Area,@CheckState,@LastLoginIP,@LastLogin,@LoginTimes,@RegTime,@Name,@Tel,@Email);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.Admin_Roles model)
{
db.Parameters.Clear();
db.Parameters.Append("@RoleName",model.RoleName);
db.Parameters.Append("@Description",model.Description);
DataTable dt = db.Select("insert into [Admin_Roles]([RoleName],[Description]) values (@RoleName,@Description);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.Admin_UserInRoles model)
{
db.Parameters.Clear();
db.Parameters.Append("@RoleID",model.RoleID.HasValue ? (object)model.RoleID.Value : (object)DBNull.Value );
db.Parameters.Append("@AdminID",model.AdminID.HasValue ? (object)model.AdminID.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Admin_UserInRoles]([RoleID],[AdminID]) values (@RoleID,@AdminID);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.Provinces model)
{
db.Parameters.Clear();
db.Parameters.Append("@Name",model.Name);
db.Parameters.Append("@Sort",model.Sort.HasValue ? (object)model.Sort.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Provinces]([Name],[Sort]) values (@Name,@Sort);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Key_ViewPrice_Log model)
{
db.Parameters.Clear();
db.Parameters.Append("@CountClickID",model.CountClickID.HasValue ? (object)model.CountClickID.Value : (object)DBNull.Value );
db.Parameters.Append("@Price",model.Price.HasValue ? (object)model.Price.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Key_ViewPrice_Log]([CountClickID],[Price]) values (@CountClickID,@Price);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Key model)
{
db.Parameters.Clear();
db.Parameters.Append("@Name",model.Name );
db.Parameters.Append("@CreateTime",model.CreateTime.HasValue ? (object)model.CreateTime.Value : (object)DBNull.Value );
db.Parameters.Append("@IsDefault",model.IsDefault);
DataTable dt = db.Select("insert into [Key]([Name],[CreateTime],[IsDefault]) values (@Name,@CreateTime,@IsDefault);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.KID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.Areas model)
{
db.Parameters.Clear();
db.Parameters.Append("@Name",model.Name);
db.Parameters.Append("@CID",model.CID);
db.Parameters.Append("@Sort",model.Sort);
DataTable dt = db.Select("insert into [Areas]([Name],[CID],[Sort]) values (@Name,@CID,@Sort);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_ShareFriendLevel model)
{
db.Parameters.Clear();
db.Parameters.Append("@Count",model.Count );
db.Parameters.Append("@Money",model.Money.HasValue ? (object)model.Money.Value : (object)DBNull.Value );
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Coupons_CashWhenFee_ShareFriendLevel]([Count],[Money],[UserID]) values (@Count,@Money,@UserID);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.Key_HotKey model)
{
db.Parameters.Clear();
db.Parameters.Append("@Name",model.Name );
db.Parameters.Append("@DataType",model.DataType );
db.Parameters.Append("@DataLink",model.DataLink );
DataTable dt = db.Select("insert into [Key_HotKey]([Name],[DataType],[DataLink]) values (@Name,@DataType,@DataLink);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Key_Attribute model)
{
db.Parameters.Clear();
db.Parameters.Append("@KID", model.KID.HasValue ? (object)model.KID.Value : (object)DBNull.Value);
db.Parameters.Append("@DataType", model.DataType);
db.Parameters.Append("@DataValue", model.DataValue);
DataTable dt = db.Select("insert into [Key_Attribute]([KID],[DataType],[DataValue]) values (@KID,@DataType,@DataValue);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.Admin_RolePermissions model)
{
db.Parameters.Clear();
db.Parameters.Append("@RoleID",model.RoleID.HasValue ? (object)model.RoleID.Value : (object)DBNull.Value );
db.Parameters.Append("@PageID",model.PageID.HasValue ? (object)model.PageID.Value : (object)DBNull.Value );
db.Parameters.Append("@CheckState",model.CheckState);
DataTable dt = db.Select("insert into [Admin_RolePermissions]([RoleID],[PageID],[CheckState]) values (@RoleID,@PageID,@CheckState);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_ShareFriendLog model)
{
db.Parameters.Clear();
db.Parameters.Append("@CodeID",model.CodeID.HasValue ? (object)model.CodeID.Value : (object)DBNull.Value );
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
db.Parameters.Append("@DateTime",model.DateTime.HasValue ? (object)model.DateTime.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Coupons_CashWhenFee_ShareFriendLog]([CodeID],[UserID],[DateTime]) values (@CodeID,@UserID,@DateTime);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.BaseData model)
{
db.Parameters.Clear();
db.Parameters.Append("@Name",model.Name );
db.Parameters.Append("@Value",model.Value );
db.Parameters.Append("@IDentity",model.IDentity.HasValue ? (object)model.IDentity.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [BaseData]([Name],[Value],[IDentity]) values (@Name,@Value,@IDentity);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Key_BusinessCircle model)
{
db.Parameters.Clear();
db.Parameters.Append("@BName",model.BName );
db.Parameters.Append("@CreateTime",model.CreateTime.HasValue ? (object)model.CreateTime.Value : (object)DBNull.Value );
db.Parameters.Append("@Lat",model.Lat.HasValue ? (object)model.Lat.Value : (object)DBNull.Value );
db.Parameters.Append("@Lng",model.Lng.HasValue ? (object)model.Lng.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Key_BusinessCircle]([BID],[BName],[CreateTime],[Lat],[Lng]) values (@BID,@BName,@CreateTime,@Lat,@Lng);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.BID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_FriendTeams model)
{
db.Parameters.Clear();
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
db.Parameters.Append("@UIN",model.UIN);
db.Parameters.Append("@TeamName",model.TeamName);
db.Parameters.Append("@Sequence",model.Sequence);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [IM_FriendTeams]([UserID],[UIN],[TeamName],[Sequence],[CreateTime]) values (@UserID,@UIN,@TeamName,@Sequence,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Key_QR_Log model)
{
db.Parameters.Clear();
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
db.Parameters.Append("@CreateDate",model.CreateDate.HasValue ? (object)model.CreateDate.Value : (object)DBNull.Value );
db.Parameters.Append("@SaleManUserID",model.SaleManUserID.HasValue ? (object)model.SaleManUserID.Value : (object)DBNull.Value );
db.Parameters.Append("@Coin",model.Coin.HasValue ? (object)model.Coin.Value : (object)DBNull.Value );
db.Parameters.Append("@Demo",model.Demo );
DataTable dt = db.Select("insert into [Key_QR_Log]([UserID],[CreateDate],[SaleManUserID],[Coin],[Demo]) values (@UserID,@CreateDate,@SaleManUserID,@Coin,@Demo);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_FriendInTeams model)
{
db.Parameters.Clear();
db.Parameters.Append("@MeUserID",model.MeUserID);
db.Parameters.Append("@MeUIN",model.MeUIN);
db.Parameters.Append("@FriendUserID",model.FriendUserID);
db.Parameters.Append("@FriendUIN",model.FriendUIN);
db.Parameters.Append("@FriendTeamID",model.FriendTeamID);
DataTable dt = db.Select("insert into [IM_FriendInTeams]([MeUserID],[MeUIN],[FriendUserID],[FriendUIN],[FriendTeamID]) values (@MeUserID,@MeUIN,@FriendUserID,@FriendUIN,@FriendTeamID);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_UserInGroups model)
{
db.Parameters.Clear();
db.Parameters.Append("@MemberUIN",model.MemberUIN);
db.Parameters.Append("@MemberUserID",model.MemberUserID);
db.Parameters.Append("@GroupUIN",model.GroupUIN);
db.Parameters.Append("@GroupID",model.GroupID);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [IM_UserInGroups]([MemberUIN],[MemberUserID],[GroupUIN],[GroupID],[CreateTime]) values (@MemberUIN,@MemberUserID,@GroupUIN,@GroupID,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Common_Favourite model)
{
db.Parameters.Clear();
db.Parameters.Append("@CreateDate",model.CreateDate.HasValue ? (object)model.CreateDate.Value : (object)DBNull.Value );
db.Parameters.Append("@DataID",model.DataID.HasValue ? (object)model.DataID.Value : (object)DBNull.Value );
db.Parameters.Append("@DataType",model.DataType );
db.Parameters.Append("@Memo",model.Memo );
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Common_Favourite]([CreateDate],[DataID],[DataType],[Memo],[UserID]) values (@CreateDate,@DataID,@DataType,@Memo,@UserID);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.User_TransferHistories model)
{
db.Parameters.Clear();
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
db.Parameters.Append("@AlipayAccount",model.AlipayAccount);
db.Parameters.Append("@Money",model.Money);
db.Parameters.Append("@Notes",model.Notes);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [User_TransferHistories]([UserID],[AlipayAccount],[Money],[Notes],[CreateTime]) values (@UserID,@AlipayAccount,@Money,@Notes,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_Condition model)
{
db.Parameters.Clear();
db.Parameters.Append("@SaleManUserID",model.SaleManUserID.HasValue ? (object)model.SaleManUserID.Value : (object)DBNull.Value );
db.Parameters.Append("@Money",model.Money.HasValue ? (object)model.Money.Value : (object)DBNull.Value );
db.Parameters.Append("@Memo",model.Memo );
db.Parameters.Append("@IsShow",model.IsShow.HasValue ? (object)model.IsShow.Value : (object)DBNull.Value );
db.Parameters.Append("@CreateTime",model.CreateTime.HasValue ? (object)model.CreateTime.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Coupons_CashWhenFee_Condition]([SaleManUserID],[Money],[Memo],[IsShow],[CreateTime]) values (@SaleManUserID,@Money,@Memo,@IsShow,@CreateTime);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_Groups model)
{
db.Parameters.Clear();
db.Parameters.Append("@UIN",model.UIN);
db.Parameters.Append("@Name",model.Name);
db.Parameters.Append("@AdminUIN",model.AdminUIN);
db.Parameters.Append("@AdminUserID",model.AdminUserID);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [IM_Groups]([UIN],[Name],[AdminUIN],[AdminUserID],[CreateTime]) values (@UIN,@Name,@AdminUIN,@AdminUserID,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_UINS model)
{
db.Parameters.Clear();
db.Parameters.Append("@UIN",model.UIN);
db.Parameters.Append("@HasUsed",model.HasUsed);
db.Parameters.Append("@IsRecommend",model.IsRecommend);
db.Parameters.Append("@Sequence",model.Sequence);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [IM_UINS]([UIN],[HasUsed],[IsRecommend],[Sequence],[CreateTime]) values (@UIN,@HasUsed,@IsRecommend,@Sequence,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_FriendApps model)
{
db.Parameters.Clear();
db.Parameters.Append("@FromUserID",model.FromUserID);
db.Parameters.Append("@FromUIN",model.FromUIN);
db.Parameters.Append("@ToUserID",model.ToUserID);
db.Parameters.Append("@ToUIN",model.ToUIN);
db.Parameters.Append("@Message",model.Message);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [IM_FriendApps]([FromUserID],[FromUIN],[ToUserID],[ToUIN],[Message],[CreateTime]) values (@FromUserID,@FromUIN,@ToUserID,@ToUIN,@Message,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee_SaleManNotice model)
{
db.Parameters.Clear();
db.Parameters.Append("@Content", !string.IsNullOrWhiteSpace(model.Content) ? (object)model.Content : (object)DBNull.Value);
db.Parameters.Append("@StartTime", model.StartTime.HasValue ? (object)model.StartTime.Value : (object)DBNull.Value);
db.Parameters.Append("@EndTime", model.EndTime.HasValue ? (object)model.EndTime.Value : (object)DBNull.Value);
db.Parameters.Append("@CreateTime", model.CreateTime.HasValue ? (object)model.CreateTime.Value : (object)DBNull.Value);
db.Parameters.Append("@ModifyTime", model.ModifyTime.HasValue ? (object)model.ModifyTime.Value : (object)DBNull.Value);
db.Parameters.Append("@CreateUserID", model.CreateUserID.HasValue ? (object)model.CreateUserID.Value : (object)DBNull.Value);
DataTable dt = db.Select("insert into [Coupons_CashWhenFee_SaleManNotice]([Content],[StartTime],[EndTime],[CreateTime],[ModifyTime],[CreateUserID]) values (@Content,@StartTime,@EndTime,@CreateTime,@ModifyTime,@CreateUserID);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.IM_SystemMsgs model)
{
db.Parameters.Clear();
db.Parameters.Append("@Title",model.Title);
db.Parameters.Append("@Content",model.Content);
db.Parameters.Append("@ToUIN",model.ToUIN);
db.Parameters.Append("@ToUserID",model.ToUserID);
db.Parameters.Append("@MessageName",model.MessageName);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [IM_SystemMsgs]([Title],[Content],[ToUIN],[ToUserID],[MessageName],[CreateTime]) values (@Title,@Content,@ToUIN,@ToUserID,@MessageName,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public int Add(ADeeWu.HuoBi3J.Model.Coupons_CashWhenFee model)
{
db.Parameters.Clear();
db.Parameters.Append("@Money",model.Money.HasValue ? (object)model.Money.Value : (object)DBNull.Value );
db.Parameters.Append("@Fee",model.Fee.HasValue ? (object)model.Fee.Value : (object)DBNull.Value );
db.Parameters.Append("@CreateUserID",model.CreateUserID.HasValue ? (object)model.CreateUserID.Value : (object)DBNull.Value );
db.Parameters.Append("@StartDate",model.StartDate.HasValue ? (object)model.StartDate.Value : (object)DBNull.Value );
db.Parameters.Append("@EndDate",model.EndDate.HasValue ? (object)model.EndDate.Value : (object)DBNull.Value );
db.Parameters.Append("@CreateDate",model.CreateDate.HasValue ? (object)model.CreateDate.Value : (object)DBNull.Value );
DataTable dt = db.Select("insert into [Coupons_CashWhenFee]([Money],[Fee],[CreateUserID],[StartDate],[EndDate],[CreateDate]) values (@Money,@Fee,@CreateUserID,@StartDate,@EndDate,@CreateDate);select @@Identity;");
int newID = int.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.User_PointsHistories model)
{
db.Parameters.Clear();
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
db.Parameters.Append("@InPoint",model.InPoint);
db.Parameters.Append("@OutPoint",model.OutPoint);
db.Parameters.Append("@Remain",model.Remain);
db.Parameters.Append("@Notes",model.Notes);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [User_PointsHistories]([UserID],[InPoint],[OutPoint],[Remain],[Notes],[CreateTime]) values (@UserID,@InPoint,@OutPoint,@Remain,@Notes,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
/// <summary>
/// 成功返回大于0的新ID
/// </summary>
public long Add(ADeeWu.HuoBi3J.Model.User_DealHistories model)
{
db.Parameters.Clear();
db.Parameters.Append("@UserID",model.UserID.HasValue ? (object)model.UserID.Value : (object)DBNull.Value );
db.Parameters.Append("@InMoney",model.InMoney);
db.Parameters.Append("@OutMoney",model.OutMoney);
db.Parameters.Append("@Balance",model.Balance);
db.Parameters.Append("@Notes",model.Notes);
db.Parameters.Append("@CreateTime",model.CreateTime);
DataTable dt = db.Select("insert into [User_DealHistories]([UserID],[InMoney],[OutMoney],[Balance],[Notes],[CreateTime]) values (@UserID,@InMoney,@OutMoney,@Balance,@Notes,@CreateTime);select @@Identity;");
long newID = long.Parse(dt.Rows[0][0].ToString());
model.ID = newID;
return newID;
}
