public List <YHFramework.SysModel.CodeDataModel> GetModelListByCodelist(List <string> codelist) { List <YHFramework.SysModel.CodeDataModel> result = new List <YHFramework.SysModel.CodeDataModel>(); string sql = "select * from CodeData where CodeData in ({0})"; StringBuilder codebuilder = new StringBuilder(); foreach (var item in codelist) { codebuilder.Append("'" + item.FixSql() + "',"); } sql = string.Format(sql, codebuilder.ToString().TrimEnd(',')); YHFramework.SysModel.CodeDataModel model = new YHFramework.SysModel.CodeDataModel(); SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString()); //var fields = DbTool.GetReaderFieldNames(dr); while (dr.Read()) { //model = AutoBindDataReader(dr, fields); model = new YHFramework.SysModel.CodeDataModel(); BindDataReader(model, dr); result.Add(model); } dr.Close(); return(result); }
public int Update(YHFramework.SysModel.CodeDataModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CodeData set "); strSql.Append("CodeData=@CodeData,ShortCodeData=@ShortCodeData,CodeIndex=@CodeIndex,BatchNumber=@BatchNumber,BoxNumberId=@BoxNumberId,ContentStatusId=@ContentStatusId,UpdateOn=@UpdateOn,Createon=@Createon,ApployInfoId=@ApployInfoId "); strSql.Append(" where CodeDataId=@CodeDataId "); SqlParameter[] parameters = { new SqlParameter("@CodeData", DbTool.FixSqlParameter(model.CodeData)) , new SqlParameter("@ShortCodeData", DbTool.FixSqlParameter(model.ShortCodeData)) , new SqlParameter("@CodeIndex", DbTool.FixSqlParameter(model.CodeIndex)) , new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber)) , new SqlParameter("@BoxNumberId", DbTool.FixSqlParameter(model.BoxNumberId)) , new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId)) , new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn)) , new SqlParameter("@Createon", DbTool.FixSqlParameter(model.Createon)) , new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId)) , new SqlParameter("@CodeDataId", model.CodeDataId) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters)); }
protected void BindDataReader(YHFramework.SysModel.CodeDataModel model, SqlDataReader dr) { model.CodeDataId = DbTool.ConvertObject <System.Int32>(dr["CodeDataId"]); model.CodeData = DbTool.ConvertObject <System.String>(dr["CodeData"]); model.ShortCodeData = DbTool.ConvertObject <System.String>(dr["ShortCodeData"]); model.CodeIndex = DbTool.ConvertObject <System.String>(dr["CodeIndex"]); model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]); model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]); model.ContentStatusId = DbTool.ConvertObject <System.Int32>(dr["ContentStatusId"]); model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]); model.Createon = DbTool.ConvertObject <System.DateTime>(dr["Createon"]); model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]); }
public YHFramework.SysModel.CodeDataModel GetModel(int Id) { string sql = "select top 1 * from CodeData where CodeDataId =" + Id; YHFramework.SysModel.CodeDataModel model = new YHFramework.SysModel.CodeDataModel(); SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString()); if (dr.Read()) { //var fields = DbTool.GetReaderFieldNames(dr); //model = AutoBindDataReader(dr, fields); BindDataReader(model, dr); } dr.Close(); return(model); }
protected YHFramework.SysModel.CodeDataModel AutoBindDataReader(SqlDataReader dr, params string[] fields) { var model = new YHFramework.SysModel.CodeDataModel(); if (DbTool.HasFields("CodeDataId", fields)) { model.CodeDataId = DbTool.ConvertObject <System.Int32>(dr["CodeDataId"]); } if (DbTool.HasFields("CodeData", fields)) { model.CodeData = DbTool.ConvertObject <System.String>(dr["CodeData"]); } if (DbTool.HasFields("ShortCodeData", fields)) { model.ShortCodeData = DbTool.ConvertObject <System.String>(dr["ShortCodeData"]); } if (DbTool.HasFields("CodeIndex", fields)) { model.CodeIndex = DbTool.ConvertObject <System.String>(dr["CodeIndex"]); } if (DbTool.HasFields("BatchNumber", fields)) { model.BatchNumber = DbTool.ConvertObject <System.String>(dr["BatchNumber"]); } if (DbTool.HasFields("BoxNumberId", fields)) { model.BoxNumberId = DbTool.ConvertObject <System.Int32>(dr["BoxNumberId"]); } if (DbTool.HasFields("ContentStatusId", fields)) { model.ContentStatusId = DbTool.ConvertObject <System.Int32>(dr["ContentStatusId"]); } if (DbTool.HasFields("UpdateOn", fields)) { model.UpdateOn = DbTool.ConvertObject <System.DateTime>(dr["UpdateOn"]); } if (DbTool.HasFields("Createon", fields)) { model.Createon = DbTool.ConvertObject <System.DateTime>(dr["Createon"]); } if (DbTool.HasFields("ApployInfoId", fields)) { model.ApployInfoId = DbTool.ConvertObject <System.Int32>(dr["ApployInfoId"]); } return(model); }
public List <YHFramework.SysModel.CodeDataModel> GetModelList() { List <YHFramework.SysModel.CodeDataModel> result = new List <YHFramework.SysModel.CodeDataModel>(); string sql = "select * from CodeData where 1=1"; YHFramework.SysModel.CodeDataModel model = new YHFramework.SysModel.CodeDataModel(); SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString()); //var fields = DbTool.GetReaderFieldNames(dr); while (dr.Read()) { //model = AutoBindDataReader(dr, fields); model = new YHFramework.SysModel.CodeDataModel(); BindDataReader(model, dr); result.Add(model); } dr.Close(); return(result); }
public int Add(YHFramework.SysModel.CodeDataModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [CodeData]"); strSql.Append("(CodeData,ShortCodeData,CodeIndex,BatchNumber,BoxNumberId,ContentStatusId,UpdateOn,Createon,ApployInfoId)"); strSql.Append(" values (@CodeData,@ShortCodeData,@CodeIndex,@BatchNumber,@BoxNumberId,@ContentStatusId,@UpdateOn,@Createon,@ApployInfoId)"); strSql.Append(";select SCOPE_IDENTITY()"); SqlParameter[] parameters = { new SqlParameter("@CodeData", DbTool.FixSqlParameter(model.CodeData)) , new SqlParameter("@ShortCodeData", DbTool.FixSqlParameter(model.ShortCodeData)) , new SqlParameter("@CodeIndex", DbTool.FixSqlParameter(model.CodeIndex)) , new SqlParameter("@BatchNumber", DbTool.FixSqlParameter(model.BatchNumber)) , new SqlParameter("@BoxNumberId", DbTool.FixSqlParameter(model.BoxNumberId)) , new SqlParameter("@ContentStatusId", DbTool.FixSqlParameter(model.ContentStatusId)) , new SqlParameter("@UpdateOn", DbTool.FixSqlParameter(model.UpdateOn)) , new SqlParameter("@Createon", DbTool.FixSqlParameter(model.Createon)) , new SqlParameter("@ApployInfoId", DbTool.FixSqlParameter(model.ApployInfoId)) }; return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0)); }