/// <summary>
///
/// 编写日期：2010-4-9
/// 编写人：GWF
/// </summary>
/// <param name="GUID"></param>
public Detail_CAW_BANK_PREFINISH GetDetail(string GUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_PREFINISH A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + GUID + "' ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
Detail_CAW_BANK_PREFINISH myDetail = new Detail_CAW_BANK_PREFINISH();
using (IDataReader myReader = db.ExecuteReader(cmd))
{
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["GUID"]))
{
myDetail.GUID = Convert.ToString(myReader["GUID"]);
}
if (!Convert.IsDBNull(myReader["DOCACCGUID"]))
{
myDetail.DOCACCGUID = Convert.ToString(myReader["DOCACCGUID"]);
}
if (!Convert.IsDBNull(myReader["APPLICANT"]))
{
myDetail.APPLICANT = Convert.ToString(myReader["APPLICANT"]);
}
if (!Convert.IsDBNull(myReader["APPLYDATE"]))
{
myDetail.APPLYDATE = Convert.ToDateTime(myReader["APPLYDATE"]);
}
if (!Convert.IsDBNull(myReader["ORGOPION"]))
{
myDetail.ORGOPION = Convert.ToString(myReader["ORGOPION"]);
}
if (!Convert.IsDBNull(myReader["NOTE"]))
{
myDetail.NOTE = Convert.ToString(myReader["NOTE"]);
}
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["DESIGNERUNIT"]))
{
myDetail.DESIGNERUNIT = Convert.ToString(myReader["DESIGNERUNIT"]);
}
if (!Convert.IsDBNull(myReader["DESIGNERGRADE"]))
{
myDetail.DESIGNERGRADE = Convert.ToString(myReader["DESIGNERGRADE"]);
}
if (!Convert.IsDBNull(myReader["BUILDERUNIT"]))
{
myDetail.BUILDERUNIT = Convert.ToString(myReader["BUILDERUNIT"]);
}
if (!Convert.IsDBNull(myReader["BUILDERGRADE"]))
{
myDetail.BUILDERGRADE = Convert.ToString(myReader["BUILDERGRADE"]);
}
if (!Convert.IsDBNull(myReader["SUPUNIT"]))
{
myDetail.SUPUNIT = Convert.ToString(myReader["SUPUNIT"]);
}
if (!Convert.IsDBNull(myReader["SUPGRADE"]))
{
myDetail.SUPGRADE = Convert.ToString(myReader["SUPGRADE"]);
}
if (!Convert.IsDBNull(myReader["SUPERVISIONORG"]))
{
myDetail.SUPERVISIONORG = Convert.ToString(myReader["SUPERVISIONORG"]);
}
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_PREFINISH> GetProject(string CORGUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.PROJECTNAME,A.GUID FROM CAW_BANK_PREFINISH 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_PREFINISH> ProjectList = new List<Detail_CAW_BANK_PREFINISH>();
for (int i = 0; i < dv.Count; i++)
{
Detail_CAW_BANK_PREFINISH Project = new Detail_CAW_BANK_PREFINISH();
Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString();
Project.GUID = dv[i]["GUID"].ToString();
ProjectList.Add(Project);
}
return ProjectList;
}