/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "Sys_Common_Dic";
* parameters[1].Value = "DicID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eastcom.Model.Sys_Common_Dic GetModel(string parentName, string childName, string grandsonName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT TOP 1 * FROM dbo.Sys_Common_Dic WHERE DicName=@grandsonName AND ParentID=(SELECT TOP 1 DicID FROM dbo.Sys_Common_Dic WHERE DicName=@childName AND ParentID=(SELECT TOP 1 DicID FROM dbo.Sys_Common_Dic WHERE ParentID=0 AND DicName=@parentName))");
SqlParameter[] parameters =
{
new SqlParameter("@parentName", SqlDbType.VarChar, 500),
new SqlParameter("@childName", SqlDbType.VarChar, 500),
new SqlParameter("@grandsonName", SqlDbType.VarChar, 500)
};
parameters[0].Value = parentName;
parameters[1].Value = childName;
parameters[2].Value = grandsonName;
Eastcom.Model.Sys_Common_Dic model = new Eastcom.Model.Sys_Common_Dic();
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 bool Update(Eastcom.Model.Sys_Common_Dic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_Common_Dic set ");
strSql.Append("ParentID=@ParentID,");
strSql.Append("DicName=@DicName,");
strSql.Append("DicValue=@DicValue,");
strSql.Append("IsReadOnly=@IsReadOnly,");
strSql.Append("IsHasChild=@IsHasChild,");
strSql.Append("Remark=@Remark,");
strSql.Append("FK_EditID=@FK_EditID,");
strSql.Append("EditTime=@EditTime,");
strSql.Append("FK_CreateID=@FK_CreateID,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("Sort=@Sort");
strSql.Append(" where DicID=@DicID");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@DicName", SqlDbType.VarChar, 500),
new SqlParameter("@DicValue", SqlDbType.VarChar, 500),
new SqlParameter("@IsReadOnly", SqlDbType.TinyInt, 1),
new SqlParameter("@IsHasChild", SqlDbType.TinyInt, 1),
new SqlParameter("@Remark", SqlDbType.VarChar, 1000),
new SqlParameter("@FK_EditID", SqlDbType.Int, 4),
new SqlParameter("@EditTime", SqlDbType.DateTime),
new SqlParameter("@FK_CreateID", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@DicID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.DicName;
parameters[2].Value = model.DicValue;
parameters[3].Value = model.IsReadOnly;
parameters[4].Value = model.IsHasChild;
parameters[5].Value = model.Remark;
parameters[6].Value = model.FK_EditID;
parameters[7].Value = model.EditTime;
parameters[8].Value = model.FK_CreateID;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.Sort;
parameters[11].Value = model.DicID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eastcom.Model.Sys_Common_Dic DataRowToModel(DataRow row)
{
Eastcom.Model.Sys_Common_Dic model = new Eastcom.Model.Sys_Common_Dic();
if (row != null)
{
if (row["DicID"] != null && row["DicID"].ToString() != "")
{
model.DicID = int.Parse(row["DicID"].ToString());
}
if (row["ParentID"] != null && row["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(row["ParentID"].ToString());
}
if (row["DicName"] != null)
{
model.DicName = row["DicName"].ToString();
}
if (row["DicValue"] != null)
{
model.DicValue = row["DicValue"].ToString();
}
if (row["IsReadOnly"] != null && row["IsReadOnly"].ToString() != "")
{
model.IsReadOnly = int.Parse(row["IsReadOnly"].ToString());
}
if (row["IsHasChild"] != null && row["IsHasChild"].ToString() != "")
{
model.IsHasChild = int.Parse(row["IsHasChild"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["FK_EditID"] != null && row["FK_EditID"].ToString() != "")
{
model.FK_EditID = int.Parse(row["FK_EditID"].ToString());
}
if (row["EditTime"] != null && row["EditTime"].ToString() != "")
{
model.EditTime = DateTime.Parse(row["EditTime"].ToString());
}
if (row["FK_CreateID"] != null && row["FK_CreateID"].ToString() != "")
{
model.FK_CreateID = int.Parse(row["FK_CreateID"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["Sort"] != null && row["Sort"].ToString() != "")
{
model.Sort = int.Parse(row["Sort"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Eastcom.Model.Sys_Common_Dic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_Common_Dic(");
strSql.Append("ParentID,DicName,DicValue,IsReadOnly,IsHasChild,Remark,FK_EditID,EditTime,FK_CreateID,CreateTime,Sort)");
strSql.Append(" values (");
strSql.Append("@ParentID,@DicName,@DicValue,@IsReadOnly,@IsHasChild,@Remark,@FK_EditID,@EditTime,@FK_CreateID,@CreateTime,@Sort)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@DicName", SqlDbType.VarChar, 500),
new SqlParameter("@DicValue", SqlDbType.VarChar, 500),
new SqlParameter("@IsReadOnly", SqlDbType.TinyInt, 1),
new SqlParameter("@IsHasChild", SqlDbType.TinyInt, 1),
new SqlParameter("@Remark", SqlDbType.VarChar, 1000),
new SqlParameter("@FK_EditID", SqlDbType.Int, 4),
new SqlParameter("@EditTime", SqlDbType.DateTime),
new SqlParameter("@FK_CreateID", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Sort", SqlDbType.Int, 4)
};
parameters[0].Value = model.ParentID;
parameters[1].Value = model.DicName;
parameters[2].Value = model.DicValue;
parameters[3].Value = model.IsReadOnly;
parameters[4].Value = model.IsHasChild;
parameters[5].Value = model.Remark;
parameters[6].Value = model.FK_EditID;
parameters[7].Value = model.EditTime;
parameters[8].Value = model.FK_CreateID;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.Sort;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据父权限名称 获取List
/// </summary>
/// <param name="parentName"></param>
/// <returns></returns>
public List <Eastcom.Model.Sys_Common_Dic> GetModelListByParentName(string parentName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM dbo.v_Sys_Common_Dic WHERE 父权限名=@parentName ");
SqlParameter[] parameters =
{
new SqlParameter("@parentName", SqlDbType.VarChar, 500)
};
parameters[0].Value = parentName;
Eastcom.Model.Sys_Common_Dic model = new Eastcom.Model.Sys_Common_Dic();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataTableToList(ds.Tables[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eastcom.Model.Sys_Common_Dic GetModel(int DicID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DicID,ParentID,DicName,DicValue,IsReadOnly,IsHasChild,Remark,FK_EditID,EditTime,FK_CreateID,CreateTime,Sort from Sys_Common_Dic ");
strSql.Append(" where DicID=@DicID");
SqlParameter[] parameters =
{
new SqlParameter("@DicID", SqlDbType.Int, 4)
};
parameters[0].Value = DicID;
Eastcom.Model.Sys_Common_Dic model = new Eastcom.Model.Sys_Common_Dic();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}