/// <summary> /// ��������б� /// </summary> public List<Entity.Workplaninfo> DataTableToList(DataTable dt) { List<Entity.Workplaninfo> modelList = new List<Entity.Workplaninfo>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Entity.Workplaninfo model; for (int n = 0; n < rowsCount; n++) { model = new Entity.Workplaninfo(); if(dt.Rows[n]["Wid"].ToString()!="") { model.Wid=int.Parse(dt.Rows[n]["Wid"].ToString()); } if(dt.Rows[n]["Uid"].ToString()!="") { model.Uid=int.Parse(dt.Rows[n]["Uid"].ToString()); } if(dt.Rows[n]["Wdate"].ToString()!="") { model.Wdate=DateTime.Parse(dt.Rows[n]["Wdate"].ToString()); } model.Wtext=dt.Rows[n]["Wtext"].ToString(); modelList.Add(model); } } return modelList; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.Workplaninfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Workplaninfo("); strSql.Append("Uid,Wdate,Wtext)"); strSql.Append(" values ("); strSql.Append("@Uid,@Wdate,@Wtext)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@Wdate", SqlDbType.DateTime), new SqlParameter("@Wtext", SqlDbType.VarChar, 1000) }; parameters[0].Value = model.Uid; parameters[1].Value = model.Wdate; parameters[2].Value = model.Wtext; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获得数据列表 /// </summary> public List <Entity.Workplaninfo> DataTableToList(DataTable dt) { List <Entity.Workplaninfo> modelList = new List <Entity.Workplaninfo>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Entity.Workplaninfo model; for (int n = 0; n < rowsCount; n++) { model = new Entity.Workplaninfo(); if (dt.Rows[n]["Wid"].ToString() != "") { model.Wid = int.Parse(dt.Rows[n]["Wid"].ToString()); } if (dt.Rows[n]["Uid"].ToString() != "") { model.Uid = int.Parse(dt.Rows[n]["Uid"].ToString()); } if (dt.Rows[n]["Wdate"].ToString() != "") { model.Wdate = DateTime.Parse(dt.Rows[n]["Wdate"].ToString()); } model.Wtext = dt.Rows[n]["Wtext"].ToString(); modelList.Add(model); } } return(modelList); }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "Workplaninfo"; * parameters[1].Value = "ID"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ public List <Entity.Workplaninfo> getpage(int pageSize, int pageNum, out int count, string str) { string select, table, where, order; select = " * "; table = "workplaninfo "; StringBuilder sb = new StringBuilder(); sb.Append(" ( 1 = 1 ) " + str); where = sb.ToString(); order = "Wid"; string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum "; SqlParameter[] paras = { new SqlParameter("@select", select), new SqlParameter("@table", table), new SqlParameter("@where", where), new SqlParameter("@orderField", order), new SqlParameter("@orderType", '1'), new SqlParameter("@pageSize", pageSize), new SqlParameter("@pageNum", pageNum) }; DataSet ds = DbHelperSQL.Query(sql, paras); count = Convert.ToInt32(ds.Tables[1].Rows[0][0]); List <Entity.Workplaninfo> list = new List <Entity.Workplaninfo>(); Entity.Workplaninfo model; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new Entity.Workplaninfo(); if (ds.Tables[0].Rows[i]["Wid"].ToString() != "") { model.Wid = int.Parse(ds.Tables[0].Rows[i]["Wid"].ToString()); } if (ds.Tables[0].Rows[i]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[i]["Uid"].ToString()); } model.Wdate = Convert.ToDateTime(ds.Tables[0].Rows[i]["Wdate"].ToString()); model.Wtext = ds.Tables[0].Rows[i]["Wtext"].ToString(); list.Add(model); } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Entity.Workplaninfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Workplaninfo set "); strSql.Append("Uid=@Uid,"); strSql.Append("Wdate=@Wdate,"); strSql.Append("Wtext=@Wtext"); strSql.Append(" where Wid=@Wid "); SqlParameter[] parameters = { new SqlParameter("@Wid", SqlDbType.Int, 4), new SqlParameter("@Uid", SqlDbType.Int, 4), new SqlParameter("@Wdate", SqlDbType.DateTime), new SqlParameter("@Wtext", SqlDbType.VarChar, 1000) }; parameters[0].Value = model.Wid; parameters[1].Value = model.Uid; parameters[2].Value = model.Wdate; parameters[3].Value = model.Wtext; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.Workplaninfo GetEntity(int Wid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Wid,Uid,Wdate,Wtext from Workplaninfo "); strSql.Append(" where Wid=@Wid "); SqlParameter[] parameters = { new SqlParameter("@Wid", SqlDbType.Int, 4) }; parameters[0].Value = Wid; Entity.Workplaninfo model = new Entity.Workplaninfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Wid"].ToString() != "") { model.Wid = int.Parse(ds.Tables[0].Rows[0]["Wid"].ToString()); } if (ds.Tables[0].Rows[0]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString()); } if (ds.Tables[0].Rows[0]["Wdate"].ToString() != "") { model.Wdate = DateTime.Parse(ds.Tables[0].Rows[0]["Wdate"].ToString()); } model.Wtext = ds.Tables[0].Rows[0]["Wtext"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Entity.Workplaninfo model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.Workplaninfo model) { return(dal.Add(model)); }
/* /// <summary> /// ��ҳ��ȡ�����б� /// </summary> public DataSet GetList(int PageSize,int PageIndex,string strWhere) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Bit), new SqlParameter("@OrderType", SqlDbType.Bit), new SqlParameter("@strWhere", SqlDbType.VarChar,1000), }; parameters[0].Value = "Workplaninfo"; parameters[1].Value = "ID"; parameters[2].Value = PageSize; parameters[3].Value = PageIndex; parameters[4].Value = 0; parameters[5].Value = 0; parameters[6].Value = strWhere; return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); }*/ public List<Entity.Workplaninfo> getpage(int pageSize, int pageNum, out int count, string str) { string select, table, where, order; select = " * "; table = "workplaninfo "; StringBuilder sb = new StringBuilder(); sb.Append(" ( 1 = 1 ) " + str); where = sb.ToString(); order = "Wid"; string sql = "exec Pagination @select, @table, @where, @orderField, @orderType, @pageSize, @pageNum "; SqlParameter[] paras ={ new SqlParameter("@select", select), new SqlParameter("@table", table), new SqlParameter("@where", where), new SqlParameter("@orderField", order), new SqlParameter("@orderType", '1'), new SqlParameter("@pageSize", pageSize), new SqlParameter("@pageNum", pageNum) }; DataSet ds = DbHelperSQL.Query(sql, paras); count = Convert.ToInt32(ds.Tables[1].Rows[0][0]); List<Entity.Workplaninfo> list = new List<Entity.Workplaninfo>(); Entity.Workplaninfo model; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { model = new Entity.Workplaninfo(); if (ds.Tables[0].Rows[i]["Wid"].ToString() != "") { model.Wid = int.Parse(ds.Tables[0].Rows[i]["Wid"].ToString()); } if (ds.Tables[0].Rows[i]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[i]["Uid"].ToString()); } model.Wdate = Convert.ToDateTime(ds.Tables[0].Rows[i]["Wdate"].ToString()); model.Wtext = ds.Tables[0].Rows[i]["Wtext"].ToString(); list.Add(model); } return list; }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Entity.Workplaninfo GetEntity(int Wid) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Wid,Uid,Wdate,Wtext from Workplaninfo "); strSql.Append(" where Wid=@Wid "); SqlParameter[] parameters = { new SqlParameter("@Wid", SqlDbType.Int,4)}; parameters[0].Value = Wid; Entity.Workplaninfo model=new Entity.Workplaninfo(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["Wid"].ToString()!="") { model.Wid=int.Parse(ds.Tables[0].Rows[0]["Wid"].ToString()); } if(ds.Tables[0].Rows[0]["Uid"].ToString()!="") { model.Uid=int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString()); } if(ds.Tables[0].Rows[0]["Wdate"].ToString()!="") { model.Wdate=DateTime.Parse(ds.Tables[0].Rows[0]["Wdate"].ToString()); } model.Wtext=ds.Tables[0].Rows[0]["Wtext"].ToString(); return model; } else { return null; } }