/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.manager GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 a.id,role_id,role_name as ROLENAME,a.role_type,user_name,password,salt,real_name,telephone,email,is_lock,add_time,UNITID,avatar from " + databaseprefix + "manager a LEFT JOIN " + databaseprefix + "manager_role b on a.role_id=b.id");
strSql.Append(" where a.id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.manager model = new Model.manager();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
//if (ds.Tables[0].Rows[0]["id"].ToString() != "")
//{
// model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
//}
//if (ds.Tables[0].Rows[0]["role_id"].ToString() != "")
//{
// model.role_id = int.Parse(ds.Tables[0].Rows[0]["role_id"].ToString());
//}
//if (ds.Tables[0].Rows[0]["role_type"].ToString() != "")
//{
// model.role_type = int.Parse(ds.Tables[0].Rows[0]["role_type"].ToString());
//}
//model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
//model.password = ds.Tables[0].Rows[0]["password"].ToString();
//model.salt = ds.Tables[0].Rows[0]["salt"].ToString();
//model.real_name = ds.Tables[0].Rows[0]["real_name"].ToString();
//model.telephone = ds.Tables[0].Rows[0]["telephone"].ToString();
//model.email = ds.Tables[0].Rows[0]["email"].ToString();
//if (ds.Tables[0].Rows[0]["is_lock"].ToString() != "")
//{
// model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString());
//}
//if (ds.Tables[0].Rows[0]["add_time"].ToString() != "")
//{
// model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
//}
//model.UNITID = ds.Tables[0].Rows[0]["UNITID"].ToString();
model = new DBRowConvertor(ds.Tables[0].Rows[0]).ConvertToEntity <Model.manager>();
if (!string.IsNullOrEmpty(model.UNITID))
{
model.UNITNAME = Model.dt_units.GetUnit(model.UNITID)?.UNITNAME;
}
return(model);
}
else
{
return(null);
}
}
public static object GetPicture(string PICID)
{
byte[] img = null;
if (string.IsNullOrEmpty(PICID))
{
return(null);
}
DataTable dt = MSSQLDbHelper.Instance.ExecuteTable("select * from dt_PICTURE where PICID=@PICID", new System.Data.SqlClient.SqlParameter("@PICID", PICID));
if (dt.Rows.Count == 0)
{
return(null);
}
else
{
var dr = dt.Rows[0];
if (dr[0] is DBNull)
{
return(null);
}
dt_picture pic = new DBRowConvertor(dr).ConvertToEntity <dt_picture>();
if (pic.type == 1)
{
//if (!File.Exists(pic.url))
//{
// return null;
//}
//Stream stream = new FileStream(pic.url,FileMode.Open);
//img = new byte[stream.Length];
//stream.Read(img, 0, img.Length);
//stream.Close();
return(pic.url);
}
else if (pic.type == 2)
{
}
else if (pic.type == 3)
{
img = pic.data;
}
}
return(img);
}
public dt_pictureview GetByUserId(int userid)
{
string sql = "SELECT A.* FROM DT_PICTUREVIEW A WHERE A.ISVALID=1 AND A.USERID=@USERID ORDER BY UPDATETIME DESC";
var dt = MSSQLDbHelper.Instance.ExecuteTable(sql, new System.Data.SqlClient.SqlParameter("@USERID", userid));
if (dt.Rows.Count > 0)
{
var item = new DBRowConvertor(dt.Rows[0]).ConvertToEntity <dt_pictureview>();
if (!string.IsNullOrEmpty(item.pictures))
{
item.Viewer = JsonHelper2.Deserialize <List <ViewModel> >(item.pictures).OrderBy(p => p.sort).ToList();
item.pictures = string.Empty;
}
return(item);
}
else
{
return(null);
}
}
