/// <summary>
/// 得到一个对象实体
/// </summary>
public FOUNDERPCB_ANALYSIS GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,SOURCE_CODE,ID_KEY,ANS_NAME from FOUNDERPCB_ANALYSIS with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
FOUNDERPCB_ANALYSIS model = new FOUNDERPCB_ANALYSIS();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
model.SOURCE_CODE = ds.Tables[0].Rows[0]["SOURCE_CODE"].ToString();
if (ds.Tables[0].Rows[0]["ID_KEY"].ToString() != "")
{
model.ID_KEY = int.Parse(ds.Tables[0].Rows[0]["ID_KEY"].ToString());
}
model.ANS_NAME = ds.Tables[0].Rows[0]["ANS_NAME"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Approval_Mode_1Info GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,FILE_POINTER,SOURCE_TYPE,FROM_STEP_NO,TO_STEP_NO,TRANS_TYPE,TRANS_DESCRIPTION,USER_PTR,TRANS_DATE_TIME from Approval_Mode_1 with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
Approval_Mode_1Info model = new Approval_Mode_1Info();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
if (ds.Tables[0].Rows[0]["FILE_POINTER"].ToString() != "")
{
model.FILE_POINTER = int.Parse(ds.Tables[0].Rows[0]["FILE_POINTER"].ToString());
}
if (ds.Tables[0].Rows[0]["SOURCE_TYPE"].ToString() != "")
{
model.SOURCE_TYPE = int.Parse(ds.Tables[0].Rows[0]["SOURCE_TYPE"].ToString());
}
if (ds.Tables[0].Rows[0]["FROM_STEP_NO"].ToString() != "")
{
model.FROM_STEP_NO = int.Parse(ds.Tables[0].Rows[0]["FROM_STEP_NO"].ToString());
}
if (ds.Tables[0].Rows[0]["TO_STEP_NO"].ToString() != "")
{
model.TO_STEP_NO = int.Parse(ds.Tables[0].Rows[0]["TO_STEP_NO"].ToString());
}
if (ds.Tables[0].Rows[0]["TRANS_TYPE"].ToString() != "")
{
model.TRANS_TYPE = int.Parse(ds.Tables[0].Rows[0]["TRANS_TYPE"].ToString());
}
model.TRANS_DESCRIPTION = ds.Tables[0].Rows[0]["TRANS_DESCRIPTION"].ToString();
if (ds.Tables[0].Rows[0]["USER_PTR"].ToString() != "")
{
model.USER_PTR = int.Parse(ds.Tables[0].Rows[0]["USER_PTR"].ToString());
}
if (ds.Tables[0].Rows[0]["TRANS_DATE_TIME"].ToString() != "")
{
model.TRANS_DATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["TRANS_DATE_TIME"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Approval_Mode_2Info GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,FILE_POINTER,SOURCE_TYPE,APPROVAL_ROUTE_PTR,APPROVAL_STATUS,APPROVAL_STEP_NO,TOTAL_STEPS from Approval_Mode_2 with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
Approval_Mode_2Info model = new Approval_Mode_2Info();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
if (ds.Tables[0].Rows[0]["FILE_POINTER"].ToString() != "")
{
model.FILE_POINTER = int.Parse(ds.Tables[0].Rows[0]["FILE_POINTER"].ToString());
}
if (ds.Tables[0].Rows[0]["SOURCE_TYPE"].ToString() != "")
{
model.SOURCE_TYPE = int.Parse(ds.Tables[0].Rows[0]["SOURCE_TYPE"].ToString());
}
if (ds.Tables[0].Rows[0]["APPROVAL_ROUTE_PTR"].ToString() != "")
{
model.APPROVAL_ROUTE_PTR = int.Parse(ds.Tables[0].Rows[0]["APPROVAL_ROUTE_PTR"].ToString());
}
if (ds.Tables[0].Rows[0]["APPROVAL_STATUS"].ToString() != "")
{
model.APPROVAL_STATUS = int.Parse(ds.Tables[0].Rows[0]["APPROVAL_STATUS"].ToString());
}
if (ds.Tables[0].Rows[0]["APPROVAL_STEP_NO"].ToString() != "")
{
model.APPROVAL_STEP_NO = int.Parse(ds.Tables[0].Rows[0]["APPROVAL_STEP_NO"].ToString());
}
if (ds.Tables[0].Rows[0]["TOTAL_STEPS"].ToString() != "")
{
model.TOTAL_STEPS = int.Parse(ds.Tables[0].Rows[0]["TOTAL_STEPS"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RPT_SERVERPATH GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,SERVER_PATH,FLODER_PATH,TTYPE,ACTIVE_FLAG,EMP_PTR from RPT_SERVERPATH with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
RPT_SERVERPATH model = new RPT_SERVERPATH();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
model.SERVER_PATH = ds.Tables[0].Rows[0]["SERVER_PATH"].ToString();
model.FLODER_PATH = ds.Tables[0].Rows[0]["FLODER_PATH"].ToString();
if (ds.Tables[0].Rows[0]["TTYPE"].ToString() != "")
{
model.TTYPE = int.Parse(ds.Tables[0].Rows[0]["TTYPE"].ToString());
}
if (ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString() != "")
{
model.ACTIVE_FLAG = int.Parse(ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString());
}
if (ds.Tables[0].Rows[0]["EMP_PTR"].ToString() != "")
{
model.EMP_PTR = int.Parse(ds.Tables[0].Rows[0]["EMP_PTR"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RPT_QUICKREPORT_LINK GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,FROM_NAME,REPORT_NAME,REPORT_dESC,REPORT_PTR,EMP_PTR from RPT_QUICKREPORT_LINK with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
RPT_QUICKREPORT_LINK model = new RPT_QUICKREPORT_LINK();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
model.FROM_NAME = ds.Tables[0].Rows[0]["FROM_NAME"].ToString();
model.REPORT_NAME = ds.Tables[0].Rows[0]["REPORT_NAME"].ToString();
model.REPORT_dESC = ds.Tables[0].Rows[0]["REPORT_dESC"].ToString();
if (ds.Tables[0].Rows[0]["REPORT_PTR"].ToString() != "")
{
model.REPORT_PTR = int.Parse(ds.Tables[0].Rows[0]["REPORT_PTR"].ToString());
}
if (ds.Tables[0].Rows[0]["EMP_PTR"].ToString() != "")
{
model.EMP_PTR = int.Parse(ds.Tables[0].Rows[0]["EMP_PTR"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DATA0001 GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,SOURCE_CODE,ID_KEY,ANS_NAME from DATA0001 with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
DATA0001 model = new DATA0001();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
model.APPLYTIME = DateTime.Parse(ds.Tables[0].Rows[0]["APPLYTIME"].ToString());
model.DEPT = ds.Tables[0].Rows[0]["DEPT"].ToString();
model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString();
model.NUMBER = ds.Tables[0].Rows[0]["NUMBER"].ToString();
model.KIND = ds.Tables[0].Rows[0]["KIND"].ToString();
model.TYPE = ds.Tables[0].Rows[0]["TYPE"].ToString();
model.REACHTIME = ds.Tables[0].Rows[0]["REACHTIME"].ToString();
model.PROTYPE = ds.Tables[0].Rows[0]["PROTYPE"].ToString();
model.MAPNUMB = ds.Tables[0].Rows[0]["MAPNUMB"].ToString();
model.ATTACH = ds.Tables[0].Rows[0]["ATTACH"].ToString();
model.REASON = ds.Tables[0].Rows[0]["REASON"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Approval_Mode_NoteInfo GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,FILE_POINTER,SOURCE_TYPE,NOTES from Approval_Mode_Note with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
Approval_Mode_NoteInfo model = new Approval_Mode_NoteInfo();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
if (ds.Tables[0].Rows[0]["FILE_POINTER"].ToString() != "")
{
model.FILE_POINTER = int.Parse(ds.Tables[0].Rows[0]["FILE_POINTER"].ToString());
}
if (ds.Tables[0].Rows[0]["SOURCE_TYPE"].ToString() != "")
{
model.SOURCE_TYPE = int.Parse(ds.Tables[0].Rows[0]["SOURCE_TYPE"].ToString());
}
model.NOTES = ds.Tables[0].Rows[0]["NOTES"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RPT_MODUL GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,MODUL_NAME,ACTIVE_FLAG,EMP_PTR from RPT_MODUL with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
RPT_MODUL model = new RPT_MODUL();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
model.MODUL_NAME = ds.Tables[0].Rows[0]["MODUL_NAME"].ToString();
if (ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString() != "")
{
model.ACTIVE_FLAG = int.Parse(ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString());
}
if (ds.Tables[0].Rows[0]["EMP_PTR"].ToString() != "")
{
model.EMP_PTR = int.Parse(ds.Tables[0].Rows[0]["EMP_PTR"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Approval_Mode_4Info GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,ROUTE_STEP_PTR,USER_PTR from Approval_Mode_4 with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
Approval_Mode_4Info model = new Approval_Mode_4Info();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
if (ds.Tables[0].Rows[0]["ROUTE_STEP_PTR"].ToString() != "")
{
model.ROUTE_STEP_PTR = int.Parse(ds.Tables[0].Rows[0]["ROUTE_STEP_PTR"].ToString());
}
if (ds.Tables[0].Rows[0]["USER_PTR"].ToString() != "")
{
model.USER_PTR = int.Parse(ds.Tables[0].Rows[0]["USER_PTR"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public RPT_SETPARM GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,SERVER_PTR,MODUL_PTR,TTYPE,REPORT_PATH,REPORT_NAME,DISPLAY_NAME,REPORT_CODE,REPORT_PARM,QUICK_PRINT,CHOOSE_PAYE,MARGINS_TOP,MARGINS_BUTTOM,MARGINS_LEFT,MARGINS_RIGHT,ACTIVE_FLAG,EMP_PTR from RPT_SETPARM with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
RPT_SETPARM model = new RPT_SETPARM();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
if (ds.Tables[0].Rows[0]["SERVER_PTR"].ToString() != "")
{
model.SERVER_PTR = int.Parse(ds.Tables[0].Rows[0]["SERVER_PTR"].ToString());
}
if (ds.Tables[0].Rows[0]["MODUL_PTR"].ToString() != "")
{
model.MODUL_PTR = int.Parse(ds.Tables[0].Rows[0]["MODUL_PTR"].ToString());
}
model.TTYPE = ds.Tables[0].Rows[0]["TTYPE"].ToString();
model.REPORT_PATH = ds.Tables[0].Rows[0]["REPORT_PATH"].ToString();
model.REPORT_NAME = ds.Tables[0].Rows[0]["REPORT_NAME"].ToString();
model.DISPLAY_NAME = ds.Tables[0].Rows[0]["DISPLAY_NAME"].ToString();
model.REPORT_CODE = ds.Tables[0].Rows[0]["REPORT_CODE"].ToString();
model.REPORT_PARM = ds.Tables[0].Rows[0]["REPORT_PARM"].ToString();
if (ds.Tables[0].Rows[0]["QUICK_PRINT"].ToString() != "")
{
model.QUICK_PRINT = int.Parse(ds.Tables[0].Rows[0]["QUICK_PRINT"].ToString());
}
if (ds.Tables[0].Rows[0]["CHOOSE_PAYE"].ToString() != "")
{
model.CHOOSE_PAYE = int.Parse(ds.Tables[0].Rows[0]["CHOOSE_PAYE"].ToString());
}
if (ds.Tables[0].Rows[0]["MARGINS_TOP"].ToString() != "")
{
model.MARGINS_TOP = int.Parse(ds.Tables[0].Rows[0]["MARGINS_TOP"].ToString());
}
if (ds.Tables[0].Rows[0]["MARGINS_BUTTOM"].ToString() != "")
{
model.MARGINS_BUTTOM = int.Parse(ds.Tables[0].Rows[0]["MARGINS_BUTTOM"].ToString());
}
if (ds.Tables[0].Rows[0]["MARGINS_LEFT"].ToString() != "")
{
model.MARGINS_LEFT = int.Parse(ds.Tables[0].Rows[0]["MARGINS_LEFT"].ToString());
}
if (ds.Tables[0].Rows[0]["MARGINS_RIGHT"].ToString() != "")
{
model.MARGINS_RIGHT = int.Parse(ds.Tables[0].Rows[0]["MARGINS_RIGHT"].ToString());
}
if (ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString() != "")
{
model.ACTIVE_FLAG = int.Parse(ds.Tables[0].Rows[0]["ACTIVE_FLAG"].ToString());
}
if (ds.Tables[0].Rows[0]["EMP_PTR"].ToString() != "")
{
model.EMP_PTR = int.Parse(ds.Tables[0].Rows[0]["EMP_PTR"].ToString());
}
return(model);
}
else
{
return(null);
}
}
