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);
}