/// <summary>
/// 增加一条数据
/// </summary>
public int AddGroups(MideFrameWork.Data.Entity.GroupsEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Groups(");
strSql.Append("GroupName,DisplayIndex,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@GroupName,@DisplayIndex,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@GroupName", SqlDbType.NVarChar,32) ,
new SqlParameter("@DisplayIndex", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.GroupName;
parameters[1].Value = info.DisplayIndex;
parameters[2].Value = info.CreateDate;
parameters[3].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateWG_CommunityNews(MideFrameWork.Data.Entity.WG_CommunityNewsEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update WG_CommunityNews set ");
strSql.Append(" Title = @Title , ");
strSql.Append(" Contents = @Contents , ");
strSql.Append(" UpCount = @UpCount , ");
strSql.Append(" Memo = @Memo , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@Title", SqlDbType.NVarChar,128) , new SqlParameter("@Contents", SqlDbType.NVarChar) , new SqlParameter("@UpCount", SqlDbType.Int,4) , new SqlParameter("@Memo", SqlDbType.NVarChar,256) , new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.Title;
parameters[2].Value = info.Contents;
parameters[3].Value = info.UpCount;
parameters[4].Value = info.Memo;
parameters[5].Value = info.CreateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdatePrivilegeView(MideFrameWork.Data.Entity.PrivilegeViewEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update PrivilegeView set ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" ModuleName = @ModuleName , ");
strSql.Append(" ButtonName = @ButtonName ");
strSql.Append(" where ");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,4) , new SqlParameter("@ModuleName", SqlDbType.NVarChar,128) , new SqlParameter("@ButtonName", SqlDbType.NVarChar,32)
};
parameters[0].Value = info.UserID;
parameters[1].Value = info.ModuleName;
parameters[2].Value = info.ButtonName;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateBase_Privilege(MideFrameWork.Data.Entity.Base_PrivilegeEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Base_Privilege set ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" ModuleID = @ModuleID , ");
strSql.Append(" ButtonID = @ButtonID , ");
strSql.Append(" CreaterID = @CreaterID , ");
strSql.Append(" UpdaterID = @UpdaterID , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" UpdateDate = @UpdateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@UserID", SqlDbType.Int,4) , new SqlParameter("@ModuleID", SqlDbType.Int,4) , new SqlParameter("@ButtonID", SqlDbType.Int,4) , new SqlParameter("@CreaterID", SqlDbType.Int,4) , new SqlParameter("@UpdaterID", SqlDbType.Int,4) , new SqlParameter("@CreateDate", SqlDbType.DateTime) , new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.UserID;
parameters[2].Value = info.ModuleID;
parameters[3].Value = info.ButtonID;
parameters[4].Value = info.CreaterID;
parameters[5].Value = info.UpdaterID;
parameters[6].Value = info.CreateDate;
parameters[7].Value = info.UpdateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateGroups(MideFrameWork.Data.Entity.GroupsEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Groups set ");
strSql.Append(" GroupName = @GroupName , ");
strSql.Append(" DisplayIndex = @DisplayIndex , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" UpdateDate = @UpdateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@GroupName", SqlDbType.NVarChar,32) , new SqlParameter("@DisplayIndex", SqlDbType.Int,4) , new SqlParameter("@CreateDate", SqlDbType.DateTime) , new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.GroupName;
parameters[2].Value = info.DisplayIndex;
parameters[3].Value = info.CreateDate;
parameters[4].Value = info.UpdateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddRegisterDetail(MideFrameWork.Data.Entity.RegisterDetailEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into RegisterDetail(");
strSql.Append("UserID,Mac,IP,CreateDate");
strSql.Append(") values (");
strSql.Append("@UserID,@Mac,@IP,@CreateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,4) ,
new SqlParameter("@Mac", SqlDbType.NVarChar,64) ,
new SqlParameter("@IP", SqlDbType.NVarChar,64) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.UserID;
parameters[1].Value = info.Mac;
parameters[2].Value = info.IP;
parameters[3].Value = info.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddDistrict(MideFrameWork.Data.Entity.DistrictEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into District(");
strSql.Append("ParentID,DistrictName,Status");
strSql.Append(") values (");
strSql.Append("@ParentID,@DistrictName,@Status");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4) ,
new SqlParameter("@DistrictName", SqlDbType.NVarChar,32) ,
new SqlParameter("@Status", SqlDbType.Int,4)
};
parameters[0].Value = info.ParentID;
parameters[1].Value = info.DistrictName;
parameters[2].Value = info.Status;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_Feeback(MideFrameWork.Data.Entity.WG_FeebackEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_Feeback(");
strSql.Append("PromoterID,Detail,Memo,CreateDate");
strSql.Append(") values (");
strSql.Append("@PromoterID,@Detail,@Memo,@CreateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PromoterID", SqlDbType.Int,4) ,
new SqlParameter("@Detail", SqlDbType.NVarChar,1024) ,
new SqlParameter("@Memo", SqlDbType.NVarChar,512) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.PromoterID;
parameters[1].Value = info.Detail;
parameters[2].Value = info.Memo;
parameters[3].Value = info.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateWG_Feeback(MideFrameWork.Data.Entity.WG_FeebackEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update WG_Feeback set ");
strSql.Append(" PromoterID = @PromoterID , ");
strSql.Append(" Detail = @Detail , ");
strSql.Append(" Memo = @Memo , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@PromoterID", SqlDbType.Int,4) , new SqlParameter("@Detail", SqlDbType.NVarChar,1024) , new SqlParameter("@Memo", SqlDbType.NVarChar,512) , new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.PromoterID;
parameters[2].Value = info.Detail;
parameters[3].Value = info.Memo;
parameters[4].Value = info.CreateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateBase_Module(MideFrameWork.Data.Entity.Base_ModuleEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Base_Module set ");
strSql.Append(" Name = @Name , ");
strSql.Append(" Memo = @Memo , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@Name", SqlDbType.NVarChar,128) , new SqlParameter("@Memo", SqlDbType.NVarChar,32) , new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.Name;
parameters[2].Value = info.Memo;
parameters[3].Value = info.CreateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateDistrict(MideFrameWork.Data.Entity.DistrictEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update District set ");
strSql.Append(" ParentID = @ParentID , ");
strSql.Append(" DistrictName = @DistrictName , ");
strSql.Append(" Status = @Status ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@ParentID", SqlDbType.Int,4) , new SqlParameter("@DistrictName", SqlDbType.NVarChar,32) , new SqlParameter("@Status", SqlDbType.Int,4)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.ParentID;
parameters[2].Value = info.DistrictName;
parameters[3].Value = info.Status;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateWG_Education(MideFrameWork.Data.Entity.WG_EducationEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update WG_Education set ");
strSql.Append(" Name = @Name , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" UpdateDate = @UpdateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@Name", SqlDbType.NVarChar,8) , new SqlParameter("@CreateDate", SqlDbType.DateTime) , new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.Name;
parameters[2].Value = info.CreateDate;
parameters[3].Value = info.UpdateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateWebSiteManagement(MideFrameWork.Data.Entity.WebSiteManagementEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update WebSiteManagement set ");
strSql.Append(" WebSiteName = @WebSiteName , ");
strSql.Append(" MetaKeywords = @MetaKeywords , ");
strSql.Append(" MetaDescriptions = @MetaDescriptions , ");
strSql.Append(" AdvPopupScript = @AdvPopupScript , ");
strSql.Append(" OwnerID = @OwnerID , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" UpdateDate = @UpdateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@WebSiteName", SqlDbType.NVarChar,256) , new SqlParameter("@MetaKeywords", SqlDbType.NVarChar,256) , new SqlParameter("@MetaDescriptions", SqlDbType.NVarChar,256) , new SqlParameter("@AdvPopupScript", SqlDbType.NVarChar) , new SqlParameter("@OwnerID", SqlDbType.Int,4) , new SqlParameter("@CreateDate", SqlDbType.DateTime) , new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.WebSiteName;
parameters[2].Value = info.MetaKeywords;
parameters[3].Value = info.MetaDescriptions;
parameters[4].Value = info.AdvPopupScript;
parameters[5].Value = info.OwnerID;
parameters[6].Value = info.CreateDate;
parameters[7].Value = info.UpdateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_Score(MideFrameWork.Data.Entity.WG_ScoreEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_Score(");
strSql.Append("MenberID,Scores,Title,CreateDate");
strSql.Append(") values (");
strSql.Append("@MenberID,@Scores,@Title,@CreateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MenberID", SqlDbType.Int,4) ,
new SqlParameter("@Scores", SqlDbType.Int,4) ,
new SqlParameter("@Title", SqlDbType.NVarChar,256) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.MenberID;
parameters[1].Value = info.Scores;
parameters[2].Value = info.Title;
parameters[3].Value = info.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateLog(MideFrameWork.Data.Entity.LogEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Log set ");
strSql.Append(" ModuleName = @ModuleName , ");
strSql.Append(" Operation = @Operation , ");
strSql.Append(" LogContent = @LogContent , ");
strSql.Append(" LogType = @LogType , ");
strSql.Append(" FromUserID = @FromUserID , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@ModuleName", SqlDbType.NVarChar,64) , new SqlParameter("@Operation", SqlDbType.NVarChar,64) , new SqlParameter("@LogContent", SqlDbType.NVarChar) , new SqlParameter("@LogType", SqlDbType.Int,4) , new SqlParameter("@FromUserID", SqlDbType.Int,4) , new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.ModuleName;
parameters[2].Value = info.Operation;
parameters[3].Value = info.LogContent;
parameters[4].Value = info.LogType;
parameters[5].Value = info.FromUserID;
parameters[6].Value = info.CreateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateWG_Score(MideFrameWork.Data.Entity.WG_ScoreEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update WG_Score set ");
strSql.Append(" MenberID = @MenberID , ");
strSql.Append(" Scores = @Scores , ");
strSql.Append(" Title = @Title , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@MenberID", SqlDbType.Int,4) , new SqlParameter("@Scores", SqlDbType.Int,4) , new SqlParameter("@Title", SqlDbType.NVarChar,256) , new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.MenberID;
parameters[2].Value = info.Scores;
parameters[3].Value = info.Title;
parameters[4].Value = info.CreateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddBase_Module(MideFrameWork.Data.Entity.Base_ModuleEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Base_Module(");
strSql.Append("Name,Memo,CreateDate");
strSql.Append(") values (");
strSql.Append("@Name,@Memo,@CreateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,128) ,
new SqlParameter("@Memo", SqlDbType.NVarChar,32) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.Name;
parameters[1].Value = info.Memo;
parameters[2].Value = info.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateRegisterDetail(MideFrameWork.Data.Entity.RegisterDetailEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update RegisterDetail set ");
strSql.Append(" UserID = @UserID , ");
strSql.Append(" Mac = @Mac , ");
strSql.Append(" IP = @IP , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@UserID", SqlDbType.Int,4) , new SqlParameter("@Mac", SqlDbType.NVarChar,64) , new SqlParameter("@IP", SqlDbType.NVarChar,64) , new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.UserID;
parameters[2].Value = info.Mac;
parameters[3].Value = info.IP;
parameters[4].Value = info.CreateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_Education(MideFrameWork.Data.Entity.WG_EducationEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_Education(");
strSql.Append("Name,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@Name,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,8) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.Name;
parameters[1].Value = info.CreateDate;
parameters[2].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateWG_OnGoingActivities(MideFrameWork.Data.Entity.WG_OnGoingActivitiesEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update WG_OnGoingActivities set ");
strSql.Append(" ActivityID = @ActivityID , ");
strSql.Append(" MenberID = @MenberID , ");
strSql.Append(" Status = @Status , ");
strSql.Append(" CreateDate = @CreateDate ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) , new SqlParameter("@ActivityID", SqlDbType.Int,4) , new SqlParameter("@MenberID", SqlDbType.Int,4) , new SqlParameter("@Status", SqlDbType.Int,4) , new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ID;
parameters[1].Value = info.ActivityID;
parameters[2].Value = info.MenberID;
parameters[3].Value = info.Status;
parameters[4].Value = info.CreateDate;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_OnGoingActivities(MideFrameWork.Data.Entity.WG_OnGoingActivitiesEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_OnGoingActivities(");
strSql.Append("ActivityID,MenberID,Status,CreateDate");
strSql.Append(") values (");
strSql.Append("@ActivityID,@MenberID,@Status,@CreateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ActivityID", SqlDbType.Int,4) ,
new SqlParameter("@MenberID", SqlDbType.Int,4) ,
new SqlParameter("@Status", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ActivityID;
parameters[1].Value = info.MenberID;
parameters[2].Value = info.Status;
parameters[3].Value = info.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_HelpRequest(MideFrameWork.Data.Entity.WG_HelpRequestEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_HelpRequest(");
strSql.Append("Title,Type,PromoterID,LinkMan,LinkPhone,BeginTime,Region,ServiceIntention,Duration,Detail,UnderTakerID,Status,Verification,Memo,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@Title,@Type,@PromoterID,@LinkMan,@LinkPhone,@BeginTime,@Region,@ServiceIntention,@Duration,@Detail,@UnderTakerID,@Status,@Verification,@Memo,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,256) ,
new SqlParameter("@Type", SqlDbType.Int,4) ,
new SqlParameter("@PromoterID", SqlDbType.Int,4) ,
new SqlParameter("@LinkMan", SqlDbType.NVarChar,32) ,
new SqlParameter("@LinkPhone", SqlDbType.NVarChar,11) ,
new SqlParameter("@BeginTime", SqlDbType.DateTime) ,
new SqlParameter("@Region", SqlDbType.NVarChar,64) ,
new SqlParameter("@ServiceIntention", SqlDbType.NVarChar,128) ,
new SqlParameter("@Duration", SqlDbType.Int,4) ,
new SqlParameter("@Detail", SqlDbType.NVarChar) ,
new SqlParameter("@UnderTakerID", SqlDbType.Int,4) ,
new SqlParameter("@Status", SqlDbType.Int,4) ,
new SqlParameter("@Verification", SqlDbType.NVarChar,512) ,
new SqlParameter("@Memo", SqlDbType.NVarChar,512) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.Title;
parameters[1].Value = info.Type;
parameters[2].Value = info.PromoterID;
parameters[3].Value = info.LinkMan;
parameters[4].Value = info.LinkPhone;
parameters[5].Value = info.BeginTime;
parameters[6].Value = info.Region;
parameters[7].Value = info.ServiceIntention;
parameters[8].Value = info.Duration;
parameters[9].Value = info.Detail;
parameters[10].Value = info.UnderTakerID;
parameters[11].Value = info.Status;
parameters[12].Value = info.Verification;
parameters[13].Value = info.Memo;
parameters[14].Value = info.CreateDate;
parameters[15].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddUsers(MideFrameWork.Data.Entity.UsersEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Users(");
strSql.Append("ChildAccount,ParentAccount,Status,GroupID,IsAdmin,Password,CorpName,Signature,ChannelID,Balance,Email,TelePhone,MobilePhone,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@ChildAccount,@ParentAccount,@Status,@GroupID,@IsAdmin,@Password,@CorpName,@Signature,@ChannelID,@Balance,@Email,@TelePhone,@MobilePhone,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ChildAccount", SqlDbType.NVarChar,32) ,
new SqlParameter("@ParentAccount", SqlDbType.NVarChar,32) ,
new SqlParameter("@Status", SqlDbType.Int,4) ,
new SqlParameter("@GroupID", SqlDbType.Int,4) ,
new SqlParameter("@IsAdmin", SqlDbType.SmallInt,2) ,
new SqlParameter("@Password", SqlDbType.NVarChar,64) ,
new SqlParameter("@CorpName", SqlDbType.NVarChar,32) ,
new SqlParameter("@Signature", SqlDbType.NVarChar,32) ,
new SqlParameter("@ChannelID", SqlDbType.Int,4) ,
new SqlParameter("@Balance", SqlDbType.Int,4) ,
new SqlParameter("@Email", SqlDbType.NVarChar,64) ,
new SqlParameter("@TelePhone", SqlDbType.NVarChar,16) ,
new SqlParameter("@MobilePhone", SqlDbType.NVarChar,16) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ChildAccount;
parameters[1].Value = info.ParentAccount;
parameters[2].Value = info.Status;
parameters[3].Value = info.GroupID;
parameters[4].Value = info.IsAdmin;
parameters[5].Value = info.Password;
parameters[6].Value = info.CorpName;
parameters[7].Value = info.Signature;
parameters[8].Value = info.ChannelID;
parameters[9].Value = info.Balance;
parameters[10].Value = info.Email;
parameters[11].Value = info.TelePhone;
parameters[12].Value = info.MobilePhone;
parameters[13].Value = info.CreateDate;
parameters[14].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_Activities(MideFrameWork.Data.Entity.WG_ActivitiesEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_Activities(");
strSql.Append("Title,PromoterID,LinkMan,LinkPhone,ActivityType,Region,Address,NeedMenberCount,BeginTime,Detail,Status,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@Title,@PromoterID,@LinkMan,@LinkPhone,@ActivityType,@Region,@Address,@NeedMenberCount,@BeginTime,@Detail,@Status,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,128) ,
new SqlParameter("@PromoterID", SqlDbType.Int,4) ,
new SqlParameter("@LinkMan", SqlDbType.NVarChar,32) ,
new SqlParameter("@LinkPhone", SqlDbType.NVarChar,11) ,
new SqlParameter("@ActivityType", SqlDbType.NVarChar,64) ,
new SqlParameter("@Region", SqlDbType.NVarChar,64) ,
new SqlParameter("@Address", SqlDbType.NVarChar,512) ,
new SqlParameter("@NeedMenberCount", SqlDbType.Int,4) ,
new SqlParameter("@BeginTime", SqlDbType.DateTime) ,
new SqlParameter("@Detail", SqlDbType.NVarChar) ,
new SqlParameter("@Status", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.Title;
parameters[1].Value = info.PromoterID;
parameters[2].Value = info.LinkMan;
parameters[3].Value = info.LinkPhone;
parameters[4].Value = info.ActivityType;
parameters[5].Value = info.Region;
parameters[6].Value = info.Address;
parameters[7].Value = info.NeedMenberCount;
parameters[8].Value = info.BeginTime;
parameters[9].Value = info.Detail;
parameters[10].Value = info.Status;
parameters[11].Value = info.CreateDate;
parameters[12].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddArticle(MideFrameWork.Data.Entity.ArticleEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Article(");
strSql.Append("TitleCN,TitleEN,TypeID,Context,Template,IconUrl,Attachment,IsEnable,DisplayIndex,CreateDate,UpdateDate,OwnerID");
strSql.Append(") values (");
strSql.Append("@TitleCN,@TitleEN,@TypeID,@Context,@Template,@IconUrl,@Attachment,@IsEnable,@DisplayIndex,@CreateDate,@UpdateDate,@OwnerID");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@TitleCN", SqlDbType.NVarChar,64) ,
new SqlParameter("@TitleEN", SqlDbType.NVarChar,128) ,
new SqlParameter("@TypeID", SqlDbType.Int,4) ,
new SqlParameter("@Context", SqlDbType.NVarChar) ,
new SqlParameter("@Template", SqlDbType.NVarChar,256) ,
new SqlParameter("@IconUrl", SqlDbType.NVarChar,256) ,
new SqlParameter("@Attachment", SqlDbType.NVarChar) ,
new SqlParameter("@IsEnable", SqlDbType.Int,4) ,
new SqlParameter("@DisplayIndex", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime) ,
new SqlParameter("@OwnerID", SqlDbType.Int,4)
};
parameters[0].Value = info.TitleCN;
parameters[1].Value = info.TitleEN;
parameters[2].Value = info.TypeID;
parameters[3].Value = info.Context;
parameters[4].Value = info.Template;
parameters[5].Value = info.IconUrl;
parameters[6].Value = info.Attachment;
parameters[7].Value = info.IsEnable;
parameters[8].Value = info.DisplayIndex;
parameters[9].Value = info.CreateDate;
parameters[10].Value = info.UpdateDate;
parameters[11].Value = info.OwnerID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_Team(MideFrameWork.Data.Entity.WG_TeamEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_Team(");
strSql.Append("Name,CaptainID,LinkMan,LinkPhone,LinkAddress,TeamAim,ServiceIntention,Region,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@Name,@CaptainID,@LinkMan,@LinkPhone,@LinkAddress,@TeamAim,@ServiceIntention,@Region,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,32) ,
new SqlParameter("@CaptainID", SqlDbType.Int,4) ,
new SqlParameter("@LinkMan", SqlDbType.NVarChar,32) ,
new SqlParameter("@LinkPhone", SqlDbType.NVarChar,11) ,
new SqlParameter("@LinkAddress", SqlDbType.NVarChar,128) ,
new SqlParameter("@TeamAim", SqlDbType.NVarChar,1024) ,
new SqlParameter("@ServiceIntention", SqlDbType.NVarChar,512) ,
new SqlParameter("@Region", SqlDbType.NVarChar,64) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.Name;
parameters[1].Value = info.CaptainID;
parameters[2].Value = info.LinkMan;
parameters[3].Value = info.LinkPhone;
parameters[4].Value = info.LinkAddress;
parameters[5].Value = info.TeamAim;
parameters[6].Value = info.ServiceIntention;
parameters[7].Value = info.Region;
parameters[8].Value = info.CreateDate;
parameters[9].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddArticleType(MideFrameWork.Data.Entity.ArticleTypeEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ArticleType(");
strSql.Append("TypeNameCN,TypeNameEN,IconUrl,LinkUrl,IsEnable,DisplayIndex,ParentID,OwerID,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@TypeNameCN,@TypeNameEN,@IconUrl,@LinkUrl,@IsEnable,@DisplayIndex,@ParentID,@OwerID,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@TypeNameCN", SqlDbType.NVarChar,32) ,
new SqlParameter("@TypeNameEN", SqlDbType.NVarChar,64) ,
new SqlParameter("@IconUrl", SqlDbType.NVarChar,256) ,
new SqlParameter("@LinkUrl", SqlDbType.NVarChar,256) ,
new SqlParameter("@IsEnable", SqlDbType.Int,4) ,
new SqlParameter("@DisplayIndex", SqlDbType.Int,4) ,
new SqlParameter("@ParentID", SqlDbType.Int,4) ,
new SqlParameter("@OwerID", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.TypeNameCN;
parameters[1].Value = info.TypeNameEN;
parameters[2].Value = info.IconUrl;
parameters[3].Value = info.LinkUrl;
parameters[4].Value = info.IsEnable;
parameters[5].Value = info.DisplayIndex;
parameters[6].Value = info.ParentID;
parameters[7].Value = info.OwerID;
parameters[8].Value = info.CreateDate;
parameters[9].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_Gifts(MideFrameWork.Data.Entity.WG_GiftsEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_Gifts(");
strSql.Append("Title,PhotoUrl,NeedScores,Count,Detail,Region,Status,CreateDate,UpdateDate");
strSql.Append(") values (");
strSql.Append("@Title,@PhotoUrl,@NeedScores,@Count,@Detail,@Region,@Status,@CreateDate,@UpdateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,32) ,
new SqlParameter("@PhotoUrl", SqlDbType.NVarChar,512) ,
new SqlParameter("@NeedScores", SqlDbType.Int,4) ,
new SqlParameter("@Count", SqlDbType.Int,4) ,
new SqlParameter("@Detail", SqlDbType.NVarChar) ,
new SqlParameter("@Region", SqlDbType.NVarChar,64) ,
new SqlParameter("@Status", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@UpdateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.Title;
parameters[1].Value = info.PhotoUrl;
parameters[2].Value = info.NeedScores;
parameters[3].Value = info.Count;
parameters[4].Value = info.Detail;
parameters[5].Value = info.Region;
parameters[6].Value = info.Status;
parameters[7].Value = info.CreateDate;
parameters[8].Value = info.UpdateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddMenu(MideFrameWork.Data.Entity.MenuEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Menu(");
strSql.Append("ParentID,DisplayName,DisplayIndex,GroupID,LinkUrl,ImageUrl,Status,CreateDate");
strSql.Append(") values (");
strSql.Append("@ParentID,@DisplayName,@DisplayIndex,@GroupID,@LinkUrl,@ImageUrl,@Status,@CreateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@ParentID", SqlDbType.Int,4) ,
new SqlParameter("@DisplayName", SqlDbType.NVarChar,32) ,
new SqlParameter("@DisplayIndex", SqlDbType.Int,4) ,
new SqlParameter("@GroupID", SqlDbType.Int,4) ,
new SqlParameter("@LinkUrl", SqlDbType.NVarChar) ,
new SqlParameter("@ImageUrl", SqlDbType.NVarChar) ,
new SqlParameter("@Status", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.ParentID;
parameters[1].Value = info.DisplayName;
parameters[2].Value = info.DisplayIndex;
parameters[3].Value = info.GroupID;
parameters[4].Value = info.LinkUrl;
parameters[5].Value = info.ImageUrl;
parameters[6].Value = info.Status;
parameters[7].Value = info.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddWG_Vender(MideFrameWork.Data.Entity.WG_VenderEntity info)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into WG_Vender(");
strSql.Append("VenderName,VenderType,Logo,Address,ComLevel,Phone,Memo,CreateDate");
strSql.Append(") values (");
strSql.Append("@VenderName,@VenderType,@Logo,@Address,@ComLevel,@Phone,@Memo,@CreateDate");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@VenderName", SqlDbType.NVarChar,50) ,
new SqlParameter("@VenderType", SqlDbType.Int,4) ,
new SqlParameter("@Logo", SqlDbType.NVarChar,256) ,
new SqlParameter("@Address", SqlDbType.NVarChar,256) ,
new SqlParameter("@ComLevel", SqlDbType.NVarChar,32) ,
new SqlParameter("@Phone", SqlDbType.NVarChar,11) ,
new SqlParameter("@Memo", SqlDbType.NVarChar,512) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = info.VenderName;
parameters[1].Value = info.VenderType;
parameters[2].Value = info.Logo;
parameters[3].Value = info.Address;
parameters[4].Value = info.ComLevel;
parameters[5].Value = info.Phone;
parameters[6].Value = info.Memo;
parameters[7].Value = info.CreateDate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
