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); }