//根据表的主键数据获取表的数据
public DataTable GetTableDataByCondition(DataTable dt_column, string str_where)
{
/*table_id 表名 column_id 列名 attribute 要获取的属性值*/
string sql;
//string this_key;
// int str;
string str_table;
str_table = dt_column.Rows[0]["table_id"].ToString();
string column_id, primary_key;
sql = "SELECT ";
//str = 0;
for (int i = 0; i < dt_column.Rows.Count; i++)
{
primary_key = dt_column.Rows[i]["primary_key"].ToString();
column_id = dt_column.Rows[i]["column_id"].ToString();
sql = sql + " " + column_id + ",";
}
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
sql = sql.Substring(0, sql.Length - 1) + " From " + str_table + " WHERE 1 = 1 " + str_where;
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt);
}
public string GetStringTrueOrFalse(string ls_string, Boolean lb_true)
{
/***判断字符串的真假 返回 1 = 0 */
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql;
/**true 表示判断真假 返回的 1 或 0
* false 表示流程的语法 要解析成 sql 返回流程编号 或者 call 的内容
*
*/
if (lb_true)
{
sql = "Select Case When " + ls_string + " then 1 else 0 end ";
}
else
{
/*真假的内容已经替换好了 格式 ：if 1 then goto [10002] else goto [10003]
* 或者 ：if 1 then goto [10003] else call [gz0001]
*
*/
sql = "Select Case ";
}
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt.Rows[0][0].ToString());
}
public string GetOpitionHtml(string sql, string opition_id, string display_col, string data_col, string default_id, string classid, Boolean lb_eidt)
{
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
db.ExcuteDataTable(dt, sql, CommandType.Text);
System.Text.StringBuilder str_html = new System.Text.StringBuilder("");
if (lb_eidt == false)
{
str_html.Append("<select class =\"" + classid + "\" disabled id=\"" + opition_id + "\" onchange=\"selectchange(this)\">");
}
else
{
str_html.Append("<select class =\"" + classid + "\" id=\"" + opition_id + "\" onchange=\"selectchange(this)\">");
}
str_html.Append(Environment.NewLine);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][data_col].ToString() == default_id)
{
str_html.Append("<option selected value=\"" + dt.Rows[i][data_col].ToString() + "\">");
}
else
{
str_html.Append("<option value=\"" + dt.Rows[i][data_col].ToString() + "\">");
}
str_html.Append(dt.Rows[i][display_col].ToString());
str_html.Append(" </option> ");
str_html.Append(Environment.NewLine);
}
str_html.Append("</select>");
str_html.Append(Environment.NewLine);
return(str_html.ToString());
}
public DataTable GetPassWord(string userid)
{
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql = "Select * From A007 Where A007_ID= '" + userid + "'";
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt);
}
public string CheckUserExist(string userid)
{
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql = "Select Top 1 count(*) From A007 Where A007_ID= '" + userid + "'";
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt.Rows[0][0].ToString());
}
public DataTable GetColumnByTable(string str_table)
{
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql;
sql = "Select t.* from " + str_table + " t where 1 = 2 ";
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt);
}
public DataTable GetShowColumnByTable(string table_id, string table_type)
{
/*table_id 表名 根据表名称获取列的清单*/
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql = "Select * From A10001 Where tbl_type = '" + table_type + "' and TABLE_ID= '" + table_id + "' and BS_COLUMN = '1' order by sort_by asc ,line_no asc";
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt);
}
public DataTable GetSysConditionColumnByTable(string table_id)
{
/*table_id 表名 根据表名称获取列的清单*/
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql = "Select * From SYS_PROC_COLUMN Where TABLE_ID= '" + table_id + "' order by line_no asc";
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt);
}
public string GetColumnAttribute(string table_id, string column_id, string attribute)
{
/*table_id 表名 column_id 列名 attribute 要获取的属性值*/
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql = "Select Top 1 * From A10001 Where TABLE_ID= '" + table_id + "'";
sql += " AND COLUMN_ID= '" + column_id + "'";
db.ExcuteDataTable(dt, sql, CommandType.Text);
return(dt.Rows[0][attribute].ToString());
}
//写登录日志
public string update_login_log(string user_id, string a003_id)
{
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string sql = "write_login_log '" + user_id + "','" + a003_id + "'";
string a300_id;
a300_id = "";
db.ExcuteDataTable(dt, sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
a300_id = dt.Rows[0][0].ToString();
}
return(a300_id);
}
public string GetRadioHtml(string sql, string opition_id, string display_col, string data_col, string default_id, string classid, Boolean lb_eidt)
{
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
//<INPUT TYPE="radio" NAME="a" value="0" >男
//<INPUT TYPE="radio" NAME="a" value="1">女
db.ExcuteDataTable(dt, sql, CommandType.Text);
System.Text.StringBuilder str_html = new System.Text.StringBuilder("");
str_html.Append("<nobr>");
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][data_col].ToString() == default_id)
{
// str_html.Append("<option selected value=\"" + dt.Rows[i][data_col].ToString() + "\">");
if (lb_eidt == false)
{
str_html.Append("<INPUT TYPE=\"radio\" name=\"" + opition_id + "\" disabled id=\"" + opition_id + "_" + i.ToString() + "\" value=\"" + dt.Rows[i][data_col].ToString() + "\" checked onclick=\"rbselectchange(this)\">");
}
else
{
str_html.Append("<INPUT TYPE=\"radio\" name=\"" + opition_id + "\" id=\"" + opition_id + "_" + i.ToString() + "\" value=\"" + dt.Rows[i][data_col].ToString() + "\" checked onclick=\"rbselectchange(this)\">");
}
}
else
{
// str_html.Append("<option value=\"" + dt.Rows[i][data_col].ToString() + "\">");
if (lb_eidt == false)
{
str_html.Append("<INPUT TYPE=\"radio\" name=\"" + opition_id + "\" disabled id=\"" + opition_id + "_" + i.ToString() + "\" value=\"" + dt.Rows[i][data_col].ToString() + "\" onclick=\"rbselectchange(this)\">");
}
else
{
str_html.Append("<INPUT TYPE=\"radio\" name=\"" + opition_id + "\" id=\"" + opition_id + "_" + i.ToString() + "\" value=\"" + dt.Rows[i][data_col].ToString() + "\" onclick=\"rbselectchange(this)\">");
}
}
str_html.Append(dt.Rows[i][display_col].ToString());
str_html.Append(Environment.NewLine);
}
str_html.Append("</nobr>");
str_html.Append(Environment.NewLine);
return(str_html.ToString());
}
/*获取权限清单*/
public string GetA013Id(string userid)
{
DataTable dt = new DataTable();
SQLServer db = new SQLServer();
string a013_id;
a013_id = "";
string sql = "Select distinct a013_id From a00701 Where A007_ID= '" + userid + "'";
db.ExcuteDataTable(dt, sql, CommandType.Text);
for (int i = 0; i < dt.Rows.Count; i++)
{
a013_id = a013_id + dt.Rows[i][0].ToString() + ",";
}
return(a013_id);
}
