public IList <T_ReportApplication> ListMaker(string tempsql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(tempsql, sps, false); IList <T_ReportApplication> list = new List <T_ReportApplication>(); foreach (DataRow dr in dt.Rows) { T_ReportApplication model = new T_ReportApplication(); model.ReportAppCode = dr["ReportAppCode"].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.NOTE9 = dr["NOTE9"].ToString(); model.NOTE0 = dr["NOTE0"].ToString(); model.ReportName = dr["ReportName"].ToString(); model.ReportNameCode = dr["ReportNameCode"].ToString(); model.ReportDeptCode = dr["ReportDeptCode"].ToString(); model.ReportDeptName = dr["ReportDeptName"].ToString(); model.ReportDate = dr["ReportDate"].ToString(); model.ReportExplain = dr["ReportExplain"].ToString(); model.ReportRemark = dr["ReportRemark"].ToString(); model.NOTE1 = dr["NOTE1"].ToString(); list.Add(model); } return(list); }
public DataTable getallmode(T_ReportApplication model) { StringBuilder strSql = new StringBuilder(); List <object> objParams = new List <object>(); strSql.Append(@"select a.* ,('['+ReportNameCode+']'+ReportName)as username,('['+ReportDeptCode+']'+ReportDeptName)as deptnames from dbo.T_ReportApplication a where 1=1"); //////申请单号 //if (model.Billcode != null && model.Billcode != "") //{ // strSql.Append(" and a.Billcode like '%" + model.Billcode + "%' "); //} strSql.Append(" order by ReportDate desc"); return(DataHelper.GetDataTable(strSql.ToString(), null, false)); }
/// <summary> /// 得到一个对象实体 /// </summary> public T_ReportApplication GetModel(string ReportAppCode) { StringBuilder strSql = new StringBuilder(); strSql.Append(sql); strSql.Append(" where ReportAppCode=@ReportAppCode "); SqlParameter[] parameters = { new SqlParameter("@ReportAppCode", SqlDbType.NVarChar, 50) }; parameters[0].Value = ReportAppCode; T_ReportApplication model = new T_ReportApplication(); using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters)) { if (dr.Read()) { model.ReportAppCode = dr["ReportAppCode"].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.NOTE9 = dr["NOTE9"].ToString(); model.NOTE0 = dr["NOTE0"].ToString(); model.ReportName = dr["ReportName"].ToString(); model.ReportNameCode = dr["ReportNameCode"].ToString(); model.ReportDeptCode = dr["ReportDeptCode"].ToString(); model.ReportDeptName = dr["ReportDeptName"].ToString(); model.ReportDate = dr["ReportDate"].ToString(); model.ReportExplain = dr["ReportExplain"].ToString(); model.ReportRemark = dr["ReportRemark"].ToString(); model.NOTE1 = dr["NOTE1"].ToString(); return(model); } else { return(null); } } }
public int Add(T_ReportApplication model) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { int row = Add(model, tran); tran.Commit(); return(row); } catch { tran.Rollback(); throw; } } }
/// <summary> /// 添加 /// </summary> /// <returns></returns> public int Addmodel(T_ReportApplication model) { return(dal.Add(model)); }
public DataTable getalltable(T_ReportApplication model) { return(dal.getallmode(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(T_ReportApplication model, SqlTransaction tran) { Delete(model.ReportAppCode, tran); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_ReportApplication("); strSql.Append("ReportAppCode,NOTE2,NOTE3,NOTE4,NOTE5,NOTE6,NOTE7,NOTE8,NOTE9,NOTE0,ReportName,ReportNameCode,ReportDeptCode,ReportDeptName,ReportDate,ReportExplain,ReportRemark,NOTE1"); strSql.Append(") values ("); strSql.Append("@ReportAppCode,@NOTE2,@NOTE3,@NOTE4,@NOTE5,@NOTE6,@NOTE7,@NOTE8,@NOTE9,@NOTE0,@ReportName,@ReportNameCode,@ReportDeptCode,@ReportDeptName,@ReportDate,@ReportExplain,@ReportRemark,@NOTE1"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@ReportAppCode", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE2", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE3", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE4", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE5", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE6", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE7", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE8", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE9", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE0", SqlDbType.NVarChar, 50), new SqlParameter("@ReportName", SqlDbType.NVarChar, 50), new SqlParameter("@ReportNameCode", SqlDbType.NVarChar, 50), new SqlParameter("@ReportDeptCode", SqlDbType.NVarChar, 50), new SqlParameter("@ReportDeptName", SqlDbType.NVarChar, 50), new SqlParameter("@ReportDate", SqlDbType.NVarChar, 50), new SqlParameter("@ReportExplain", SqlDbType.NVarChar, 50), new SqlParameter("@ReportRemark", SqlDbType.NVarChar, 50), new SqlParameter("@NOTE1", SqlDbType.NVarChar, 50) }; parameters[0].Value = SqlNull(model.ReportAppCode); parameters[1].Value = SqlNull(model.NOTE2); parameters[2].Value = SqlNull(model.NOTE3); parameters[3].Value = SqlNull(model.NOTE4); parameters[4].Value = SqlNull(model.NOTE5); parameters[5].Value = SqlNull(model.NOTE6); parameters[6].Value = SqlNull(model.NOTE7); parameters[7].Value = SqlNull(model.NOTE8); parameters[8].Value = SqlNull(model.NOTE9); parameters[9].Value = SqlNull(model.NOTE0); parameters[10].Value = SqlNull(model.ReportName); parameters[11].Value = SqlNull(model.ReportNameCode); parameters[12].Value = SqlNull(model.ReportDeptCode); parameters[13].Value = SqlNull(model.ReportDeptName); parameters[14].Value = SqlNull(model.ReportDate); parameters[15].Value = SqlNull(model.ReportExplain); parameters[16].Value = SqlNull(model.ReportRemark); parameters[17].Value = SqlNull(model.NOTE1); return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false)); }