/// <summary>
/// 获得数据列表
/// </summary>
public List <Test_Model.sys_sysfiles> DataTableToList(DataTable dt)
{
List <Test_Model.sys_sysfiles> modelList = new List <Test_Model.sys_sysfiles>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Test_Model.sys_sysfiles model;
for (int n = 0; n < rowsCount; n++)
{
model = new Test_Model.sys_sysfiles();
if (dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
model.filesUrl = dt.Rows[n]["filesUrl"].ToString();
model.describe = dt.Rows[n]["describe"].ToString();
if (dt.Rows[n]["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(dt.Rows[n]["addTime"].ToString());
}
if (dt.Rows[n]["addUserId"].ToString() != "")
{
model.addUserId = int.Parse(dt.Rows[n]["addUserId"].ToString());
}
model.addUser = dt.Rows[n]["addUser"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Test_Model.sys_sysfiles> DataTableToList(DataTable dt)
{
List<Test_Model.sys_sysfiles> modelList = new List<Test_Model.sys_sysfiles>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Test_Model.sys_sysfiles model;
for (int n = 0; n < rowsCount; n++)
{
model = new Test_Model.sys_sysfiles();
if(dt.Rows[n]["id"].ToString()!="")
{
model.id=int.Parse(dt.Rows[n]["id"].ToString());
}
model.filesUrl=dt.Rows[n]["filesUrl"].ToString();
model.describe=dt.Rows[n]["describe"].ToString();
if(dt.Rows[n]["addTime"].ToString()!="")
{
model.addTime=DateTime.Parse(dt.Rows[n]["addTime"].ToString());
}
if(dt.Rows[n]["addUserId"].ToString()!="")
{
model.addUserId=int.Parse(dt.Rows[n]["addUserId"].ToString());
}
model.addUser=dt.Rows[n]["addUser"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_sysfiles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_sys_sysfiles set ");
strSql.Append("classId=@classId,");
strSql.Append("fielsName=@fielsName,");
strSql.Append("filesUrl=@filesUrl,");
strSql.Append("describe=@describe,");
strSql.Append("showLeft=@showLeft,");
strSql.Append("addTime=@addTime,");
strSql.Append("addUserId=@addUserId,");
strSql.Append("addUser=@addUser,");
strSql.Append("filesOrder=@filesOrder");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@classId", SqlDbType.Int, 4),
new SqlParameter("@fielsName", SqlDbType.NChar, 10),
new SqlParameter("@filesUrl", SqlDbType.NVarChar, 50),
new SqlParameter("@describe", SqlDbType.NVarChar, 20),
new SqlParameter("@showLeft", SqlDbType.Bit, 1),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addUserId", SqlDbType.Int, 4),
new SqlParameter("@addUser", SqlDbType.NVarChar, 15),
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@filesOrder", SqlDbType.Int, 4)
};
parameters[0].Value = model.classId;
parameters[1].Value = model.fielsName;
parameters[2].Value = model.filesUrl;
parameters[3].Value = model.describe;
parameters[4].Value = model.showLeft;
parameters[5].Value = model.addTime;
parameters[6].Value = model.addUserId;
parameters[7].Value = model.addUser;
parameters[8].Value = model.id;
parameters[9].Value = model.filesOrder;
int rows = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
return(rows > 0);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_sysfiles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_sys_sysfiles(");
strSql.Append("classId,fielsName,filesUrl,describe,showLeft,addTime,addUserId,addUser,filesOrder)");
strSql.Append(" values (");
strSql.Append("@classId,@fielsName,@filesUrl,@describe,@showLeft,@addTime,@addUserId,@addUser,@filesOrder)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@classId", SqlDbType.Int, 4),
new SqlParameter("@fielsName", SqlDbType.NChar, 10),
new SqlParameter("@filesUrl", SqlDbType.NVarChar, 50),
new SqlParameter("@describe", SqlDbType.NVarChar, 20),
new SqlParameter("@showLeft", SqlDbType.Bit, 1),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@addUserId", SqlDbType.Int, 4),
new SqlParameter("@addUser", SqlDbType.NVarChar, 15),
new SqlParameter("@filesOrder", SqlDbType.Int, 4)
};
parameters[0].Value = model.classId;
parameters[1].Value = model.fielsName;
parameters[2].Value = model.filesUrl;
parameters[3].Value = model.describe;
parameters[4].Value = model.showLeft;
parameters[5].Value = model.addTime;
parameters[6].Value = model.addUserId;
parameters[7].Value = model.addUser;
parameters[8].Value = model.filesOrder;
object obj = SqlHelper.ExecuteSql(connectionString, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Test_Model.sys_sysfiles GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,classId,fielsName,filesUrl,describe,showLeft,addTime,addUserId,addUser,filesOrder from tb_sys_sysfiles ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
Test_Model.sys_sysfiles model = new Test_Model.sys_sysfiles();
DataSet ds = SqlHelper.ExecuteDataSet(connectionString, 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]["classId"].ToString() != "")
{
model.classId = int.Parse(ds.Tables[0].Rows[0]["classId"].ToString());
}
if (ds.Tables[0].Rows[0]["fielsName"] != null)
{
model.fielsName = ds.Tables[0].Rows[0]["fielsName"].ToString();
}
if (ds.Tables[0].Rows[0]["filesUrl"] != null)
{
model.filesUrl = ds.Tables[0].Rows[0]["filesUrl"].ToString();
}
if (ds.Tables[0].Rows[0]["describe"] != null)
{
model.describe = ds.Tables[0].Rows[0]["describe"].ToString();
}
if (ds.Tables[0].Rows[0]["showLeft"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["showLeft"].ToString() == "1") || (ds.Tables[0].Rows[0]["showLeft"].ToString().ToLower() == "true"))
{
model.showLeft = true;
}
else
{
model.showLeft = false;
}
}
if (ds.Tables[0].Rows[0]["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(ds.Tables[0].Rows[0]["addTime"].ToString());
}
if (ds.Tables[0].Rows[0]["addUserId"].ToString() != "")
{
model.addUserId = int.Parse(ds.Tables[0].Rows[0]["addUserId"].ToString());
}
if (ds.Tables[0].Rows[0]["addUser"] != null)
{
model.addUser = ds.Tables[0].Rows[0]["addUser"].ToString();
}
if (ds.Tables[0].Rows[0]["filesOrder"] != null)
{
model.filesOrder = int.Parse(ds.Tables[0].Rows[0]["filesOrder"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Test_Model.sys_sysfiles model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Test_Model.sys_sysfiles model)
{
return(dal.Add(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Test_Model.sys_sysfiles GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,classId,fielsName,filesUrl,describe,showLeft,addTime,addUserId,addUser,filesOrder from tb_sys_sysfiles ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Test_Model.sys_sysfiles model = new Test_Model.sys_sysfiles();
DataSet ds = SqlHelper.ExecuteDataSet(connectionString, 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]["classId"].ToString() != "")
{
model.classId = int.Parse(ds.Tables[0].Rows[0]["classId"].ToString());
}
if (ds.Tables[0].Rows[0]["fielsName"] != null)
{
model.fielsName = ds.Tables[0].Rows[0]["fielsName"].ToString();
}
if (ds.Tables[0].Rows[0]["filesUrl"] != null)
{
model.filesUrl = ds.Tables[0].Rows[0]["filesUrl"].ToString();
}
if (ds.Tables[0].Rows[0]["describe"] != null)
{
model.describe = ds.Tables[0].Rows[0]["describe"].ToString();
}
if (ds.Tables[0].Rows[0]["showLeft"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["showLeft"].ToString() == "1") || (ds.Tables[0].Rows[0]["showLeft"].ToString().ToLower() == "true"))
{
model.showLeft = true;
}
else
{
model.showLeft = false;
}
}
if (ds.Tables[0].Rows[0]["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(ds.Tables[0].Rows[0]["addTime"].ToString());
}
if (ds.Tables[0].Rows[0]["addUserId"].ToString() != "")
{
model.addUserId = int.Parse(ds.Tables[0].Rows[0]["addUserId"].ToString());
}
if (ds.Tables[0].Rows[0]["addUser"] != null)
{
model.addUser = ds.Tables[0].Rows[0]["addUser"].ToString();
}
if (ds.Tables[0].Rows[0]["filesOrder"] != null)
{
model.filesOrder = int.Parse(ds.Tables[0].Rows[0]["filesOrder"].ToString());
}
return(model);
}
else
{
return(null);
}
}
