/// <summary> /// 获取列表 /// </summary> /// <param name="CompanyId">公司编号</param> /// <returns></returns> public IList <EyouSoft.Model.CompanyStructure.CustomerCareforInfo> GetList(string CompanyId, int PageSize, int PageIndex, ref int RecordCount) { string cmdQuery = string.Format(" Companyid={0}", CompanyId); string tableName = "tbl_CustomerCarefor"; string primaryKey = "Id"; string field = "*"; IList <EyouSoft.Model.CompanyStructure.CustomerCareforInfo> careForList = new List <EyouSoft.Model.CompanyStructure.CustomerCareforInfo>(); EyouSoft.Model.CompanyStructure.CustomerCareforInfo model = null; using (IDataReader rd = DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tableName, primaryKey, field, cmdQuery, "IssueTime desc")) { while (rd.Read()) { model = new CustomerCareforInfo(); model.Id = rd.GetInt32(rd.GetOrdinal("id")); model.Content = rd.IsDBNull(rd.GetOrdinal("Content")) ? "" : rd.GetString(rd.GetOrdinal("Content")); model.IsEnabled = rd.GetString(rd.GetOrdinal("IsEnabled")) == "1" ? true : false; model.IsMatchCustomerInfo = rd.GetString(rd.GetOrdinal("IsMatchCustomerInfo")) == "1" ? true : false; model.IsMatchDepartmentInfo = rd.GetString(rd.GetOrdinal("IsMatchDepartmentInfo")) == "1" ? true : false; model.IsMatchSupplierInfo = rd.GetString(rd.GetOrdinal("IsMatchSupplierInfo")) == "1" ? true : false; model.IsSeded = rd.GetString(rd.GetOrdinal("IsSeded")) == "1" ? true : false; model.IssueTime = rd.IsDBNull(rd.GetOrdinal("IssueTime")) ? DateTime.Parse("2000-01-01") : rd.GetDateTime(rd.GetOrdinal("IssueTime")); model.MobileCode = rd.IsDBNull(rd.GetOrdinal("MobileCode")) ?"": rd.GetString(rd.GetOrdinal("MobileCode")); model.OperatorId = rd.GetInt32(rd.GetOrdinal("OperatorId")); model.FixType = rd.IsDBNull(rd.GetOrdinal("FixType")) ? EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime.无: (EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime)Enum.Parse(typeof(EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime), rd.GetInt32(rd.GetOrdinal("FixType")).ToString()); model.Time = rd.IsDBNull(rd.GetOrdinal("Time")) ? DateTime.Parse("2000-01-01") : rd.GetDateTime(rd.GetOrdinal("Time")); careForList.Add(model); } } return(careForList); }
/// <summary> /// 修改 /// </summary> /// <param name="Model"></param> /// <returns></returns> public bool Update(EyouSoft.Model.CompanyStructure.CustomerCareforInfo Model) { if (Model == null || Model.Id <= 0) { return(false); } StringBuilder sql = new StringBuilder("update [tbl_CustomerCarefor] set [CompanyId]=@CompanyId,[MobileCode]=@MobileCode,[IsMatchCustomerInfo]=@IsMatchCustomerInfo,"); sql.Append(" [IsMatchSupplierInfo]=@IsMatchSupplierInfo,[IsMatchDepartmentInfo]=@IsMatchDepartmentInfo,[Content]=@Content,[Time]=@Time,[FixType]=@FixType,[ChannelId]=@ChannelId,"); sql.Append(" [IsEnabled]=@IsEnabled,[OperatorId]=@OperatorId,[IssueTime]=@IssueTime "); sql.AppendFormat(" where id={0}", Model.Id); DbCommand cmd = this._db.GetSqlStringCommand(sql.ToString()); this._db.AddInParameter(cmd, "ChannelId", DbType.Int32, Model.ChannelId); this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, Model.CompanyId); this._db.AddInParameter(cmd, "Content", DbType.String, Model.Content); this._db.AddInParameter(cmd, "FixType", DbType.Int32, (int)Model.FixType); this._db.AddInParameter(cmd, "IsEnabled", DbType.StringFixedLength, Model.IsEnabled ? '1' : '0'); this._db.AddInParameter(cmd, "IsMatchCustomerInfo", DbType.StringFixedLength, Model.IsMatchCustomerInfo ? '1' : '0'); this._db.AddInParameter(cmd, "IsMatchDepartmentInfo", DbType.StringFixedLength, Model.IsMatchDepartmentInfo ? '1' : '0'); this._db.AddInParameter(cmd, "IsMatchSupplierInfo", DbType.StringFixedLength, Model.IsMatchSupplierInfo ? '1' : '0'); this._db.AddInParameter(cmd, "IsSeded", DbType.StringFixedLength, Model.IsSeded ? '1' : '0'); this._db.AddInParameter(cmd, "IssueTime", DbType.DateTime, Model.IssueTime); this._db.AddInParameter(cmd, "MobileCode", DbType.String, Model.MobileCode); this._db.AddInParameter(cmd, "OperatorId", DbType.Int32, Model.OperatorId); this._db.AddInParameter(cmd, "Time", DbType.DateTime, Model.Time); return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false); }
/// <summary> /// 返回实体 /// </summary> /// <param name="Id"></param> /// <returns></returns> public EyouSoft.Model.CompanyStructure.CustomerCareforInfo GetModel(int Id) { string sql = "select * from tbl_CustomerCarefor where id=@CareForId "; DbCommand cmd = this._db.GetSqlStringCommand(sql); this._db.AddInParameter(cmd, "CareForId", DbType.Int32, Id); EyouSoft.Model.CompanyStructure.CustomerCareforInfo model = null; using (IDataReader rd = DbHelper.ExecuteReader(cmd, this._db)) { if (rd.Read()) { model = new CustomerCareforInfo(); model.ChannelId = rd.IsDBNull(rd.GetOrdinal("ChannelId")) ? 0 : rd.GetInt32(rd.GetOrdinal("ChannelId")); model.CompanyId = rd.IsDBNull(rd.GetOrdinal("CompanyId")) ? 0 : rd.GetInt32(rd.GetOrdinal("CompanyId")); model.Content = rd.IsDBNull(rd.GetOrdinal("Content")) ? "" : rd.GetString(rd.GetOrdinal("Content")); model.FixType = rd.IsDBNull(rd.GetOrdinal("FixType")) ? EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime.无 : (EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime)Enum.Parse(typeof(EyouSoft.Model.EnumType.CompanyStructure.CustomerCareForSendSpecialTime), rd.GetInt32(rd.GetOrdinal("FixType")).ToString()); model.Id = rd.IsDBNull(rd.GetOrdinal("Id")) ? 0 : rd.GetInt32(rd.GetOrdinal("Id")); model.IsEnabled = rd.IsDBNull(rd.GetOrdinal("IsEnabled")) ? false : rd.GetString(rd.GetOrdinal("IsEnabled")) == "1" ? true : false; model.IsMatchCustomerInfo = rd.IsDBNull(rd.GetOrdinal("IsMatchCustomerInfo")) ? false : rd.GetString(rd.GetOrdinal("IsMatchCustomerInfo")) == "1" ? true : false; model.IsMatchDepartmentInfo = rd.IsDBNull(rd.GetOrdinal("IsMatchDepartmentInfo")) ? false : rd.GetString(rd.GetOrdinal("IsMatchDepartmentInfo")) == "1" ? true : false; model.IsMatchSupplierInfo = rd.IsDBNull(rd.GetOrdinal("IsMatchSupplierInfo")) ? false : rd.GetString(rd.GetOrdinal("IsMatchSupplierInfo")) == "1" ? true : false; model.IsSeded = rd.IsDBNull(rd.GetOrdinal("IsSeded")) ? false : rd.GetString(rd.GetOrdinal("IsSeded")) == "1" ? true : false; model.IssueTime = rd.IsDBNull(rd.GetOrdinal("IssueTime")) ? DateTime.Parse("2011-01-28") : rd.GetDateTime(rd.GetOrdinal("IssueTime")); model.MobileCode = rd.IsDBNull(rd.GetOrdinal("MobileCode")) ? "" : rd.GetString(rd.GetOrdinal("MobileCode")); model.OperatorId = rd.IsDBNull(rd.GetOrdinal("OperatorId")) ? 0 : rd.GetInt32(rd.GetOrdinal("OperatorId")); model.Time = rd.IsDBNull(rd.GetOrdinal("Time")) ? DateTime.Parse("2011-01-28") : rd.GetDateTime(rd.GetOrdinal("Time")); } } return(model); }
/// <summary> /// 添加 /// </summary> /// <param name="Model"></param> /// <returns></returns> public bool Add(EyouSoft.Model.CompanyStructure.CustomerCareforInfo Model) { StringBuilder sql = new StringBuilder("INSERT INTO [tbl_CustomerCarefor]([CompanyId],[MobileCode],[IsMatchCustomerInfo],[IsMatchSupplierInfo],[IsMatchDepartmentInfo],[Content],[Time],[FixType],[ChannelId],[IsEnabled],[OperatorId],[IssueTime])"); sql.Append("values(@CompanyId,@MobileCode,@IsMatchCustomerInfo,@IsMatchSupplierInfo,@IsMatchDepartmentInfo,@Content,@Time,@FixType,@ChannelId,@IsEnabled,@OperatorId,@IssueTime)"); DbCommand cmd = this._db.GetSqlStringCommand(sql.ToString()); this._db.AddInParameter(cmd, "ChannelId", DbType.Int32, Model.ChannelId); this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, Model.CompanyId); this._db.AddInParameter(cmd, "Content", DbType.String, Model.Content); this._db.AddInParameter(cmd, "FixType", DbType.Int32, (int)Model.FixType); this._db.AddInParameter(cmd, "IsEnabled", DbType.StringFixedLength, Model.IsEnabled ?'1':'0'); this._db.AddInParameter(cmd, "IsMatchCustomerInfo", DbType.StringFixedLength, Model.IsMatchCustomerInfo ? '1' : '0'); this._db.AddInParameter(cmd, "IsMatchDepartmentInfo", DbType.StringFixedLength, Model.IsMatchDepartmentInfo ? '1' : '0'); this._db.AddInParameter(cmd, "IsMatchSupplierInfo", DbType.StringFixedLength, Model.IsMatchSupplierInfo ? '1' : '0'); this._db.AddInParameter(cmd, "IsSeded", DbType.StringFixedLength, Model.IsSeded ? '1' : '0'); this._db.AddInParameter(cmd, "IssueTime", DbType.DateTime, Model.IssueTime); this._db.AddInParameter(cmd, "MobileCode", DbType.String, Model.MobileCode); this._db.AddInParameter(cmd, "OperatorId", DbType.Int32, Model.OperatorId); this._db.AddInParameter(cmd, "Time", DbType.DateTime, Model.Time); return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false); }