/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.PowerEntity GetEntity(int Pid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Pid,PName,Setting from [OA_Power] ");
strSql.Append(" where Pid=@Pid ");
SqlParameter[] parameters =
{
new SqlParameter("@Pid", SqlDbType.Int, 4)
};
parameters[0].Value = Pid;
Entity.PowerEntity model = new Entity.PowerEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Pid"].ToString() != "")
{
model.Pid = int.Parse(ds.Tables[0].Rows[0]["Pid"].ToString());
}
model.PName = ds.Tables[0].Rows[0]["PName"].ToString();
model.Setting = ds.Tables[0].Rows[0]["Setting"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.PowerEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [OA_Power](");
strSql.Append("PName)");
strSql.Append(" values (");
strSql.Append("@PName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@PName", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.PName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
//获取角色
string Getposi(int uid)
{
string sql = "select * from [OA_Power] where Pid = (select Pid FROM [OA_User] where uid ='" + uid + "')";
Entity.PowerEntity posi = new Entity.PowerEntity();
posi = new JumbotOA.BLL.UserBLL().Getpomodel(sql);
string pname = posi.PName;
return(pname);
}
/// <summary>
/// 获取角色
/// </summary>
/// <param name="kls_uid"></param>
/// <param name="kls_pwd"></param>
/// <param name="kls_num"></param>
/// <returns></returns>
public Entity.PowerEntity Getpomodel(string sql)
{
Entity.PowerEntity pos = new Entity.PowerEntity();
SqlDataReader dr = DbHelperSQL.ExecuteReader(sql);
if (dr.Read())
{
pos.Pid = Convert.ToInt32(dr["Pid"]);
pos.PName = dr["PName"].ToString();
}
return(pos);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Entity.PowerEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [OA_Power] set ");
strSql.Append("PName=@PName");
strSql.Append(" where Pid=@Pid ");
SqlParameter[] parameters =
{
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@PName", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.Pid;
parameters[1].Value = model.PName;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// ��������б�
/// </summary>
public List<Entity.PowerEntity> DataTableToList(DataTable dt)
{
List<Entity.PowerEntity> modelList = new List<Entity.PowerEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Entity.PowerEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new Entity.PowerEntity();
if(dt.Rows[n]["Pid"].ToString()!="")
{
model.Pid=int.Parse(dt.Rows[n]["Pid"].ToString());
}
model.PName=dt.Rows[n]["PName"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Entity.PowerEntity> DataTableToList(DataTable dt)
{
List <Entity.PowerEntity> modelList = new List <Entity.PowerEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Entity.PowerEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new Entity.PowerEntity();
if (dt.Rows[n]["Pid"].ToString() != "")
{
model.Pid = int.Parse(dt.Rows[n]["Pid"].ToString());
}
model.PName = dt.Rows[n]["PName"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public Entity.PowerEntity GetEntity(int Pid)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Pid,PName,Setting from [OA_Power] ");
strSql.Append(" where Pid=@Pid ");
SqlParameter[] parameters = {
new SqlParameter("@Pid", SqlDbType.Int,4)};
parameters[0].Value = Pid;
Entity.PowerEntity model=new Entity.PowerEntity();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["Pid"].ToString()!="")
{
model.Pid=int.Parse(ds.Tables[0].Rows[0]["Pid"].ToString());
}
model.PName=ds.Tables[0].Rows[0]["PName"].ToString();
model.Setting = ds.Tables[0].Rows[0]["Setting"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Entity.PowerEntity model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.PowerEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// ��ȡ��ɫ
/// </summary>
/// <param name="kls_uid"></param>
/// <param name="kls_pwd"></param>
/// <param name="kls_num"></param>
/// <returns></returns>
public Entity.PowerEntity Getpomodel(string sql)
{
Entity.PowerEntity pos = new Entity.PowerEntity();
SqlDataReader dr = DbHelperSQL.ExecuteReader(sql);
if (dr.Read())
{
pos.Pid = Convert.ToInt32(dr["Pid"]);
pos.PName = dr["PName"].ToString();
}
return pos;
}
//获取角色
string Getposi(int uid)
{
string sql = "select * from [OA_Power] where Pid = (select Pid FROM [OA_User] where uid ='" + uid + "')";
Entity.PowerEntity posi = new Entity.PowerEntity();
posi = new JumbotOA.BLL.UserBLL().Getpomodel(sql);
string pname = posi.PName;
return pname;
}
