/// <summary>对象实体绑定数据 /// /// </summary> public Nikita.Platform.BugClose.Model.BseProjectVersion ReaderBind(IDataReader dataReader) { Nikita.Platform.BugClose.Model.BseProjectVersion model = new Nikita.Platform.BugClose.Model.BseProjectVersion(); object ojb; ojb = dataReader["VersionID"]; if (ojb != null && ojb != DBNull.Value) { model.VersionID = int.Parse(ojb.ToString()); } ojb = dataReader["ProjectID"]; if (ojb != null && ojb != DBNull.Value) { model.ProjectID = int.Parse(ojb.ToString()); } model.Name = dataReader["Name"].ToString(); ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = int.Parse(ojb.ToString()); } model.Remark = dataReader["Remark"].ToString(); ojb = dataReader["Sort"]; if (ojb != null && ojb != DBNull.Value) { model.Sort = int.Parse(ojb.ToString()); } ojb = dataReader["DeptId"]; if (ojb != null && ojb != DBNull.Value) { model.DeptId = int.Parse(ojb.ToString()); } ojb = dataReader["CompanyID"]; if (ojb != null && ojb != DBNull.Value) { model.CompanyID = int.Parse(ojb.ToString()); } ojb = dataReader["CreateDate"]; if (ojb != null && ojb != DBNull.Value) { model.CreateDate = DateTime.Parse(ojb.ToString()); } model.CreateUser = dataReader["CreateUser"].ToString(); ojb = dataReader["EditDate"]; if (ojb != null && ojb != DBNull.Value) { model.EditDate = DateTime.Parse(ojb.ToString()); } model.EditUser = dataReader["EditUser"].ToString(); return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Platform.BugClose.Model.BseProjectVersion GetModel(int VersionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from BseProjectVersion "); strSql.Append(" where VersionID=@VersionID "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@VersionID", VersionID); Nikita.Platform.BugClose.Model.BseProjectVersion model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Platform.BugClose.Model.BseProjectVersion GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from BseProjectVersion "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); Nikita.Platform.BugClose.Model.BseProjectVersion model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Platform.BugClose.Model.BseProjectVersion model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BseProjectVersion("); strSql.Append("ProjectID, Name, Status, Remark, Sort, DeptId, CompanyID, CreateDate, CreateUser, EditDate, EditUser )"); strSql.Append(" values ("); strSql.Append("@ProjectID, @Name, @Status, @Remark, @Sort, @DeptId, @CompanyID, @CreateDate, @CreateUser, @EditDate, @EditUser )"); strSql.Append(";select @@IDENTITY"); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.ProjectID == null) { h.AddParameter("@ProjectID", DBNull.Value); } else { h.AddParameter("@ProjectID", model.ProjectID); } if (model.Name == null) { h.AddParameter("@Name", DBNull.Value); } else { h.AddParameter("@Name", model.Name); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.DeptId == null) { h.AddParameter("@DeptId", DBNull.Value); } else { h.AddParameter("@DeptId", model.DeptId); } if (model.CompanyID == null) { h.AddParameter("@CompanyID", DBNull.Value); } else { h.AddParameter("@CompanyID", model.CompanyID); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.CreateUser == null) { h.AddParameter("@CreateUser", DBNull.Value); } else { h.AddParameter("@CreateUser", model.CreateUser); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.EditUser == null) { h.AddParameter("@EditUser", DBNull.Value); } else { h.AddParameter("@EditUser", model.EditUser); } int intResult; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out intResult)) { return(0); } return(intResult); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Nikita.Platform.BugClose.Model.BseProjectVersion model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BseProjectVersion set "); strSql.Append("ProjectID=@ProjectID, Name=@Name, Status=@Status, Remark=@Remark, Sort=@Sort, DeptId=@DeptId, CompanyID=@CompanyID, CreateDate=@CreateDate, CreateUser=@CreateUser, EditDate=@EditDate, EditUser=@EditUser "); strSql.Append(" where VersionID=@VersionID "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.VersionID == null) { h.AddParameter("@VersionID", DBNull.Value); } else { h.AddParameter("@VersionID", model.VersionID); } if (model.ProjectID == null) { h.AddParameter("@ProjectID", DBNull.Value); } else { h.AddParameter("@ProjectID", model.ProjectID); } if (model.Name == null) { h.AddParameter("@Name", DBNull.Value); } else { h.AddParameter("@Name", model.Name); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.Sort == null) { h.AddParameter("@Sort", DBNull.Value); } else { h.AddParameter("@Sort", model.Sort); } if (model.DeptId == null) { h.AddParameter("@DeptId", DBNull.Value); } else { h.AddParameter("@DeptId", model.DeptId); } if (model.CompanyID == null) { h.AddParameter("@CompanyID", DBNull.Value); } else { h.AddParameter("@CompanyID", model.CompanyID); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.CreateUser == null) { h.AddParameter("@CreateUser", DBNull.Value); } else { h.AddParameter("@CreateUser", model.CreateUser); } if (model.EditDate == null) { h.AddParameter("@EditDate", DBNull.Value); } else { h.AddParameter("@EditDate", model.EditDate); } if (model.EditUser == null) { h.AddParameter("@EditUser", DBNull.Value); } else { h.AddParameter("@EditUser", model.EditUser); } return(h.ExecuteNonQuery()); }