/// <summary> /// 更新查询配置数据记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(RoadFlow.Data.Model.QueryDesign model) { string sql = @"UPDATE QueryDesign SET Name=@Name,TableName=@TableName,CreateUserID=@CreateUserID,CreateUserName=@CreateUserName,ConnectionID=@ConnectionID,SearchJson=@SearchJson,DisplayItem=@DisplayItem,LastModifyTime=@LastModifyTime,Status=@Status WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 50) { Value = model.Name }, new SqlParameter("@TableName", SqlDbType.NVarChar, 50) { Value = model.TableName }, new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }, new SqlParameter("@CreateUserName", SqlDbType.NVarChar, 50) { Value = model.CreateUserName }, new SqlParameter("@ConnectionID", SqlDbType.UniqueIdentifier, 50) { Value = model.ConnectionID }, new SqlParameter("@SearchJson", SqlDbType.NVarChar, 10000) { Value = model.SearchJson }, new SqlParameter("@DisplayItem", SqlDbType.NVarChar, 10000) { Value = model.DisplayItem.IsNullOrEmpty() == true? "":model.DisplayItem }, new SqlParameter("@LastModifyTime", SqlDbType.DateTime) { Value = DateTime.Now }, new SqlParameter("@Status", SqlDbType.Int, 4) { Value = model.Status } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加配置记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.WorkFlowButtons实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.QueryDesign model) { string sql = @"INSERT INTO QueryDesign([ID],[Name],[TableName],[CreateUserID],[CreateUserName],[ConnectionID],[SearchJson],[DisplayItem],[CreateTime],[LastModifyTime],[Status]) VALUES(@ID,@Name,@TableName,@CreateUserID,@CreateUserName,@ConnectionID,@SearchJson,@DisplayItem,@CreateTime,@LastModifyTime,@Status)" ; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }); parameters.Add(new SqlParameter("@TableName", SqlDbType.NVarChar, 50) { Value = model.TableName }); parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar, 50) { Value = model.Name }); parameters.Add(new SqlParameter("@CreateUserID", SqlDbType.UniqueIdentifier, -1) { Value = model.CreateUserID }); parameters.Add(new SqlParameter("@CreateUserName", SqlDbType.NVarChar, 50) { Value = model.CreateUserName }); parameters.Add(new SqlParameter("@ConnectionID", SqlDbType.UniqueIdentifier, -1) { Value = model.ConnectionID }); parameters.Add(new SqlParameter("@SearchJson", SqlDbType.NVarChar, 5000) { Value = model.SearchJson }); if (model.DisplayItem.IsNullOrEmpty()) { parameters.Add(new SqlParameter("@DisplayItem", SqlDbType.NVarChar, 10000) { Value = DBNull.Value }); } else { parameters.Add(new SqlParameter("@DisplayItem", SqlDbType.NVarChar, 10000) { Value = model.DisplayItem }); } parameters.Add(new SqlParameter("@CreateTime", SqlDbType.DateTime) { Value = DateTime.Now }); parameters.Add(new SqlParameter("@LastModifyTime", SqlDbType.DateTime) { Value = DateTime.Now }); parameters.Add(new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }); return(dbHelper.Execute(sql, parameters.ToArray())); }