public static DataTable findPhotosByProjSNo(string sno)
{
string sql = @"select Top 5 FileName, PhotoTime, ReferenceSerialNo, Person, Remark from PhotoInfo where ReferenceSerialNo = '" + sno + @"' order by PhotoTime desc;";
DataTable dt = null;
if (isConnected)
{
dt = CServerWrapper.execSqlQuery(sql);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
dr["FileName"] = "/ProjectPhoto/" + dr["ReferenceSerialNo"].ToString().Substring(0, 3) + "/" + Convert.ToDateTime(dr["PhotoTime"].ToString()).Year + "/" + dr["FileName"].ToString().Replace("#", "%23"); // HttpUtility.UrlEncode(dr["FileName"].ToString());
}
}
}
return(dt);
}
private void button1_Click(object sender, EventArgs e)
{
///////////////测试找中值函数//////////////
//double[,] aa = new double[4, 4];
//for (int i = 0; i < 4; i++)
//{
// for (int j = 0; j < 4; j++)
// {
// aa[i, j] = i * 4 + j;
// }
//}
//Console.WriteLine(ReturnMedian(aa).ToString());
/////////////////////////////////////////////
CServerWrapper.ConnectToServer();
// string sqlstr = @"select FirmName, FirmTypeID,from (select * from FirmInfo)a, (select FirmTypeID,FirmTypeCategoryName from FirmTypeInfo)b where a.FirmTypeID=b.FirmTypeID and( FirmTypeCategoryName='单位' or FirmTypeCategoryName='分支机构');"; and Longitude > 10 AND Latitude > 10
string sqlstr = @"select FirmName ,a.FirmTypeID, CategoryCode, SerialNo, UpdateTime, Longitude, Latitude from (select * from FirmInfo)a, (select FirmTypeID,FirmTypeCategoryName from FirmTypeInfo)b where a.FirmTypeID=b.FirmTypeID and( FirmTypeCategoryName='单位' or FirmTypeCategoryName='分支机构') and Longitude > 10 AND Latitude > 10 order by a.FirmTypeID asc ;";
// + " where a.FirmTypeID=b.FirmTypeID and (FirmTypeCategoryName='单位' or FirmTypeCategoryName='分支机构') and Longitude > 10 AND latitude > 10 ;";
dataGridView1.DataSource = CServerWrapper.execSqlQuery(sqlstr);
}
