/// <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);
}
