/// <summary> /// 获得数据列表 /// </summary> public List <JMP.MDL.jmp_notificaiton_group> DataTableToList(DataTable dt) { List <JMP.MDL.jmp_notificaiton_group> modelList = new List <JMP.MDL.jmp_notificaiton_group>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { JMP.MDL.jmp_notificaiton_group model; for (int n = 0; n < rowsCount; n++) { model = new JMP.MDL.jmp_notificaiton_group(); if (dt.Rows[n]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[n]["Id"].ToString()); } if (dt.Rows[n]["IntervalValue"].ToString() != "") { model.IntervalValue = int.Parse(dt.Rows[n]["IntervalValue"].ToString()); } model.IntervalUnit = dt.Rows[n]["IntervalUnit"].ToString(); if (dt.Rows[n]["CreatedOn"].ToString() != "") { model.CreatedOn = DateTime.Parse(dt.Rows[n]["CreatedOn"].ToString()); } if (dt.Rows[n]["CreatedBy"].ToString() != "") { model.CreatedBy = int.Parse(dt.Rows[n]["CreatedBy"].ToString()); } model.CreatedByUser = dt.Rows[n]["CreatedByUser"].ToString(); if (dt.Rows[n]["ModifiedOn"].ToString() != "") { model.ModifiedOn = DateTime.Parse(dt.Rows[n]["ModifiedOn"].ToString()); } if (dt.Rows[n]["ModifiedBy"].ToString() != "") { model.ModifiedBy = int.Parse(dt.Rows[n]["ModifiedBy"].ToString()); } model.ModifiedByUser = dt.Rows[n]["ModifiedByUser"].ToString(); model.Name = dt.Rows[n]["Name"].ToString(); model.Code = dt.Rows[n]["Code"].ToString(); model.SendMode = dt.Rows[n]["SendMode"].ToString(); model.Description = dt.Rows[n]["Description"].ToString(); model.NotifyMobileList = dt.Rows[n]["NotifyMobileList"].ToString(); model.MessageTemplate = dt.Rows[n]["MessageTemplate"].ToString(); model.AudioTelTempContent = dt.Rows[n]["AudioTelTempContent"].ToString(); if (dt.Rows[n]["AudioTelTempId"].ToString() != "") { model.AudioTelTempId = int.Parse(dt.Rows[n]["AudioTelTempId"].ToString()); } if (dt.Rows[n]["IsDeleted"].ToString() != "") { if ((dt.Rows[n]["IsDeleted"].ToString() == "1") || (dt.Rows[n]["IsDeleted"].ToString().ToLower() == "true")) { model.IsDeleted = true; } else { model.IsDeleted = false; } } if (dt.Rows[n]["IsEnabled"].ToString() != "") { if ((dt.Rows[n]["IsEnabled"].ToString() == "1") || (dt.Rows[n]["IsEnabled"].ToString().ToLower() == "true")) { model.IsEnabled = true; } else { model.IsEnabled = false; } } if (dt.Rows[n]["IsAllowSendMessage"].ToString() != "") { if ((dt.Rows[n]["IsAllowSendMessage"].ToString() == "1") || (dt.Rows[n]["IsAllowSendMessage"].ToString().ToLower() == "true")) { model.IsAllowSendMessage = true; } else { model.IsAllowSendMessage = false; } } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_notificaiton_group model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_notificaiton_group model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_notificaiton_group model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_notificaiton_group set "); strSql.Append(" IntervalValue = @IntervalValue , "); strSql.Append(" IntervalUnit = @IntervalUnit , "); strSql.Append(" CreatedOn = @CreatedOn , "); strSql.Append(" CreatedBy = @CreatedBy , "); strSql.Append(" CreatedByUser = @CreatedByUser , "); strSql.Append(" ModifiedOn = @ModifiedOn , "); strSql.Append(" ModifiedBy = @ModifiedBy , "); strSql.Append(" ModifiedByUser = @ModifiedByUser , "); strSql.Append(" Name = @Name , "); strSql.Append(" Code = @Code , "); strSql.Append(" Description = @Description , "); strSql.Append(" NotifyMobileList = @NotifyMobileList , "); strSql.Append(" MessageTemplate = @MessageTemplate , "); strSql.Append(" IsDeleted = @IsDeleted , "); strSql.Append(" IsEnabled = @IsEnabled , "); strSql.Append(" IsAllowSendMessage = @IsAllowSendMessage,"); strSql.Append(" SendMode = @SendMode,"); strSql.Append(" AudioTelTempId=@AudioTelTempId,"); strSql.Append(" AudioTelTempContent=@AudioTelTempContent"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@IntervalValue", SqlDbType.Int, 4), new SqlParameter("@IntervalUnit", SqlDbType.NVarChar, 10), new SqlParameter("@CreatedOn", SqlDbType.DateTime), new SqlParameter("@CreatedBy", SqlDbType.Int, 4), new SqlParameter("@CreatedByUser", SqlDbType.NVarChar, 30), new SqlParameter("@ModifiedOn", SqlDbType.DateTime), new SqlParameter("@ModifiedBy", SqlDbType.Int, 4), new SqlParameter("@ModifiedByUser", SqlDbType.NVarChar, 30), new SqlParameter("@Name", SqlDbType.NVarChar, 100), new SqlParameter("@Code", SqlDbType.NVarChar, 255), new SqlParameter("@Description", SqlDbType.NVarChar, 255), new SqlParameter("@NotifyMobileList", SqlDbType.NVarChar, 500), new SqlParameter("@MessageTemplate", SqlDbType.NVarChar, 255), new SqlParameter("@IsDeleted", SqlDbType.Bit, 1), new SqlParameter("@IsEnabled", SqlDbType.Bit, 1), new SqlParameter("@IsAllowSendMessage", SqlDbType.Bit, 1), new SqlParameter("@SendMode", SqlDbType.NVarChar, 10), new SqlParameter("@AudioTelTempId", SqlDbType.BigInt, 12), new SqlParameter("@AudioTelTempContent", SqlDbType.NVarChar, 255) }; parameters[0].Value = model.Id; parameters[1].Value = model.IntervalValue; parameters[2].Value = model.IntervalUnit; parameters[3].Value = model.CreatedOn; parameters[4].Value = model.CreatedBy; parameters[5].Value = model.CreatedByUser; parameters[6].Value = model.ModifiedOn; parameters[7].Value = model.ModifiedBy; parameters[8].Value = model.ModifiedByUser; parameters[9].Value = model.Name; parameters[10].Value = model.Code; parameters[11].Value = model.Description; parameters[12].Value = model.NotifyMobileList; parameters[13].Value = model.MessageTemplate; parameters[14].Value = model.IsDeleted; parameters[15].Value = model.IsEnabled; parameters[16].Value = model.IsAllowSendMessage; parameters[17].Value = model.SendMode; parameters[18].Value = model.AudioTelTempId; parameters[19].Value = model.AudioTelTempContent; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_notificaiton_group model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_notificaiton_group("); strSql.Append("IntervalValue,IntervalUnit,CreatedOn,CreatedBy,CreatedByUser,ModifiedOn,ModifiedBy,ModifiedByUser,Name,Code,Description,NotifyMobileList,MessageTemplate,IsDeleted,IsEnabled,IsAllowSendMessage,SendMode,AudioTelTempId,AudioTelTempContent"); strSql.Append(") values ("); strSql.Append("@IntervalValue,@IntervalUnit,@CreatedOn,@CreatedBy,@CreatedByUser,@ModifiedOn,@ModifiedBy,@ModifiedByUser,@Name,@Code,@Description,@NotifyMobileList,@MessageTemplate,@IsDeleted,@IsEnabled,@IsAllowSendMessage,@SendMode,@AudioTelTempId,@AudioTelTempContent"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@IntervalValue", SqlDbType.Int, 4), new SqlParameter("@IntervalUnit", SqlDbType.NVarChar, 10), new SqlParameter("@CreatedOn", SqlDbType.DateTime), new SqlParameter("@CreatedBy", SqlDbType.Int, 4), new SqlParameter("@CreatedByUser", SqlDbType.NVarChar, 30), new SqlParameter("@ModifiedOn", SqlDbType.DateTime), new SqlParameter("@ModifiedBy", SqlDbType.Int, 4), new SqlParameter("@ModifiedByUser", SqlDbType.NVarChar, 30), new SqlParameter("@Name", SqlDbType.NVarChar, 100), new SqlParameter("@Code", SqlDbType.NVarChar, 255), new SqlParameter("@Description", SqlDbType.NVarChar, 255), new SqlParameter("@NotifyMobileList", SqlDbType.NVarChar, 500), new SqlParameter("@MessageTemplate", SqlDbType.NVarChar, 255), new SqlParameter("@IsDeleted", SqlDbType.Bit, 1), new SqlParameter("@IsEnabled", SqlDbType.Bit, 1), new SqlParameter("@IsAllowSendMessage", SqlDbType.Bit, 1), new SqlParameter("@SendMode", SqlDbType.NVarChar, 10), new SqlParameter("@AudioTelTempId", SqlDbType.BigInt, 12), new SqlParameter("@AudioTelTempContent", SqlDbType.NVarChar, 255) }; parameters[0].Value = model.IntervalValue; parameters[1].Value = model.IntervalUnit; parameters[2].Value = model.CreatedOn; parameters[3].Value = model.CreatedBy; parameters[4].Value = model.CreatedByUser; parameters[5].Value = model.ModifiedOn; parameters[6].Value = model.ModifiedBy; parameters[7].Value = model.ModifiedByUser; parameters[8].Value = model.Name; parameters[9].Value = model.Code; parameters[10].Value = model.Description; parameters[11].Value = model.NotifyMobileList; parameters[12].Value = model.MessageTemplate; parameters[13].Value = model.IsDeleted; parameters[14].Value = model.IsEnabled; parameters[15].Value = model.IsAllowSendMessage; parameters[16].Value = model.SendMode; parameters[17].Value = model.AudioTelTempId; parameters[18].Value = model.AudioTelTempContent; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_notificaiton_group GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id, IntervalValue, IntervalUnit, CreatedOn, CreatedBy, CreatedByUser, ModifiedOn, ModifiedBy, ModifiedByUser, Name, Code, Description, NotifyMobileList, MessageTemplate, IsDeleted, IsEnabled, IsAllowSendMessage,SendMode,AudioTelTempId,AudioTelTempContent"); strSql.Append(" from jmp_notificaiton_group "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; JMP.MDL.jmp_notificaiton_group model = new JMP.MDL.jmp_notificaiton_group(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["IntervalValue"].ToString() != "") { model.IntervalValue = int.Parse(ds.Tables[0].Rows[0]["IntervalValue"].ToString()); } model.IntervalUnit = ds.Tables[0].Rows[0]["IntervalUnit"].ToString(); if (ds.Tables[0].Rows[0]["CreatedOn"].ToString() != "") { model.CreatedOn = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedOn"].ToString()); } if (ds.Tables[0].Rows[0]["CreatedBy"].ToString() != "") { model.CreatedBy = int.Parse(ds.Tables[0].Rows[0]["CreatedBy"].ToString()); } model.CreatedByUser = ds.Tables[0].Rows[0]["CreatedByUser"].ToString(); if (ds.Tables[0].Rows[0]["ModifiedOn"].ToString() != "") { model.ModifiedOn = DateTime.Parse(ds.Tables[0].Rows[0]["ModifiedOn"].ToString()); } if (ds.Tables[0].Rows[0]["ModifiedBy"].ToString() != "") { model.ModifiedBy = int.Parse(ds.Tables[0].Rows[0]["ModifiedBy"].ToString()); } model.ModifiedByUser = ds.Tables[0].Rows[0]["ModifiedByUser"].ToString(); model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); model.Code = ds.Tables[0].Rows[0]["Code"].ToString(); model.Description = ds.Tables[0].Rows[0]["Description"].ToString(); model.NotifyMobileList = ds.Tables[0].Rows[0]["NotifyMobileList"].ToString(); model.MessageTemplate = ds.Tables[0].Rows[0]["MessageTemplate"].ToString(); model.SendMode = ds.Tables[0].Rows[0]["SendMode"].ToString(); model.AudioTelTempContent = ds.Tables[0].Rows[0]["AudioTelTempContent"].ToString(); if (ds.Tables[0].Rows[0]["AudioTelTempId"].ToString() != "") { model.AudioTelTempId = int.Parse(ds.Tables[0].Rows[0]["AudioTelTempId"].ToString()); } if (ds.Tables[0].Rows[0]["IsDeleted"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsDeleted"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsDeleted"].ToString().ToLower() == "true")) { model.IsDeleted = true; } else { model.IsDeleted = false; } } if (ds.Tables[0].Rows[0]["IsEnabled"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsEnabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsEnabled"].ToString().ToLower() == "true")) { model.IsEnabled = true; } else { model.IsEnabled = false; } } if (ds.Tables[0].Rows[0]["IsAllowSendMessage"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsAllowSendMessage"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsAllowSendMessage"].ToString().ToLower() == "true")) { model.IsAllowSendMessage = true; } else { model.IsAllowSendMessage = false; } } return(model); } else { return(null); } }