/// <summary> ///根据查询获取主表对象集合 /// </summary> /// <param name="tempsql">查询语句</param> /// <param name="sps">参数</param> /// <returns>主表对象集合</returns> public IList <Sys_Note> ListMaker(string tempsql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(tempsql, sps, false); IList <Sys_Note> list = new List <Sys_Note>(); foreach (DataRow dr in dt.Rows) { Sys_Note model = new Sys_Note(); model.sysCode = dr["sysCode"].ToString(); model.afterstr = dr["afterstr"].ToString(); model.opeDiscretion = dr["opeDiscretion"].ToString(); model.note1 = dr["note1"].ToString(); model.note2 = dr["note2"].ToString(); model.note3 = dr["note3"].ToString(); model.note4 = dr["note4"].ToString(); model.note5 = dr["note5"].ToString(); model.note6 = dr["note6"].ToString(); model.note7 = dr["note7"].ToString(); model.note8 = dr["note8"].ToString(); model.billcode = dr["billcode"].ToString(); model.note9 = dr["note9"].ToString(); model.note10 = dr["note10"].ToString(); model.note11 = dr["note11"].ToString(); model.note12 = dr["note12"].ToString(); model.note13 = dr["note13"].ToString(); model.note14 = dr["note14"].ToString(); model.note15 = dr["note15"].ToString(); model.note16 = dr["note16"].ToString(); model.note17 = dr["note17"].ToString(); model.note18 = dr["note18"].ToString(); model.billname = dr["billname"].ToString(); model.note19 = dr["note19"].ToString(); model.note20 = dr["note20"].ToString(); model.usercode = dr["usercode"].ToString(); model.billtype = dr["billtype"].ToString(); model.OperationType = dr["OperationType"].ToString(); model.userip = dr["userip"].ToString(); if (!DBNull.Value.Equals(dr["ndate"])) { model.ndate = DateTime.Parse(dr["ndate"].ToString()); } model.beforestr = dr["beforestr"].ToString(); list.Add(model); } return(list); }
public static JsonObj ConvertToJsonStr(ListData obj, string sql, string sqlCount, string rowNumName) { //获取分页数据结果 string sqlFrame = "select * from ({0}) t where t.{1}>{2} and t.{1}<={3}"; sqlFrame = string.Format(sqlFrame, sql, rowNumName, obj.beg, obj.end); DataTable dtRel = DataHelper.GetDataTable(sqlFrame); List <object> rows = dtRel.ToDictionaryList(); //获取总记录数 int total = Convert.ToInt32(DataHelper.ExecuteScalar(sqlCount, null)); JsonObj result = new JsonObj() { total = total, rows = rows }; return(result); }
//验证token public static t_user GetToken(string token) { string strSql = @"select * from t_user where cdefine2 = '" + token + "'"; DataTable dt = DataHelper.GetDataTable(strSql); t_user model = new t_user(); //返回 t_user 对象 if (dt.Rows.Count == 1) { model.code = dt.Rows[0]["code"].ToString(); model.name = dt.Rows[0]["name"].ToString(); } else { model.code = "0"; } return(model); }
/// <summary> /// 根据配置项名称设置value值 /// </summary> /// <param name="strKey"></param> /// <param name="strVal"></param> /// <returns></returns> public int SetValueByKey(string strKey, string strVal) { string strexitsql = "select count(*) from t_Config where aKey=@key"; SqlParameter[] arr = { new SqlParameter("@key", strKey) }; int icount = DataHelper.GetDataTable(strexitsql, arr, false).Rows.Count; if (icount > 0) { string strUpSql = "update t_Config set avalue=@value where aKey=@key"; SqlParameter[] arrSp = { new SqlParameter("@value", strVal), new SqlParameter("@key", strKey) }; return(DataHelper.ExcuteNonQuery(strUpSql, arrSp, false)); } else { string strAddSql = "insert into t_Config(akey,meaning,avalue,classify) values (@key,@meaning,@avalue,@classify)"; SqlParameter[] arrSp = { new SqlParameter("@key", strKey), new SqlParameter("@meaning", ""), new SqlParameter("@avalue", strVal), new SqlParameter("@classify", "0") }; return(DataHelper.ExcuteNonQuery(strAddSql, arrSp, false)); } }
/// <summary> /// 查询结果集转化为对象 /// </summary> /// <param name="tempsql"></param> /// <param name="sps"></param> /// <returns></returns> public IList <Sys_Notes> ItemsListMaker(string tempsql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(tempsql, sps, false); IList <Sys_Notes> list = new List <Sys_Notes>(); foreach (DataRow dr in dt.Rows) { Sys_Notes model = new Sys_Notes(); model.sysCode = dr["sysCode"].ToString(); model.note6 = dr["note6"].ToString(); model.note7 = dr["note7"].ToString(); model.note8 = dr["note8"].ToString(); model.note9 = dr["note9"].ToString(); model.note10 = dr["note10"].ToString(); model.note11 = dr["note11"].ToString(); model.note12 = dr["note12"].ToString(); model.note13 = dr["note13"].ToString(); model.note14 = dr["note14"].ToString(); model.note15 = dr["note15"].ToString(); model.beforestr = dr["beforestr"].ToString(); model.note16 = dr["note16"].ToString(); model.note17 = dr["note17"].ToString(); model.note18 = dr["note18"].ToString(); model.note19 = dr["note19"].ToString(); model.note20 = dr["note20"].ToString(); model.afterstr = dr["afterstr"].ToString(); model.edittype = dr["edittype"].ToString(); model.note1 = dr["note1"].ToString(); model.note2 = dr["note2"].ToString(); model.note3 = dr["note3"].ToString(); model.note4 = dr["note4"].ToString(); model.note5 = dr["note5"].ToString(); list.Add(model); } return(list); }