/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="RowName">条件字段名</param>
/// <param name="oValue">条件字段值</param>
public static void LoadSelectionBySql(ref System.Web.UI.WebControls.DropDownList DDL_Items, string sql, string mtext, string mvalue)
{
DDL_Items.DataSource = CSql.CreateDataSet(sql);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="ConStr">条件字段</param>
public static void LoadSelection(ref System.Web.UI.WebControls.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string ConStr)
{
string sqlTxt = "SELECT * FROM " + tablename + " where " + ConStr;
DDL_Items.DataSource = CSql.CreateDataSet(sqlTxt);
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 查询指定值对应的名称（根据编码查找对应名称）
/// </summary>
/// <param name="table">表名</param>
/// <param name="Filedname">查询字段名</param>
/// <param name="Filedid">条件字段</param>
/// <param name="value">条件值</param>
/// <returns>查询字段值</returns>
public static string GetNamebyID(string table, string Filedname, string Filedid, string value)
{
DataSet ds = new DataSet();
string sqlTxt = "SELECT " + Filedname + " from " + table + " where " + Filedid + "='" + value + "'";
ds = CSql.CreateDataSet(sqlTxt);
if (ds.Tables[0].Rows.Count > 0 && !(ds.Tables[0].Rows[0][0] is System.DBNull))
{
return(ds.Tables[0].Rows[0][0].ToString());
}
return("");
}
/// <summary>
/// 执行insert SQL 语句,返回新插入记录自增字段的值
/// </summary>
/// <param name="strsql">SQL语句</param>
/// <returns>执行成功与否</returns>
public static int ExecuteInsertSql(string strsql)
{
strsql += ";select @@IDENTITY";
object obj = CSql.GetObjectSingle(strsql);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据名称获取对应编号
/// </summary>
/// <param name="TableName">表格名称</param>
/// <param name="mText">名称字段</param>
/// <param name="mID">编号字段</param>
/// <param name="mValue">编号值</param>
/// <returns>名称</returns>
public static string GetIDByText(string TableName, string mText, string mID, string mValue)
{
string ID = "不详";
string sql = "SELECT " + mID + " FROM " + TableName + " where " + mText + " = '" + mValue + "'";
DataSet ds = new DataSet();
ds = CSql.CreateDataSet(sql);
if (ds.Tables[0].Rows.Count >= 0)
{
ID = ds.Tables[0].Rows[0][0].ToString();
}
return(ID);
}
/// <summary>
/// 分页方式获取DataSet
/// </summary>
/// <param name="SQL">SQL 语句</param>
/// <param name="Page">当前页号</param>
/// <param name="RecsPerPage">每页记录数</param>
/// <param name="ID">索引字段</param>
/// <param name="Sort">排序字段</param>
/// <returns>当前页的记录集合</returns>
public static DataSet GetPageDataSet(string SQL, int Page, int RecsPerPage, string ID, string Sort)
{
int iPage = RecsPerPage * (Page - 1);
string sql = "";
if (iPage == 0)
{
sql = "SELECT TOP " + RecsPerPage + " * FROM (" + SQL + ") T ORDER BY " + Sort;
}
else
{
sql = "SELECT TOP " + RecsPerPage + " * FROM (" + SQL + ") T WHERE T." + ID + " NOT IN (SELECT TOP " + iPage.ToString() + " " + ID + " FROM (" + SQL + ") T9 ORDER BY " + Sort + ") ORDER BY " + Sort;
} DataSet ds = new DataSet();
ds = CSql.CreateDataSet(sql);
return(ds);
}
/// <summary>
///下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="isTextShowCode">文本带编号显示</param>
public static void LoadSelection(ref System.Web.UI.WebControls.DropDownList DDL_Items, string tablename, string mtext, string mvalue, bool isShowWithCode)
{
string sqlTxt = "";
if (isShowWithCode == true)
{
sqlTxt = "SELECT " + mvalue + "+' | '+" + mtext + " as " + mtext + "," + mvalue + " FROM " + tablename + " order by " + mvalue;
}
else
{
sqlTxt = "SELECT " + mtext + "," + mvalue + " FROM " + tablename + " order by " + mvalue;
}
DDL_Items.DataSource = CSql.CreateDataSet(sqlTxt);
DDL_Items.Items.Clear();
DDL_Items.SelectedIndex = -1;
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 根据特定条件,下拉框数据加载
/// </summary>
/// <param name="DDL_Items">下拉框</param>
/// <param name="tablename">表名</param>
/// <param name="mtext">名称字段</param>
/// <param name="mvalue">编号字段</param>
/// <param name="ConStr">条件字段</param>
/// <param name="defaultText">默认字段（插入第一行的字段）文本内容</param>
/// <param name="defaultValue">默认字段（插入第一行的字段）值</param>
public static void LoadSelection(ref System.Web.UI.WebControls.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string ConStr, string defaultText, string defaultValue)
{
string sqlTxt = "SELECT * FROM " + tablename + " where " + ConStr;
DataSet ds = new DataSet();
ds = CSql.CreateDataSet(sqlTxt);
//添加一行选择行
DataRow dr = ds.Tables[0].NewRow();
dr[mvalue] = defaultValue;
dr[mtext] = defaultText;
ds.Tables[0].Rows.InsertAt(dr, 0);
DDL_Items.DataSource = ds.Tables[0];
DDL_Items.Items.Clear();
DDL_Items.DataTextField = mtext;
DDL_Items.DataValueField = mvalue;
DDL_Items.DataBind();
}
/// <summary>
/// 特定条件信息获取
/// </summary>
/// <param name="TableName">表名</param>
/// <param name="RowName">条件字段</param>
/// <param name="mValue">条件值</param>
/// <returns></returns>
public static DataSet GetSelections(string TableName, string RowName, string mValue)
{
string sqlTxt = "SELECT * FROM " + TableName + " where " + RowName + " = '" + mValue + "'" + " order by " + mValue;;
return(CSql.CreateDataSet(sqlTxt));
}
/// <summary>
/// 根据表名数据获取
/// </summary>
/// <param name="TableName">表名</param>
/// <returns>数据集</returns>
public static DataSet GetSelections(string TableName)
{
string sqlTxt = "SELECT * FROM " + TableName;
return(CSql.CreateDataSet(sqlTxt));
}
