/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.T_Group model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Group(");
strSql.Append("GroupName,AddMember,Role,Variable,deletable)");
strSql.Append(" values (");
strSql.Append("@GroupName,@AddMember,@Role,@Variable,@deletable)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@GroupName", SqlDbType.NVarChar, 200),
new SqlParameter("@AddMember", SqlDbType.Bit, 1),
new SqlParameter("@Role", SqlDbType.NVarChar, 500),
new SqlParameter("@Variable", SqlDbType.Bit, 1),
new SqlParameter("@deletable", SqlDbType.Bit, 1)
};
parameters[0].Value = model.GroupName;
parameters[1].Value = model.AddMember;
parameters[2].Value = model.Role;
parameters[3].Value = model.Variable;
parameters[4].Value = model.deletable;
object obj = DbPlatFormBaseHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,CheckTime,UserID,PointID,VerifyUser,Verify,Remark ");
strSql.Append(" FROM T_UserStation ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,GroupName,AddMember,Role,Variable,deletable ");
strSql.Append(" FROM T_Group ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,UserID,UserName,UserPws,UserAddress,UserPhone,State,GroupID,Department,LastLogin ");
strSql.Append(" FROM T_User ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,Name,Pid,Tag,pType,sort,enable ");
strSql.Append(" FROM T_Right ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_User set ");
strSql.Append("UserID=@UserID,");
strSql.Append("UserName=@UserName,");
strSql.Append("UserPws=@UserPws,");
strSql.Append("UserAddress=@UserAddress,");
strSql.Append("UserPhone=@UserPhone,");
strSql.Append("State=@State,");
strSql.Append("GroupID=@GroupID,");
strSql.Append("Department=@Department,");
strSql.Append("LastLogin=@LastLogin");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.VarChar, 20),
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@UserPws", SqlDbType.NVarChar, 20),
new SqlParameter("@UserAddress", SqlDbType.NVarChar, 2000),
new SqlParameter("@UserPhone", SqlDbType.NVarChar, 11),
new SqlParameter("@State", SqlDbType.Bit, 1),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@Department", SqlDbType.NVarChar, 50),
new SqlParameter("@LastLogin", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserPws;
parameters[3].Value = model.UserAddress;
parameters[4].Value = model.UserPhone;
parameters[5].Value = model.State;
parameters[6].Value = model.GroupID;
parameters[7].Value = model.Department;
parameters[8].Value = model.LastLogin;
parameters[9].Value = model.ID;
int rows = DbPlatFormBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_Group");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
return(DbPlatFormBaseHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string IDlist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_Group ");
strSql.Append(" where ID in (" + IDlist + ") ");
int rows = DbPlatFormBaseHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ID,UserID,UserName,UserPws,UserAddress,UserPhone,State,GroupID,Department,LastLogin ");
strSql.Append(" FROM T_User ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ID,GroupName,AddMember,Role,Variable,deletable ");
strSql.Append(" FROM T_Group ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ID,Name,Pid,Tag,pType,sort,enable ");
strSql.Append(" FROM T_Right ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strWhere, string filedOrder)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(" ID,CheckTime,UserID,PointID,VerifyUser,Verify,Remark ");
strSql.Append(" FROM T_UserStation ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.T_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_User(");
strSql.Append("UserID,UserName,UserPws,UserAddress,UserPhone,State,GroupID,Department,LastLogin)");
strSql.Append(" values (");
strSql.Append("@UserID,@UserName,@UserPws,@UserAddress,@UserPhone,@State,@GroupID,@Department,@LastLogin)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.VarChar, 20),
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@UserPws", SqlDbType.NVarChar, 20),
new SqlParameter("@UserAddress", SqlDbType.NVarChar, 2000),
new SqlParameter("@UserPhone", SqlDbType.NVarChar, 11),
new SqlParameter("@State", SqlDbType.Bit, 1),
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@Department", SqlDbType.NVarChar, 50),
new SqlParameter("@LastLogin", SqlDbType.DateTime)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserPws;
parameters[3].Value = model.UserAddress;
parameters[4].Value = model.UserPhone;
parameters[5].Value = model.State;
parameters[6].Value = model.GroupID;
parameters[7].Value = model.Department;
parameters[8].Value = model.LastLogin;
object obj = DbPlatFormBaseHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_UserStation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_UserStation set ");
strSql.Append("CheckTime=@CheckTime,");
strSql.Append("UserID=@UserID,");
strSql.Append("PointID=@PointID,");
strSql.Append("VerifyUser=@VerifyUser,");
strSql.Append("Verify=@Verify,");
strSql.Append("Remark=@Remark");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CheckTime", SqlDbType.DateTime),
new SqlParameter("@UserID", SqlDbType.VarChar, 20),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@VerifyUser", SqlDbType.Int, 4),
new SqlParameter("@Verify", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 250),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CheckTime;
parameters[1].Value = model.UserID;
parameters[2].Value = model.PointID;
parameters[3].Value = model.VerifyUser;
parameters[4].Value = model.Verify;
parameters[5].Value = model.Remark;
parameters[6].Value = model.ID;
int rows = DbPlatFormBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_Right model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Right set ");
strSql.Append("Name=@Name,");
strSql.Append("Pid=@Pid,");
strSql.Append("Tag=@Tag,");
strSql.Append("pType=@pType,");
strSql.Append("sort=@sort,");
strSql.Append("enable=@enable");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@Tag", SqlDbType.VarChar, 20),
new SqlParameter("@pType", SqlDbType.VarChar, 10),
new SqlParameter("@sort", SqlDbType.Int, 4),
new SqlParameter("@enable", SqlDbType.Bit, 1),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Pid;
parameters[2].Value = model.Tag;
parameters[3].Value = model.pType;
parameters[4].Value = model.sort;
parameters[5].Value = model.enable;
parameters[6].Value = model.ID;
int rows = DbPlatFormBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.T_Group model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Group set ");
strSql.Append("GroupName=@GroupName,");
strSql.Append("AddMember=@AddMember,");
strSql.Append("Role=@Role,");
strSql.Append("Variable=@Variable,");
strSql.Append("deletable=@deletable");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@GroupName", SqlDbType.NVarChar, 200),
new SqlParameter("@AddMember", SqlDbType.Bit, 1),
new SqlParameter("@Role", SqlDbType.NVarChar, 500),
new SqlParameter("@Variable", SqlDbType.Bit, 1),
new SqlParameter("@deletable", SqlDbType.Bit, 1),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.GroupName;
parameters[1].Value = model.AddMember;
parameters[2].Value = model.Role;
parameters[3].Value = model.Variable;
parameters[4].Value = model.deletable;
parameters[5].Value = model.ID;
int rows = DbPlatFormBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from T_Group ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
int rows = DbPlatFormBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby);
}
else
{
strSql.Append("order by T.ID desc");
}
strSql.Append(")AS Row, T.* from T_Group T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return(DbPlatFormBaseHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.T_Right model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Right(");
strSql.Append("ID,Name,Pid,Tag,pType,sort,enable)");
strSql.Append(" values (");
strSql.Append("@ID,@Name,@Pid,@Tag,@pType,@sort,@enable)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@Tag", SqlDbType.VarChar, 20),
new SqlParameter("@pType", SqlDbType.VarChar, 10),
new SqlParameter("@sort", SqlDbType.Int, 4),
new SqlParameter("@enable", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Name;
parameters[2].Value = model.Pid;
parameters[3].Value = model.Tag;
parameters[4].Value = model.pType;
parameters[5].Value = model.sort;
parameters[6].Value = model.enable;
int rows = DbPlatFormBaseHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.T_Right GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,Pid,Tag,pType,sort,enable from T_Right ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.T_Right model = new Maticsoft.Model.T_Right();
DataSet ds = DbPlatFormBaseHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.T_UserStation GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CheckTime,UserID,PointID,VerifyUser,Verify,Remark from T_UserStation ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.T_UserStation model = new Maticsoft.Model.T_UserStation();
DataSet ds = DbPlatFormBaseHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.T_User GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UserID,UserName,UserPws,UserAddress,UserPhone,State,GroupID,Department,LastLogin from T_User ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.T_User model = new Maticsoft.Model.T_User();
DataSet ds = DbPlatFormBaseHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.T_Group GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,GroupName,AddMember,Role,Variable,deletable from T_Group ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.T_Group model = new Maticsoft.Model.T_Group();
DataSet ds = DbPlatFormBaseHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.T_UserStation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_UserStation(");
strSql.Append("CheckTime,UserID,PointID,VerifyUser,Verify,Remark)");
strSql.Append(" values (");
strSql.Append("@CheckTime,@UserID,@PointID,@VerifyUser,@Verify,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CheckTime", SqlDbType.DateTime),
new SqlParameter("@UserID", SqlDbType.VarChar, 20),
new SqlParameter("@PointID", SqlDbType.Int, 4),
new SqlParameter("@VerifyUser", SqlDbType.Int, 4),
new SqlParameter("@Verify", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 250)
};
parameters[0].Value = model.CheckTime;
parameters[1].Value = model.UserID;
parameters[2].Value = model.PointID;
parameters[3].Value = model.VerifyUser;
parameters[4].Value = model.Verify;
parameters[5].Value = model.Remark;
object obj = DbPlatFormBaseHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbPlatFormBaseHelperSQL.GetMaxID("ID", "T_Group"));
}
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return(DbPlatFormBaseHelperSQL.GetMaxID("ID", "T_UserStation"));
}
