internal int Update(DbTransaction tran, Model_SysConfigurationItems_Dict model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" UPDATE ");
builder.Append(" SysConfigurationItems_Dict ");
builder.Append(" SET ");
builder.Append(" SysConfigurationItems_Dict_ID=@SysConfigurationItems_Dict_ID,D_Name=@D_Name,D_ParentID=@D_ParentID,D_Value=@D_Value,D_DisplayMode=@D_DisplayMode,D_LinkType=@D_LinkType,D_SysModel=@D_SysModel,D_Code=@D_Code,D_Order=@D_Order,D_Type=@D_Type,D_Remark=@D_Remark,D_CreateUser=@D_CreateUser,D_CreateTime=@D_CreateTime,D_ModifyUser=@D_ModifyUser,D_ModifyTime=@D_ModifyTime ");
builder.Append(" WHERE ");
builder.Append(" SysConfigurationItems_Dict_ID=@SysConfigurationItems_Dict_ID ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SysConfigurationItems_Dict_ID, model.D_Name, model.D_ParentID, model.D_Value, model.D_DisplayMode, model.D_LinkType, model.D_SysModel, model.D_Code, model.D_Order, model.D_Type, model.D_Remark, model.D_CreateUser, model.D_CreateTime, model.D_ModifyUser, model.D_ModifyTime }));
}
internal int Add(DbTransaction tran, Model_SysConfigurationItems_Dict model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO ");
builder.Append(" SysConfigurationItems_Dict( ");
builder.Append(" SysConfigurationItems_Dict_ID,D_Name,D_ParentID,D_Value,D_DisplayMode,D_LinkType,D_SysModel,D_Code,D_Order,D_Type,D_Remark,D_CreateUser,D_CreateTime,D_ModifyUser,D_ModifyTime ");
builder.Append(" ) ");
builder.Append(" values( ");
builder.Append(" @SysConfigurationItems_Dict_ID,@D_Name,@D_ParentID,@D_Value,@D_DisplayMode,@D_LinkType,@D_SysModel,@D_Code,@D_Order,@D_Type,@D_Remark,@D_CreateUser,@D_CreateTime,@D_ModifyUser,@D_ModifyTime ");
builder.Append(" ) ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SysConfigurationItems_Dict_ID, model.D_Name, model.D_ParentID, model.D_Value, model.D_DisplayMode, model.D_LinkType, model.D_SysModel, model.D_Code, model.D_Order, model.D_Type, model.D_Remark, model.D_CreateUser, model.D_CreateTime, model.D_ModifyUser, model.D_ModifyTime }));
}
public int Update(Model_SysConfigurationItems_Dict model)
{
return(this.Update(null, model));
}
internal List <Model_SysConfigurationItems_Dict> GetSysConfigurationItems_DictModelListByPage(DbTransaction tran, int pageSize, int pageIndex, string orderColumn, string orderType, string strCondition, params object[] param)
{
if ((pageSize <= 0) || (pageIndex <= 0))
{
throw new Exception("分页参数错误，必须大于零");
}
if (string.IsNullOrEmpty(orderColumn))
{
throw new Exception("排序字段必须填写");
}
int num = ((pageIndex - 1) * pageSize) + 1;
int num2 = pageIndex * pageSize;
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT * FROM (");
builder.Append(string.Format(" SELECT (ROW_NUMBER() OVER(ORDER BY {0} {1})) as rownum,* FROM SysConfigurationItems_Dict", orderColumn, orderType));
if (!string.IsNullOrWhiteSpace(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
builder.Append(" ) t ");
builder.Append(" WHERE rownum between ");
builder.Append(string.Format(" {0} ", num));
builder.Append(" AND ");
builder.Append(string.Format(" {0} ", num2));
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Model_SysConfigurationItems_Dict> list = new List <Model_SysConfigurationItems_Dict>();
Model_SysConfigurationItems_Dict item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SysConfigurationItems_Dict();
if (row["SysConfigurationItems_Dict_ID"] != null)
{
item.SysConfigurationItems_Dict_ID = row["SysConfigurationItems_Dict_ID"].ToString();
}
if (row["D_Name"] != null)
{
item.D_Name = row["D_Name"].ToString();
}
if (row["D_ParentID"] != null)
{
item.D_ParentID = row["D_ParentID"].ToString();
}
if (row["D_Value"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Value"].ToString()))
{
item.D_Value = null;
}
else
{
item.D_Value = new int?(int.Parse(row["D_Value"].ToString()));
}
}
if (row["D_DisplayMode"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_DisplayMode"].ToString()))
{
item.D_DisplayMode = null;
}
else
{
item.D_DisplayMode = new int?(int.Parse(row["D_DisplayMode"].ToString()));
}
}
if (row["D_LinkType"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_LinkType"].ToString()))
{
item.D_LinkType = null;
}
else
{
item.D_LinkType = new int?(int.Parse(row["D_LinkType"].ToString()));
}
}
if (row["D_SysModel"] != null)
{
item.D_SysModel = row["D_SysModel"].ToString();
}
if (row["D_Code"] != null)
{
item.D_Code = row["D_Code"].ToString();
}
if (row["D_Order"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Order"].ToString()))
{
item.D_Order = null;
}
else
{
item.D_Order = new int?(int.Parse(row["D_Order"].ToString()));
}
}
if (row["D_Type"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Type"].ToString()))
{
item.D_Type = null;
}
else
{
item.D_Type = new int?(int.Parse(row["D_Type"].ToString()));
}
}
if (row["D_Remark"] != null)
{
item.D_Remark = row["D_Remark"].ToString();
}
if (row["D_CreateUser"] != null)
{
item.D_CreateUser = row["D_CreateUser"].ToString();
}
if (row["D_CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString()))
{
item.D_CreateTime = null;
}
else
{
item.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString()));
}
}
if (row["D_ModifyUser"] != null)
{
item.D_ModifyUser = row["D_ModifyUser"].ToString();
}
if (row["D_ModifyTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString()))
{
item.D_ModifyTime = null;
}
else
{
item.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString()));
}
}
list.Add(item);
}
return(list);
}
internal List <Model_SysConfigurationItems_Dict> GetSysConfigurationItems_DictModelList(DbTransaction tran, int recordNum, string orderColumn, string orderType, string strCondition, params object[] param)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
if (recordNum > 0)
{
builder.Append(" TOP " + recordNum);
}
builder.Append(" * ");
builder.Append(" FROM ");
builder.Append(" SysConfigurationItems_Dict ");
if (!string.IsNullOrEmpty(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
if (!string.IsNullOrEmpty(orderColumn))
{
builder.Append(" ORDER BY ");
builder.Append(orderColumn);
if (!string.IsNullOrEmpty(orderType))
{
builder.Append(" " + orderType);
}
}
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Model_SysConfigurationItems_Dict> list = new List <Model_SysConfigurationItems_Dict>();
Model_SysConfigurationItems_Dict item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SysConfigurationItems_Dict();
if (row["SysConfigurationItems_Dict_ID"] != null)
{
item.SysConfigurationItems_Dict_ID = row["SysConfigurationItems_Dict_ID"].ToString();
}
if (row["D_Name"] != null)
{
item.D_Name = row["D_Name"].ToString();
}
if (row["D_ParentID"] != null)
{
item.D_ParentID = row["D_ParentID"].ToString();
}
if (row["D_Value"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Value"].ToString()))
{
item.D_Value = null;
}
else
{
item.D_Value = new int?(int.Parse(row["D_Value"].ToString()));
}
}
if (row["D_DisplayMode"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_DisplayMode"].ToString()))
{
item.D_DisplayMode = null;
}
else
{
item.D_DisplayMode = new int?(int.Parse(row["D_DisplayMode"].ToString()));
}
}
if (row["D_LinkType"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_LinkType"].ToString()))
{
item.D_LinkType = null;
}
else
{
item.D_LinkType = new int?(int.Parse(row["D_LinkType"].ToString()));
}
}
if (row["D_SysModel"] != null)
{
item.D_SysModel = row["D_SysModel"].ToString();
}
if (row["D_Code"] != null)
{
item.D_Code = row["D_Code"].ToString();
}
if (row["D_Order"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Order"].ToString()))
{
item.D_Order = null;
}
else
{
item.D_Order = new int?(int.Parse(row["D_Order"].ToString()));
}
}
if (row["D_Type"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Type"].ToString()))
{
item.D_Type = null;
}
else
{
item.D_Type = new int?(int.Parse(row["D_Type"].ToString()));
}
}
if (row["D_Remark"] != null)
{
item.D_Remark = row["D_Remark"].ToString();
}
if (row["D_CreateUser"] != null)
{
item.D_CreateUser = row["D_CreateUser"].ToString();
}
if (row["D_CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString()))
{
item.D_CreateTime = null;
}
else
{
item.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString()));
}
}
if (row["D_ModifyUser"] != null)
{
item.D_ModifyUser = row["D_ModifyUser"].ToString();
}
if (row["D_ModifyTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString()))
{
item.D_ModifyTime = null;
}
else
{
item.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString()));
}
}
list.Add(item);
}
return(list);
}
public int Add(Model_SysConfigurationItems_Dict model)
{
return(this.Add(null, model));
}
internal Model_SysConfigurationItems_Dict GetSysConfigurationItems_DictModelByPK(DbTransaction tran, string sysconfigurationitems_dict_id)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
builder.Append(" TOP 1 * ");
builder.Append(" FROM ");
builder.Append(" SysConfigurationItems_Dict ");
builder.Append(" WHERE ");
builder.Append(" SysConfigurationItems_Dict_ID=@SysConfigurationItems_Dict_ID ");
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, new object[] { sysconfigurationitems_dict_id });
Model_SysConfigurationItems_Dict dict = null;
if (set.Tables[0].Rows.Count > 0)
{
DataRow row = set.Tables[0].Rows[0];
dict = new Model_SysConfigurationItems_Dict();
if (row["SysConfigurationItems_Dict_ID"] != null)
{
dict.SysConfigurationItems_Dict_ID = row["SysConfigurationItems_Dict_ID"].ToString();
}
if (row["D_Name"] != null)
{
dict.D_Name = row["D_Name"].ToString();
}
if (row["D_ParentID"] != null)
{
dict.D_ParentID = row["D_ParentID"].ToString();
}
if (row["D_Value"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Value"].ToString()))
{
dict.D_Value = null;
}
else
{
dict.D_Value = new int?(int.Parse(row["D_Value"].ToString()));
}
}
if (row["D_DisplayMode"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_DisplayMode"].ToString()))
{
dict.D_DisplayMode = null;
}
else
{
dict.D_DisplayMode = new int?(int.Parse(row["D_DisplayMode"].ToString()));
}
}
if (row["D_LinkType"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_LinkType"].ToString()))
{
dict.D_LinkType = null;
}
else
{
dict.D_LinkType = new int?(int.Parse(row["D_LinkType"].ToString()));
}
}
if (row["D_SysModel"] != null)
{
dict.D_SysModel = row["D_SysModel"].ToString();
}
if (row["D_Code"] != null)
{
dict.D_Code = row["D_Code"].ToString();
}
if (row["D_Order"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Order"].ToString()))
{
dict.D_Order = null;
}
else
{
dict.D_Order = new int?(int.Parse(row["D_Order"].ToString()));
}
}
if (row["D_Type"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Type"].ToString()))
{
dict.D_Type = null;
}
else
{
dict.D_Type = new int?(int.Parse(row["D_Type"].ToString()));
}
}
if (row["D_Remark"] != null)
{
dict.D_Remark = row["D_Remark"].ToString();
}
if (row["D_CreateUser"] != null)
{
dict.D_CreateUser = row["D_CreateUser"].ToString();
}
if (row["D_CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString()))
{
dict.D_CreateTime = null;
}
else
{
dict.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString()));
}
}
if (row["D_ModifyUser"] != null)
{
dict.D_ModifyUser = row["D_ModifyUser"].ToString();
}
if (row["D_ModifyTime"] == null)
{
return(dict);
}
if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString()))
{
dict.D_ModifyTime = null;
return(dict);
}
dict.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString()));
}
return(dict);
}
