//根据表的主键数据获取表的数据 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); }