public ReportedPerson(int id)
{
var res = DB.SExecuteReader("select id,sexy,province,city,tel,arrears,count,loandate,repaydate,remark,pics,personid,checkstate,reportdate from " + _tableName + " where id=?", id);
if (res.Count == 0)
{
throw new Exception("没有找到改记录");
}
var row = res[0];
ID = Convert.ToInt32(row[0]);
Sexy = (string)row[1];
Province = (string)row[2];
City = (string)row[3];
Tel = (string)row[4];
Arrears = Convert.ToUInt32(row[5]);
Count = Convert.ToUInt32(row[6]);
LoanDate = Convert.ToDateTime(row[7]);
RepayDate = Convert.ToDateTime(row[8]);
Remark = (string)row[9];
Pics = (string)row[10];
PersonId = Convert.ToInt32(row[11]);
_checkState = (ReportedPersonCheckState)Convert.ToByte(row[12]);
ReportDate = Convert.ToDateTime(row[13]);
}
public ReportedPerson(int id)
{
var res = DB.SExecuteReader("select id,sexy,province,city,tel,arrears,count,loandate,repaydate,remark,pics,personid,checkstate,reportdate from " + _tableName + " where id=?", id);
if (res.Count == 0)
throw new Exception("没有找到改记录");
var row = res[0];
ID = Convert.ToInt32(row[0]);
Sexy = (string)row[1];
Province = (string)row[2];
City = (string)row[3];
Tel = (string)row[4];
Arrears = Convert.ToUInt32(row[5]);
Count = Convert.ToUInt32(row[6]);
LoanDate = Convert.ToDateTime(row[7]);
RepayDate = Convert.ToDateTime(row[8]);
Remark = (string)row[9];
Pics = (string)row[10];
PersonId = Convert.ToInt32(row[11]);
_checkState = (ReportedPersonCheckState)Convert.ToByte(row[12]);
ReportDate = Convert.ToDateTime(row[13]);
}
