/// <summary>
/// 获取已经通过审核的初步设计中的项目名称和Guid，用于填充施工图设计的下拉框 Type＝“0”
/// 获取已经通过施工图中的项目名称和Guid，用于填充开工申请中的下拉框 Type＝“1”
/// </summary>
/// <param name="CORGUID"></param>
/// <returns></returns>
public List<Detail_CAW_BANK_PREDESIGN> GetProject(string CORGUID,string Type)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT PROJECTNAME,DESIGNGUID FROM CAW_BANK_PREDESIGN A,CAW_DATESTATUS B WHERE A.DTYPE='" + Type.ToString() + "' AND A.DESIGNGUID=B.KEYGUID AND B.DATASTATUS='2' AND A.CORGUID='" + CORGUID + "'";
DbCommand cmd = db.GetSqlStringCommand(strSql);
DataView dv = db.ExecuteDataView(cmd);
List<Detail_CAW_BANK_PREDESIGN> ProjectList = new List<Detail_CAW_BANK_PREDESIGN>();
for (int i = 0; i < dv.Count; i++)
{
Detail_CAW_BANK_PREDESIGN Project = new Detail_CAW_BANK_PREDESIGN();
Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString();
Project.DESIGNGUID = dv[i]["DESIGNGUID"].ToString();
ProjectList.Add(Project);
}
return ProjectList;
}
/// <summary>
/// 根据岸线申请主键，获取该项目的基本信息（地点、主要设计单位、设计单位资质等级），用于填充相应的控件
/// </summary>
/// <param name="ApplyGuid"></param>
/// <returns></returns>
public Detail_CAW_BANK_PREDESIGN GetProjectInfo(string DESIGNGUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT PROJECTNAME,DESIGNADDRESS,DESIGNAGENT,AGENTGRADE FROM CAW_BANK_PREDESIGN WHERE DESIGNGUID='" + DESIGNGUID + "'";
DbCommand cmd = db.GetSqlStringCommand(strSql);
DataView dv = db.ExecuteDataView(cmd);
Detail_CAW_BANK_PREDESIGN CBP = new Detail_CAW_BANK_PREDESIGN();
if (dv.Count > 0)
{
CBP.AGENTGRADE = dv[0]["AGENTGRADE"].ToString();
CBP.DESIGNADDRESS = dv[0]["DESIGNADDRESS"].ToString();
CBP.PROJECTNAME = dv[0]["PROJECTNAME"].ToString();
CBP.DESIGNAGENT = dv[0]["DESIGNAGENT"].ToString();
}
return CBP;
}
/// <summary>
///
/// 编写日期：2010-3-19
/// 编写人：GWF
/// </summary>
/// <param name="DESIGNGUID"></param>
public Detail_CAW_BANK_PREDESIGN Select(string DESIGNGUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_PREDESIGN A,CAW_DATESTATUS B WHERE A.DESIGNGUID=B.KEYGUID AND A.DESIGNGUID='" + DESIGNGUID + "'";
DbCommand cmd = db.GetSqlStringCommand(strSql);
DataView dv = db.ExecuteDataView(cmd);
Detail_CAW_BANK_PREDESIGN CBP = new Detail_CAW_BANK_PREDESIGN();
if (dv.Count > 0)
{
CBP.AGENTGRADE = dv[0]["AGENTGRADE"].ToString();
CBP.CORGUID = dv[0]["CORGUID"].ToString();
CBP.CORPADDRESS = dv[0]["CORPADDRESS"].ToString();
CBP.CORPNAME = dv[0]["CORPNAME"].ToString();
CBP.DECDATE = DateTime.MinValue;
try { CBP.DECDATE = Convert.ToDateTime(dv[0]["DECDATE"]); }
catch { }
CBP.DECPERNAME = dv[0]["DECPERNAME"].ToString();
CBP.DESIGNADDRESS = dv[0]["DESIGNADDRESS"].ToString();
CBP.DESIGNAGENT = dv[0]["DESIGNAGENT"].ToString();
CBP.DESIGNGUID = dv[0]["DESIGNGUID"].ToString();
CBP.DESIGNREMARK = dv[0]["DESIGNREMARK"].ToString();
CBP.ITEMNAME = dv[0]["ITEMNAME"].ToString();
CBP.LAWMAN = dv[0]["LAWMAN"].ToString();
CBP.LAWMANTEL = dv[0]["LAWMANTEL"].ToString();
CBP.LINKNAME = dv[0]["LINKNAME"].ToString();
CBP.LINKPOSTCODE = dv[0]["LINKPOSTCODE"].ToString();
CBP.LINKTEL = dv[0]["LINKTEL"].ToString();
CBP.LMPOSTCODE = dv[0]["LMPOSTCODE"].ToString();
CBP.PROJECTNAME = dv[0]["PROJECTNAME"].ToString();
CBP.ApplyGuid = dv[0]["ApplyGuid"].ToString();
CBP.DATASTATUS = dv[0]["DATASTATUS"].ToString();
CBP.DATASTATUS_NAME = dv[0]["DATASTATUS_NAME"].ToString();
CBP.CHECKOPION = dv[0]["CHECKOPION"].ToString();
}
return CBP;
}
