/// <summary>
///
/// 编写日期：2010-3-30
/// 编写人：GWF
/// </summary>
/// <param name="GUID"></param>
public Detail_CAW_BANK_FILEACCEPTANCE GetDetail(string GUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_FILEACCEPTANCE A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + GUID + "' ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
Detail_CAW_BANK_FILEACCEPTANCE myDetail = new Detail_CAW_BANK_FILEACCEPTANCE();
using (IDataReader myReader = db.ExecuteReader(cmd))
{
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["GUID"]))
{
myDetail.GUID = Convert.ToString(myReader["GUID"]);
}
if (!Convert.IsDBNull(myReader["PROJECTNAME"]))
{
myDetail.PROJECTNAME = Convert.ToString(myReader["PROJECTNAME"]);
}
if (!Convert.IsDBNull(myReader["STARTWORKGUID"]))
{
myDetail.STARTWORKGUID = Convert.ToString(myReader["STARTWORKGUID"]);
}
if (!Convert.IsDBNull(myReader["SETITEMORG"]))
{
myDetail.SETITEMORG = Convert.ToString(myReader["SETITEMORG"]);
}
if (!Convert.IsDBNull(myReader["DESIGNDEPART"]))
{
myDetail.DESIGNDEPART = Convert.ToString(myReader["DESIGNDEPART"]);
}
if (!Convert.IsDBNull(myReader["INVESTTOTAL"]))
{
myDetail.INVESTTOTAL = Convert.ToString(myReader["INVESTTOTAL"]);
}
if (!Convert.IsDBNull(myReader["BUILDDATE"]))
{
myDetail.BUILDDATE = Convert.ToDateTime(myReader["BUILDDATE"]);
}
if (!Convert.IsDBNull(myReader["SUPUNIT"]))
{
myDetail.SUPUNIT = Convert.ToString(myReader["SUPUNIT"]);
}
if (!Convert.IsDBNull(myReader["BUILDERUNIT"]))
{
myDetail.BUILDERUNIT = Convert.ToString(myReader["BUILDERUNIT"]);
}
if (!Convert.IsDBNull(myReader["DESIGNERUNIT"]))
{
myDetail.DESIGNERUNIT = Convert.ToString(myReader["DESIGNERUNIT"]);
}
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["CONTACTOR"]))
{
myDetail.CONTACTOR = Convert.ToString(myReader["CONTACTOR"]);
}
if (!Convert.IsDBNull(myReader["CONTACTORTEL"]))
{
myDetail.CONTACTORTEL = Convert.ToString(myReader["CONTACTORTEL"]);
}
if (!Convert.IsDBNull(myReader["CORADDRESS"]))
{
myDetail.CORADDRESS = Convert.ToString(myReader["CORADDRESS"]);
}
if (!Convert.IsDBNull(myReader["EMAIL"]))
{
myDetail.EMAIL = Convert.ToString(myReader["EMAIL"]);
}
if (!Convert.IsDBNull(myReader["FILEDATE"]))
{
myDetail.FILEDATE = Convert.ToDateTime(myReader["FILEDATE"]);
}
if (!Convert.IsDBNull(myReader["FINISHDATE"]))
{
myDetail.FINISHDATE = Convert.ToDateTime(myReader["FINISHDATE"]);
}
if (!Convert.IsDBNull(myReader["CORSELFOPION"]))
{
myDetail.CORSELFOPION = Convert.ToString(myReader["CORSELFOPION"]);
}
if (!Convert.IsDBNull(myReader["APPLYDATE"]))
{
myDetail.APPLYDATE = Convert.ToDateTime(myReader["APPLYDATE"]);
}
if (!Convert.IsDBNull(myReader["CHECKORGOPION"]))
{
myDetail.CHECKOPION = Convert.ToString(myReader["CHECKORGOPION"]);
}
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_FILEACCEPTANCE> GetProject(string CORGUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.PROJECTNAME,A.GUID FROM CAW_BANK_FILEACCEPTANCE 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_FILEACCEPTANCE> ProjectList = new List<Detail_CAW_BANK_FILEACCEPTANCE>();
for (int i = 0; i < dv.Count; i++)
{
Detail_CAW_BANK_FILEACCEPTANCE Project = new Detail_CAW_BANK_FILEACCEPTANCE();
Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString();
Project.GUID = dv[i]["GUID"].ToString();
ProjectList.Add(Project);
}
return ProjectList;
}