/// <summary>
/// 获取某条数据的明细
/// </summary>
/// <param name="Guid"></param>
/// <returns></returns>
public Detail_CAW_BANK_STARTWORK GetDetail(string Guid)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_STARTWORK A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + Guid + "' ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
Detail_CAW_BANK_STARTWORK myDetail = new Detail_CAW_BANK_STARTWORK();
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["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["SETITEMORG"]))
{
myDetail.SETITEMORG = Convert.ToString(myReader["SETITEMORG"]);
}
if (!Convert.IsDBNull(myReader["SETITEMNO"]))
{
myDetail.SETITEMNO = Convert.ToString(myReader["SETITEMNO"]);
}
if (!Convert.IsDBNull(myReader["SETITEMDATE"]))
{
myDetail.SETITEMDATE = Convert.ToDateTime(myReader["SETITEMDATE"]);
}
if (!Convert.IsDBNull(myReader["DESIGNDEPART"]))
{
myDetail.DESIGNDEPART = Convert.ToString(myReader["DESIGNDEPART"]);
}
if (!Convert.IsDBNull(myReader["DESIGNNO"]))
{
myDetail.DESIGNNO = Convert.ToString(myReader["DESIGNNO"]);
}
if (!Convert.IsDBNull(myReader["DESIGNDATE"]))
{
myDetail.DESIGNDATE = Convert.ToDateTime(myReader["DESIGNDATE"]);
}
if (!Convert.IsDBNull(myReader["DRAWINGORG"]))
{
myDetail.DRAWINGORG = Convert.ToString(myReader["DRAWINGORG"]);
}
if (!Convert.IsDBNull(myReader["DRAWINGNO"]))
{
myDetail.DRAWINGNO = Convert.ToString(myReader["DRAWINGNO"]);
}
if (!Convert.IsDBNull(myReader["DRAWINGDATE"]))
{
myDetail.DRAWINGDATE = Convert.ToDateTime(myReader["DRAWINGDATE"]);
}
if (!Convert.IsDBNull(myReader["INVESTTOTAL"]))
{
myDetail.INVESTTOTAL = Convert.ToString(myReader["INVESTTOTAL"]);
}
if (!Convert.IsDBNull(myReader["INVESTFULFIL"]))
{
myDetail.INVESTFULFIL = Convert.ToString(myReader["INVESTFULFIL"]);
}
if (!Convert.IsDBNull(myReader["LANDSTATUS"]))
{
myDetail.LANDSTATUS = Convert.ToString(myReader["LANDSTATUS"]);
}
if (!Convert.IsDBNull(myReader["CORPOPINION"]))
{
myDetail.CORPOPINION = Convert.ToString(myReader["CORPOPINION"]);
}
if (!Convert.IsDBNull(myReader["APPLICANT"]))
{
myDetail.APPLICANT = Convert.ToString(myReader["APPLICANT"]);
}
if (!Convert.IsDBNull(myReader["DECDATE"]))
{
myDetail.DECDATE = Convert.ToDateTime(myReader["DECDATE"]);
}
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_STARTWORK> GetProject(string CORGUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.PROJECTNAME,A.GUID FROM CAW_BANK_STARTWORK 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_STARTWORK> ProjectList = new List<Detail_CAW_BANK_STARTWORK>();
for (int i = 0; i < dv.Count; i++)
{
Detail_CAW_BANK_STARTWORK Project = new Detail_CAW_BANK_STARTWORK();
Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString();
Project.GUID = dv[i]["GUID"].ToString();
ProjectList.Add(Project);
}
return ProjectList;
}
