|
|
using System;using System.Data;using System.Text;using System.Data.SqlClient;using OT.IDAL;using DBUtility;
namespace OT.SQLServerDAL{
/// <summary>
/// 資料訪問類:OTB_SYS_PersonalGridManage
/// </summary>
public partial class OTB_SYS_PersonalGridManage : IOTB_SYS_PersonalGridManage { public OTB_SYS_PersonalGridManage() { } #region BasicMethod
/// <summary>
/// 是否存在該記錄
/// </summary>
public bool Exists(string Grid_Id, string PageName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from OTB_SYS_PersonalGridManage"); strSql.Append(" where Grid_Id=@Grid_Id or PageName=@PageName "); SqlParameter[] parameters = { new SqlParameter("@Grid_Id", SqlDbType.Char,36), new SqlParameter("@PageName", SqlDbType.NVarChar,100)}; parameters[0].Value = Grid_Id; parameters[1].Value = PageName;
return DbHelperSQL.Exists(strSql.ToString(), parameters); }
/// <summary>
/// 增加一條資料
/// </summary>
public bool Add(OT.Model.OTB_SYS_PersonalGridManage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OTB_SYS_PersonalGridManage("); strSql.Append("Grid_Id,GridTitle,PageName,TableName,DataField,FieldName,QueryField,QueryName,QueryType,QueryDefault,QueryWidth,GridSetting,sort_Order,sort,columnWidth,columnAlign,queryCondition,Type,Effective,limitCount,Pager,CreateUser,CreateDate,ModifyUser,ModifyDate)"); strSql.Append(" values ("); strSql.Append("@Grid_Id,@GridTitle,@PageName,@TableName,@DataField,@FieldName,@QueryField,@QueryName,@QueryType,@QueryDefault,@QueryWidth,@GridSetting,@sort_Order,@sort,@columnWidth,@columnAlign,@queryCondition,@Type,@Effective,@limitCount,@Pager,@CreateUser,GETDATE(),@CreateUser,GETDATE())"); SqlParameter[] parameters = { new SqlParameter("@Grid_Id", SqlDbType.Char,36), new SqlParameter("@GridTitle", SqlDbType.NVarChar,200), new SqlParameter("@PageName", SqlDbType.NVarChar,100), new SqlParameter("@TableName", SqlDbType.NVarChar,100), new SqlParameter("@DataField", SqlDbType.NVarChar,500), new SqlParameter("@FieldName", SqlDbType.NVarChar,500), new SqlParameter("@QueryField", SqlDbType.NVarChar,500), new SqlParameter("@QueryName", SqlDbType.NVarChar,500), new SqlParameter("@QueryType", SqlDbType.NVarChar,200), new SqlParameter("@QueryDefault", SqlDbType.NVarChar,200), new SqlParameter("@QueryWidth", SqlDbType.NVarChar,10), new SqlParameter("@GridSetting", SqlDbType.NVarChar,500), new SqlParameter("@sort_Order", SqlDbType.VarChar,500), new SqlParameter("@sort", SqlDbType.VarChar,500), new SqlParameter("@columnWidth", SqlDbType.NVarChar,500), new SqlParameter("@columnAlign", SqlDbType.NVarChar,500), new SqlParameter("@queryCondition", SqlDbType.NVarChar,500), new SqlParameter("@Type", SqlDbType.NVarChar,500), new SqlParameter("@Effective", SqlDbType.Char,1), new SqlParameter("@limitCount", SqlDbType.Int,4), new SqlParameter("@Pager", SqlDbType.Int,4), new SqlParameter("@CreateUser", SqlDbType.NVarChar,50)}; parameters[0].Value = model.Grid_Id; parameters[1].Value = model.GridTitle; parameters[2].Value = model.PageName; parameters[3].Value = model.TableName; parameters[4].Value = model.DataField; parameters[5].Value = model.FieldName; parameters[6].Value = model.QueryField; parameters[7].Value = model.QueryName; parameters[8].Value = model.QueryType; parameters[9].Value = model.QueryDefault; parameters[10].Value = model.QueryWidth; parameters[11].Value = model.GridSetting; parameters[12].Value = model.sort_Order; parameters[13].Value = model.sort; parameters[14].Value = model.columnWidth; parameters[15].Value = model.columnAlign; parameters[16].Value = model.queryCondition; parameters[17].Value = model.Type; parameters[18].Value = model.Effective; parameters[19].Value = model.limitCount; parameters[20].Value = model.Pager; parameters[21].Value = model.CreateUser;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } } /// <summary>
/// 更新一條資料
/// </summary>
public bool Update(OT.Model.OTB_SYS_PersonalGridManage model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OTB_SYS_PersonalGridManage set "); strSql.Append("Grid_Id=@Grid_Id,"); strSql.Append("GridTitle=@GridTitle,"); strSql.Append("PageName=@PageName,"); strSql.Append("TableName=@TableName,"); strSql.Append("DataField=@DataField,"); strSql.Append("FieldName=@FieldName,"); strSql.Append("QueryField=@QueryField,"); strSql.Append("QueryName=@QueryName,"); strSql.Append("QueryType=@QueryType,"); strSql.Append("QueryDefault=@QueryDefault,"); strSql.Append("QueryWidth=@QueryWidth,"); strSql.Append("GridSetting=@GridSetting,"); strSql.Append("sort_Order=@sort_Order,"); strSql.Append("sort=@sort,"); strSql.Append("columnWidth=@columnWidth,"); strSql.Append("columnAlign=@columnAlign,"); strSql.Append("queryCondition=@queryCondition,"); strSql.Append("Type=@Type,"); strSql.Append("Effective=@Effective,"); strSql.Append("limitCount=@limitCount,"); strSql.Append("Pager=@Pager,"); strSql.Append("ModifyUser=@ModifyUser,"); strSql.Append("ModifyDate=GETDATE()"); strSql.Append(" where Grid_Id=@Grid_Id "); SqlParameter[] parameters = { new SqlParameter("@Grid_Id", SqlDbType.Char,36), new SqlParameter("@GridTitle", SqlDbType.NVarChar,200), new SqlParameter("@PageName", SqlDbType.NVarChar,100), new SqlParameter("@TableName", SqlDbType.NVarChar,100), new SqlParameter("@DataField", SqlDbType.NVarChar,500), new SqlParameter("@FieldName", SqlDbType.NVarChar,500), new SqlParameter("@QueryField", SqlDbType.NVarChar,500), new SqlParameter("@QueryName", SqlDbType.NVarChar,500), new SqlParameter("@QueryType", SqlDbType.NVarChar,200), new SqlParameter("@QueryDefault", SqlDbType.NVarChar,200), new SqlParameter("@QueryWidth", SqlDbType.NVarChar,10), new SqlParameter("@GridSetting", SqlDbType.NVarChar,500), new SqlParameter("@sort_Order", SqlDbType.VarChar,500), new SqlParameter("@sort", SqlDbType.VarChar,500), new SqlParameter("@columnWidth", SqlDbType.NVarChar,500), new SqlParameter("@columnAlign", SqlDbType.NVarChar,500), new SqlParameter("@queryCondition", SqlDbType.NVarChar,500), new SqlParameter("@Type", SqlDbType.NVarChar,500), new SqlParameter("@Effective", SqlDbType.Char,1), new SqlParameter("@limitCount", SqlDbType.Int,4), new SqlParameter("@Pager", SqlDbType.Int,4), new SqlParameter("@ModifyUser", SqlDbType.NVarChar,50)}; parameters[0].Value = model.Grid_Id; parameters[1].Value = model.GridTitle; parameters[2].Value = model.PageName; parameters[3].Value = model.TableName; parameters[4].Value = model.DataField; parameters[5].Value = model.FieldName; parameters[6].Value = model.QueryField; parameters[7].Value = model.QueryName; parameters[8].Value = model.QueryType; parameters[9].Value = model.QueryDefault; parameters[10].Value = model.QueryWidth; parameters[11].Value = model.GridSetting; parameters[12].Value = model.sort_Order; parameters[13].Value = model.sort; parameters[14].Value = model.columnWidth; parameters[15].Value = model.columnAlign; parameters[16].Value = model.queryCondition; parameters[17].Value = model.Type; parameters[18].Value = model.Effective; parameters[19].Value = model.limitCount; parameters[20].Value = model.Pager; parameters[21].Value = model.ModifyUser;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary>
/// 刪除一條資料
/// </summary>
public bool Delete(string Grid_Id) {
StringBuilder strSql = new StringBuilder(); strSql.Append(" update OTB_SYS_PersonalGridManage "); strSql.Append(" set Effective = 'N' "); strSql.Append(" where Grid_Id=@Grid_Id "); SqlParameter[] parameters = { new SqlParameter("@Grid_Id", SqlDbType.Char,36) }; parameters[0].Value = Grid_Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } } /// <summary>
/// 批量刪除資料
/// </summary>
public bool DeleteList(string Grid_Idlist) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from OTB_SYS_PersonalGridManage "); strSql.Append(" where Grid_Id in (" + Grid_Idlist + ") "); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return true; } else { return false; } }
/// <summary>
/// 得到一個對象實體
/// </summary>
public OT.Model.OTB_SYS_PersonalGridManage GetModel(string Grid_Id) {
StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Grid_Id,GridTitle,PageName,TableName,DataField,FieldName,QueryType,GridSetting,sort_Order,sort,columnWidth,columnAlign,Type,Effective,Pager,CreateUser,CreateDate,ModifyUser,ModifyDate,isnull(limitCount,'0') as limitCount from OTB_SYS_PersonalGridManage "); strSql.Append(" where Grid_Id=@Grid_Id "); SqlParameter[] parameters = { new SqlParameter("@Grid_Id", SqlDbType.Char,36) }; parameters[0].Value = Grid_Id;
OT.Model.OTB_SYS_PersonalGridManage model = new OT.Model.OTB_SYS_PersonalGridManage(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary>
/// 得到一個對象實體
/// </summary>
public OT.Model.OTB_SYS_PersonalGridManage DataRowToModel(DataRow row) { OT.Model.OTB_SYS_PersonalGridManage model = new OT.Model.OTB_SYS_PersonalGridManage(); if (row != null) { if (row["Grid_Id"] != null) { model.Grid_Id = row["Grid_Id"].ToString(); } if (row["GridTitle"] != null) { model.GridTitle = row["GridTitle"].ToString(); } if (row["PageName"] != null) { model.PageName = row["PageName"].ToString(); } if (row["TableName"] != null) { model.TableName = row["TableName"].ToString(); } if (row["DataField"] != null) { model.DataField = row["DataField"].ToString(); } if (row["FieldName"] != null) { model.FieldName = row["FieldName"].ToString(); } if (row["QueryType"] != null) { model.QueryType = row["QueryType"].ToString(); } if (row["GridSetting"] != null) { model.GridSetting = row["GridSetting"].ToString(); } if (row["sort_Order"] != null) { model.sort_Order = row["sort_Order"].ToString(); } if (row["sort"] != null) { model.sort = row["sort"].ToString(); } if (row["columnWidth"] != null) { model.columnWidth = row["columnWidth"].ToString(); } if (row["columnAlign"] != null) { model.columnAlign = row["columnAlign"].ToString(); } if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["Effective"] != null) { model.Effective = row["Effective"].ToString(); } if (row["Pager"] != null && row["Pager"].ToString() != "") { model.Pager = int.Parse(row["Pager"].ToString()); } if (row["CreateUser"] != null) { model.CreateUser = row["CreateUser"].ToString(); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["ModifyUser"] != null) { model.ModifyUser = row["ModifyUser"].ToString(); } if (row["ModifyDate"] != null && row["ModifyDate"].ToString() != "") { model.ModifyDate = DateTime.Parse(row["ModifyDate"].ToString()); } if (row["limitCount"] != null) { model.limitCount = row["limitCount"].ToString(); } } return model; }
#endregion BasicMethod
}}
|
