public static SqlDataReader ReaderSelect(ESLRecodeData d) { StringBuilder sql = new StringBuilder(); sql.Append("select * from ESLRecode "); return(WFNetLib.ADO.SQLServerOP.ReaderExecuteSQL(sql.ToString())); }
public static ESLRecodeData Construct(DataRow dr) { ESLRecodeData data = new ESLRecodeData(); try { data.Pass = Convert.ToString(dr["Pass"]); } catch { } try { data.Ret = Convert.ToString(dr["Ret"]); } catch { } return(data); }
public static int Insert(ESLRecodeData d) { StringBuilder sql = new StringBuilder(); sql.Append("insert into ESLRecode ("); sql.Append("Pass, "); sql.Append("Ret"); sql.Append(") values ("); sql.Append("'"); sql.Append(d.Pass.ToString()); sql.Append("'"); sql.Append(", "); sql.Append("'"); sql.Append(d.Ret.ToString()); sql.Append("'"); sql.Append(")"); return(WFNetLib.ADO.SQLServerOP.NonQuerySQL(sql.ToString())); }
public static ESLRecodeData Construct(DataTable dt, int rowIndex) { ESLRecodeData data = new ESLRecodeData(); if (dt.Rows.Count < rowIndex + 1) { return(null); } DataRow dr = dt.Rows[rowIndex]; if (dr == null) { return(null); } try { data.Pass = Convert.ToString(dr["Pass"]); } catch { } try { data.Ret = Convert.ToString(dr["Ret"]); } catch { } return(data); }