/// <summary>
///
/// 编写日期：2010-3-29
/// 编写人：GWF
/// </summary>
/// <param name="GUID"></param>
/// <param name="APPLYGUID"></param>
/// <param name="PROJECTNAME"></param>
/// <param name="PROJECTADDRESS"></param>
/// <param name="CORGUID"></param>
/// <param name="CORNAME"></param>
/// <param name="CORMANAGER"></param>
/// <summary>
///
/// 编写日期：2010-3-29
/// 编写人：GWF
/// </summary>
/// <param name="GUID"></param>
public Detail_CAW_BANK_TRYRUN GetDetail(string Guid)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_TRYRUN A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + Guid + "' ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
Detail_CAW_BANK_TRYRUN myDetail = new Detail_CAW_BANK_TRYRUN();
using (IDataReader myReader = db.ExecuteReader(cmd))
{
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["GUID"]))
{
myDetail.GUID = Convert.ToString(myReader["GUID"]);
}
if (!Convert.IsDBNull(myReader["APPLYGUID"]))
{
myDetail.APPLYGUID = Convert.ToString(myReader["APPLYGUID"]);
}
if (!Convert.IsDBNull(myReader["PROJECTNAME"]))
{
myDetail.PROJECTNAME = Convert.ToString(myReader["PROJECTNAME"]);
}
if (!Convert.IsDBNull(myReader["PROJECTADDRESS"]))
{
myDetail.PROJECTADDRESS = Convert.ToString(myReader["PROJECTADDRESS"]);
}
if (!Convert.IsDBNull(myReader["CORGUID"]))
{
myDetail.CORGUID = Convert.ToString(myReader["CORGUID"]);
}
if (!Convert.IsDBNull(myReader["CORNAME"]))
{
myDetail.CORNAME = Convert.ToString(myReader["CORNAME"]);
}
if (!Convert.IsDBNull(myReader["CORMANAGER"]))
{
myDetail.CORMANAGER = Convert.ToString(myReader["CORMANAGER"]);
}
if (!Convert.IsDBNull(myReader["CONTACTOR"]))
{
myDetail.CONTACTOR = Convert.ToString(myReader["CONTACTOR"]);
}
if (!Convert.IsDBNull(myReader["CONTACTORTEL"]))
{
myDetail.CONTACTORTEL = Convert.ToString(myReader["CONTACTORTEL"]);
}
if (!Convert.IsDBNull(myReader["HB_OPION"]))
{
myDetail.HB_OPION = Convert.ToString(myReader["HB_OPION"]);
}
if (!Convert.IsDBNull(myReader["LDAQ_OPION"]))
{
myDetail.LDAQ_OPION = Convert.ToString(myReader["LDAQ_OPION"]);
}
if (!Convert.IsDBNull(myReader["XF_OPION"]))
{
myDetail.XF_OPION = Convert.ToString(myReader["XF_OPION"]);
}
if (!Convert.IsDBNull(myReader["JGYS_OPION"]))
{
myDetail.JGYS_OPION = Convert.ToString(myReader["JGYS_OPION"]);
}
if (!Convert.IsDBNull(myReader["LAWMAN_SIGN"]))
{
myDetail.LAWMAN_SIGN = Convert.ToString(myReader["LAWMAN_SIGN"]);
}
if (!Convert.IsDBNull(myReader["APPLYDATE"]))
{
myDetail.APPLYDATE = Convert.ToDateTime(myReader["APPLYDATE"]);
}
if (!Convert.IsDBNull(myReader["DATASTATUS"]))
{
myDetail.DATASTATUS = Convert.ToString(myReader["DATASTATUS"]);
}
if (!Convert.IsDBNull(myReader["DATASTATUS_NAME"]))
{
myDetail.DATASTATUS_NAME = Convert.ToString(myReader["DATASTATUS_NAME"]);
}
if (!Convert.IsDBNull(myReader["CHECKOPION"]))
{
myDetail.CHECKOPION = Convert.ToString(myReader["CHECKOPION"]);
}
}
}
return myDetail;
}
/// <summary>
///从通过审批的试运行中，获取项目名称列表
/// </summary>
/// <param name="CORGUID"></param>
/// <returns></returns>
public List<Detail_CAW_BANK_TRYRUN> GetProject(string CORGUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.PROJECTNAME,A.GUID FROM CAW_BANK_TRYRUN A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND B.DATASTATUS='2' AND A.CORGUID='" + CORGUID + "'";
DbCommand cmd = db.GetSqlStringCommand(strSql);
DataView dv = db.ExecuteDataView(cmd);
List<Detail_CAW_BANK_TRYRUN> ProjectList = new List<Detail_CAW_BANK_TRYRUN>();
for (int i = 0; i < dv.Count; i++)
{
Detail_CAW_BANK_TRYRUN Project = new Detail_CAW_BANK_TRYRUN();
Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString();
Project.GUID = dv[i]["GUID"].ToString();
ProjectList.Add(Project);
}
return ProjectList;
}
