public bool Update(XMemberInvite model)
{
string sql = string.Format(@"update XMemberInvite
set MID=@MID,CID=@CID,Grade1=@Grade1,Grade2=@Grade2,IsAdd=@IsAdd,IsReply=@IsReply,
SortIndex=@SortIndex,IsDeleted=@IsDeleted,CreateTime=@CreateTime,
UpdateTime=@UpdateTime
where MIID=@MIID");
DbParameter[] parms =
{
new SqlParameter("@MID", SqlDbType.VarChar, 50)
{
Value = model.MID
},
new SqlParameter("@MIID", SqlDbType.VarChar, 50)
{
Value = model.MIID
},
new SqlParameter("@CID", SqlDbType.VarChar, 50)
{
Value = model.CID
},
new SqlParameter("@Grade1", SqlDbType.Int)
{
Value = model.Grade1
},
new SqlParameter("@Grade2", SqlDbType.Int)
{
Value = model.Grade2
},
new SqlParameter("@IsAdd", SqlDbType.Int)
{
Value = model.IsAdd
},
new SqlParameter("@IsReply", SqlDbType.Int)
{
Value = model.IsReply
},
new SqlParameter("@SortIndex", SqlDbType.Int)
{
Value = model.SortIndex
},
new SqlParameter("@IsDeleted", SqlDbType.Int)
{
Value = model.IsDeleted
},
new SqlParameter("@CreateTime", SqlDbType.DateTime)
{
Value = model.CreateTime
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = model.UpdateTime
}
};
return(dbHelper.ExecuteNonQuery(sql, parms));
}
public bool Add(XMemberInvite model)
{
string sql = string.Format(@"insert into XMemberInvite
(MIID,MID,CID,Grade1,Grade2,IsAdd,IsReply,SortIndex,IsDeleted,CreateTime,UpdateTime)
values(@MIID,@MID,@CID,@Grade1,@Grade2,@IsAdd,@IsReply,@SortIndex,@IsDeleted,@CreateTime,@UpdateTime) ");
DbParameter[] parms =
{
new SqlParameter("@MID", SqlDbType.VarChar, 50)
{
Value = model.MID
},
new SqlParameter("@MIID", SqlDbType.VarChar, 50)
{
Value = model.MIID
},
new SqlParameter("@CID", SqlDbType.VarChar, 50)
{
Value = model.CID
},
new SqlParameter("@Grade1", SqlDbType.Int)
{
Value = model.Grade1
},
new SqlParameter("@Grade2", SqlDbType.Int)
{
Value = model.Grade2
},
new SqlParameter("@IsAdd", SqlDbType.Int)
{
Value = model.IsAdd
},
new SqlParameter("@IsReply", SqlDbType.Int)
{
Value = model.IsReply
},
new SqlParameter("@SortIndex", SqlDbType.Int)
{
Value = model.SortIndex
},
new SqlParameter("@IsDeleted", SqlDbType.Int)
{
Value = model.IsDeleted
},
new SqlParameter("@CreateTime", SqlDbType.DateTime)
{
Value = model.CreateTime
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = model.UpdateTime
}
};
return(dbHelper.ExecuteNonQuery(sql, parms));
}
public bool Delete(XMemberInvite model)
{
string sql = string.Format(@"update XMemberInvite
set IsDeleted=@IsDeleted,UpdateTime=@UpdateTime
where MIID=@MIID");
DbParameter[] parms =
{
new SqlParameter("@MIID", SqlDbType.VarChar, 50)
{
Value = model.MIID
},
new SqlParameter("@IsDeleted", SqlDbType.Int)
{
Value = model.IsDeleted
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = model.UpdateTime
}
};
return(dbHelper.ExecuteNonQuery(sql, parms));
}
public bool Delete(XMemberInvite model)
{
return(dal.Delete(model));
}
public bool Update(XMemberInvite model)
{
return(dal.Update(model));
}
public bool Add(XMemberInvite model)
{
return(dal.Add(model));
}
