/// <summary> /// Static method to call the DLL which has the /// processing of the image. /// </summary> /// <param name="img">is the object with image information with a resolution of 320x240</param> public static void Execute(MyImg img) { if (cpy == null || cpy.Length != img.Length) { cpy = new byte[img.Length]; } YSobel(img.Length, img.Width, img.Height, img.ImageData, cpy); }
private void OpenImageFile() { if (OFD.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { //bmp = new Bitmap(OFD.FileName); img = new MyImg(new Bitmap(OFD.FileName)); PCT_BOX.Image = img.Image; } catch (Exception) { } } }
void camera_NewFrame(object sender, EventArgs e) { Invalidate(); if (camera != null) { try { camera.Lock(); img = new MyImg(camera.LastFrame); g.DrawImage(img.Image, 0, 0, 320, 240); img = new MyImg(bmp); Booster.Execute(img); PCT_BOX.Image = img.Image; } catch (Exception) { } finally { camera.Unlock(); } } }
/// <summary> /// 实时获取鼠标所在的当前位置,实时显示柱形图的提示 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void MyImg_MouseMove(object sender, EventArgs e) { if (lst_chartItems.Count == 0) { return; } Point mousePoint = MyImg.PointToClient(Control.MousePosition); if (oldMousePoint.Equals(mousePoint)) { return; } var findItem = lst_chartItems.Where(w => (mousePoint.X >= w.X) && (mousePoint.X <= w.X + w.Width) && (mousePoint.Y <= w.Y + w.Height) && (mousePoint.Y >= w.Y)).FirstOrDefault(); if (findItem != null) { toolTip.Show(findItem.ToolTipString, MyImg); } else { toolTip.Hide(MyImg); } oldMousePoint = mousePoint; }
public void logo_set() { FpSpread1.Sheets[0].RowCount = 0; FpSpread1.Sheets[0].Columns[0].Width = 50; FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[1].Width = 150; FpSpread1.Sheets[0].Columns[2].Width = 40; FpSpread1.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[3].Width = 40; FpSpread1.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[4].Width = 30; FpSpread1.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[5].Width = 30; FpSpread1.Sheets[0].Columns[5].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[6].Width = 30; FpSpread1.Sheets[0].Columns[6].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[7].Width = 30; FpSpread1.Sheets[0].Columns[7].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[8].Width = 30; FpSpread1.Sheets[0].Columns[8].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[9].Width = 30; FpSpread1.Sheets[0].Columns[9].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[10].Width = 30; FpSpread1.Sheets[0].Columns[10].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Columns[11].Width = 30; FpSpread1.Sheets[0].Columns[11].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 0, 2, 1); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 0].Text = "Batch"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 1, 2, 1); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 1].Text = "Branch"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 2, 2, 1); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 2].Text = "Semester"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 3, 2, 1); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 3].Text = "Total No.of Student"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 4, 1, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 4].Text = "Registered"; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 4].Text = "No."; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 5].Text = "%"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 6, 1, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 6].Text = "Pass"; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 6].Text = "No."; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 7].Text = "%"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 8, 1, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 8].Text = "Fail"; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 8].Text = "No."; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 9].Text = "%"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 10, 1, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[6, 10].Text = "Absent"; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 10].Text = "No."; FpSpread1.Sheets[0].ColumnHeader.Cells[7, 11].Text = "%"; FpSpread1.Sheets[0].ColumnHeader.Rows[6].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Rows[7].HorizontalAlign = HorizontalAlign.Center; //=header FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo(); style.Font.Size = 10; style.Font.Bold = true; FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style); FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style); MyImg mi = new MyImg(); mi.ImageUrl = "~/images/10BIT001.jpeg"; mi.ImageUrl = "Handler/Handler2.ashx?"; MyImg1 mi2 = new MyImg1(); mi2.ImageUrl = "~/images/10BIT001.jpeg"; mi2.ImageUrl = "Handler/Handler5.ashx?"; string str = "select isnull(collname, ' ') as collname,isnull(category,'') as category,isnull(affliatedby,'') as affliated,isnull(address1, ' ') as address1,isnull(address2,' ') as address2,isnull(address3, ' ') as address3,isnull(district, ' ') as district,isnull(pincode,' ') as pincode from collinfo where college_code='" + Session["collegecode"].ToString() + "'"; con1.Close(); con1.Open(); SqlCommand comm = new SqlCommand(str, con1); SqlDataReader drr = comm.ExecuteReader(); drr.Read(); string coll_name = Convert.ToString(drr["collname"]); string coll_address1 = Convert.ToString(drr["address1"]); string coll_address2 = Convert.ToString(drr["address2"]); string coll_address3 = Convert.ToString(drr["address3"]); string district = Convert.ToString(drr["district"]); string pin_code = Convert.ToString(drr["pincode"]); string catgory = drr["category"].ToString(); catgory = "(An " + catgory + " Institution" + " " + "-" + ""; string affliatedby = drr["affliated"].ToString(); string affliatedbynew = Regex.Replace(affliatedby, ",", " "); string affiliated = catgory + " " + "Affiliated to" + " " + affliatedbynew + ")"; string address = coll_address1 + "," + " " + coll_address2 + "," + " " + district + "-" + " " + pin_code + "."; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 0, 5, 1); FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Text = coll_name; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3); FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Text = address; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3); FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Text = affiliated; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3); FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Text = "Result Analysis"; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3); FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(5, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3); FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].ForeColor = Color.FromArgb(64, 64, 255); FpSpread1.Sheets[0].ColumnHeader.Rows[0].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeader.Rows[0].Border.BorderColorRight = Color.White; // FpSpread1.Sheets[0].ColumnHeader.Cells[1, 16].Border.BorderColorBottom = Color.Black; FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].Border.BorderColorBottom = Color.Black; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Border.BorderColorBottom = Color.Black; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Border.BorderColorRight = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorRight = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorRight = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorRight = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorRight = Color.White; FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].Border.BorderColorRight = Color.White; FpSpread1.Sheets[0].ColumnHeader.Rows[6].BackColor = Color.FromArgb(214, 235, 255); FpSpread1.Sheets[0].ColumnHeader.Rows[6].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Rows[6].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Rows[7].BackColor = Color.FromArgb(214, 235, 255); FpSpread1.Sheets[0].ColumnHeader.Rows[7].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Rows[7].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].CellType = mi; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, FpSpread1.Sheets[0].ColumnCount - 2, 5, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 2].CellType = mi2; }
public void logo_settings() { FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo(); style.Font.Size = 10; style.Font.Bold = true; FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style); FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style); FpSpread1.Sheets[0].AllowTableCorner = true; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua"; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true; FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; FpSpread1.ActiveSheetView.DefaultStyle.Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.RowCount = 5; FpSpread1.Sheets[0].ColumnCount = 4; MyImg mi = new MyImg(); mi.ImageUrl = "~/images/10BIT001.jpeg"; mi.ImageUrl = "Handler/Handler2.ashx?"; MyImg mi2 = new MyImg(); mi2.ImageUrl = "~/images/10BIT001.jpeg"; mi2.ImageUrl = "Handler/Handler5.ashx?"; con_header.Close(); con_header.Open(); query_header = "select collname,category,affliatedby,address1,address2,address3,phoneno,faxno,email,website from collinfo where college_code=" + Session["collegecode"] + ""; SqlCommand com_header = new SqlCommand(query_header, con_header); SqlDataReader sdr_header; sdr_header = com_header.ExecuteReader(); while (sdr_header.Read()) { FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 5, 1); FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 1, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = sdr_header["collname"].ToString(); FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = 10; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, 2); string cc = FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Text = sdr_header["category"].ToString() + ", Affliated to" + sdr_header["affliatedby"].ToString(); FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Font.Size = 10; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Text = sdr_header["address1"].ToString() + "-" + sdr_header["address2"].ToString() + "-" + sdr_header["address1"].ToString(); FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Font.Size = 10; FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, 2); FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Text = "Phone : " + sdr_header["phoneno"].ToString() + " Fax : " + sdr_header["faxno"].ToString(); FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Font.Size = 10; FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, 2);//5th row span FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Text = "E-Mail : " + sdr_header["email"].ToString() + " Web Site : " + sdr_header["website"].ToString(); FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Font.Size = 10; FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 5, 1); FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].CellType = mi2; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; } }
protected void Button1_Click(object sender, EventArgs e) { individualsubstud.Sheets[0].ColumnCount = 6; individualsubstud.Sheets[0].Columns[0].Locked = true; individualsubstud.Sheets[0].Columns[1].Locked = true; individualsubstud.Sheets[0].Columns[2].Locked = true; individualsubstud.Sheets[0].Columns[3].Locked = true; individualsubstud.Sheets[0].Columns[4].Locked = true; individualsubstud.Sheets[0].Columns[5].Locked = true; individualsubstud.Visible = false; individualsubstud.Sheets[0].SheetCorner.RowCount = 11; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(6, 1, 1, 5); individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(7, 1, 1, 5); individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(8, 1, 1, 5); individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(9, 1, 1, 5); individualsubstud.Sheets[0].Columns[0].Width = 70; individualsubstud.Sheets[0].Columns[1].Width = 100; individualsubstud.Sheets[0].Columns[2].Width = 150; individualsubstud.Sheets[0].Columns[3].Width = 100; individualsubstud.Sheets[0].Columns[4].Width = 170; individualsubstud.Sheets[0].Columns[5].Width = 70; individualsubstud.Sheets[0].AutoPostBack = true; //if (Session["Rollflag"] == "0") //{ // individualsubstud.Width = 700; // individualsubstud.Sheets[0].Columns[1].Visible = false; //} if (Session["Regflag"] == "0") { individualsubstud.Width = 510; individualsubstud.Sheets[0].Columns[2].Visible = false; } if (Session["Studflag"].ToString() == "0") { individualsubstud.Width = 570; individualsubstud.Sheets[0].Columns[3].Visible = false; } if (Session["Regflag"].ToString() == "0" && Session["Rollflag"].ToString() == "0" && Session["Studflag"].ToString() == "0") { individualsubstud.Width = 510; individualsubstud.Sheets[0].Columns[1].Width = 200; individualsubstud.Sheets[0].Columns[1].Visible = true; } FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo(); style.Font.Size = 10; style.Font.Bold = true; individualsubstud.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style); individualsubstud.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style); individualsubstud.Sheets[0].AllowTableCorner = true; individualsubstud.Sheets[0].SheetCorner.Cells[0, 0].Text = " "; MyImg mi = new MyImg(); mi.ImageUrl = "~/images/10BIT001.jpeg"; mi.ImageUrl = "Handler/Handler2.ashx?"; MyImg mi1 = new MyImg(); mi1.ImageUrl = "~/images/10BIT001.jpeg"; mi1.ImageUrl = "Handler/Handler5.ashx?"; string str = "select isnull(collname, ' ') as collname,isnull(address1, ' ') as address1,isnull(address2,' ') as address2,isnull(address3, ' ') as address3,isnull(pincode,' ') as pincode from collinfo where college_code='" + Session["collegecode"].ToString() + "'"; con1.Close(); con1.Open(); SqlCommand comm = new SqlCommand(str, con1); SqlDataReader drr = comm.ExecuteReader(); drr.Read(); string coll_name = Convert.ToString(drr["collname"]); string coll_address1 = Convert.ToString(drr["address1"]); string coll_address2 = Convert.ToString(drr["address2"]); string coll_address3 = Convert.ToString(drr["address3"]); string pin_code = Convert.ToString(drr["pincode"]); individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 6, 1); individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, individualsubstud.Sheets[0].ColumnCount - 1, 1, 6); individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].Text = coll_name; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2); individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColorBottom = Color.White; individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].Text = coll_address1; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2); individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White; individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].Text = coll_address2; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2); individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White; individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].Text = coll_address3 + "-" + " " + pin_code + "."; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2); individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White; //individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].Text = "Salary Summary For-" + monname + "--" + cblbatchyear.Text + ""; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2); individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(5, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2); individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].ForeColor = Color.FromArgb(64, 64, 255); individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorBottom = Color.White; individualsubstud.Sheets[0].ColumnHeader.Rows[10].BackColor = Color.FromArgb(214, 235, 255); individualsubstud.Sheets[0].ColumnHeader.Rows[10].Font.Bold = true; individualsubstud.Sheets[0].ColumnHeader.Rows[10].Font.Size = FontUnit.Medium; individualsubstud.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, individualsubstud.Sheets[0].ColumnCount - 1, 6, 1); individualsubstud.Sheets[0].ColumnHeader.Cells[0, individualsubstud.Sheets[0].ColumnCount - 1].CellType = mi1; individualsubstud.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium; individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium; individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua"; individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true; individualsubstud.Sheets[0].RowCount = 0; individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(10, 4, 1, 2); individualsubstud.Sheets[0].ColumnHeader.Rows[10].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].ColumnHeader.Cells[10, 0].Text = "S.No"; individualsubstud.Sheets[0].ColumnHeader.Cells[10, 1].Text = "Roll No"; individualsubstud.Sheets[0].ColumnHeader.Cells[10, 2].Text = "Reg No"; individualsubstud.Sheets[0].ColumnHeader.Cells[10, 3].Text = "Student Type"; individualsubstud.Sheets[0].ColumnHeader.Cells[10, 4].Text = "Student Name"; individualsubstud.Sheets[0].RowHeader.Visible = false; HAllSpread.SaveChanges(); int sno = 0; int count = 0; for (int res = 1; res <= Convert.ToInt32(HAllSpread.Sheets[0].RowCount) - 1; res++) { int isval = 0; string s = HAllSpread.Sheets[0].Cells[res, 9].Text; isval = Convert.ToInt32(HAllSpread.Sheets[0].Cells[res, 9].Value); if (isval == 1) { string year1 = ""; string semester1 = ""; string degreecourse1 = ""; string subject1 = ""; string subject_no = HAllSpread.Sheets[0].Cells[res, 5].Note; int semester = Convert.ToInt32(HAllSpread.Sheets[0].Cells[res, 4].Text); //individualsubstud.Sheets[0].AutoPostBack = true; individualsubstud.CommandBar.Visible = true; //string activerow = ""; //string activecol = ""; //activerow = HAllSpread.ActiveSheetView.ActiveRow.ToString(); //activecol = HAllSpread.ActiveSheetView.ActiveColumn.ToString(); //string subject_no = HAllSpread.Sheets[0].Cells[Convert.ToInt32(activerow), 5].Note; //int semester = Convert.ToInt32(HAllSpread.Sheets[0].Cells[Convert.ToInt32(activerow), 4].Text); string year = HAllSpread.Sheets[0].Cells[res, 1].Text; string degree = HAllSpread.Sheets[0].Cells[res, 2].Text; string course = HAllSpread.Sheets[0].Cells[res, 3].Text; string courseacro = HAllSpread.Sheets[0].Cells[res, 3].Note; string subject = HAllSpread.Sheets[0].Cells[res, 5].Text; string arreartag = Convert.ToString(HAllSpread.Sheets[0].Cells[res, 5].Tag); string degreecourse = degree + "-" + courseacro; individualsubstud.Sheets[0].ColumnHeader.Cells[6, 0].Text = "Year"; individualsubstud.Sheets[0].ColumnHeader.Cells[7, 0].Text = "Branch"; individualsubstud.Sheets[0].ColumnHeader.Cells[8, 0].Text = "Semester"; individualsubstud.Sheets[0].ColumnHeader.Cells[9, 0].Text = "Subject"; if (hashyear.Contains(year)) { } else { hashyear.Add(year, count); count++; } foreach (DictionaryEntry parameter in hashyear) { string selectyear = Convert.ToString(parameter.Key); if (year1 == "") { year1 = selectyear; } else if (year1 != "") { if (year1 != year) { year1 = year1 + "," + " " + selectyear; } } } if (hash.Contains(degreecourse)) { } else { hash.Add(degreecourse, count); count++; } foreach (DictionaryEntry parameter in hash) { string selectdegreecourse = Convert.ToString(parameter.Key); if (degreecourse1 == "") { degreecourse1 = selectdegreecourse; } else if (degreecourse1 != "") { if (degreecourse1 != degreecourse) { degreecourse1 = degreecourse1 + "," + " " + selectdegreecourse; } } } if (hashsubject.Contains(subject)) { } else { hashsubject.Add(subject, count); count++; } foreach (DictionaryEntry parameter in hashsubject) { string selectsubject = Convert.ToString(parameter.Key); if (subject1 == "") { subject1 = selectsubject; } else if (subject1 != "") { if (subject1 != subject) { subject1 = subject1 + "," + " " + selectsubject; } } } if (hashsemester.Contains(semester)) { } else { hashsemester.Add(semester, count); count++; } foreach (DictionaryEntry parameter in hashsemester) { string selectsemester = Convert.ToString(parameter.Key); if (semester1 == "") { semester1 = Convert.ToString(selectsemester); } else if (semester1 != "") { if (semester1 != Convert.ToString(semester)) { semester1 = semester1 + "," + Convert.ToString(selectsemester); } } } individualsubstud.Sheets[0].ColumnHeader.Cells[6, 1].Text = ":" + " " + year1; individualsubstud.Sheets[0].ColumnHeader.Cells[7, 1].Text = ":" + " " + degreecourse1; individualsubstud.Sheets[0].ColumnHeader.Cells[8, 1].Text = ":" + " " + semester1; individualsubstud.Sheets[0].ColumnHeader.Cells[9, 1].Text = ":" + " " + subject1; individualsubstud.Sheets[0].ColumnHeader.Rows[6].Border.BorderColorBottom = Color.White; individualsubstud.Sheets[0].ColumnHeader.Rows[7].Border.BorderColorBottom = Color.White; individualsubstud.Sheets[0].ColumnHeader.Rows[8].Border.BorderColorBottom = Color.White; individualsubstud.Sheets[0].ColumnHeader.Rows[6].Border.BorderColorRight = Color.White; individualsubstud.Sheets[0].ColumnHeader.Rows[7].Border.BorderColorRight = Color.White; individualsubstud.Sheets[0].ColumnHeader.Rows[8].Border.BorderColorRight = Color.White; individualsubstud.Sheets[0].ColumnHeader.Rows[9].Border.BorderColorRight = Color.White; string type = "0"; int i = 0; int j = 0; // string type1 = ""; if (Session["Stud_Type"] != "0" && Session["Stud_Type1"] != "0") { j = 2; } if (Session["Stud_Type"] != "1" && Session["Stud_Type1"] != "1") { j = 2; } if (j != 2) { if (Session["Stud_Type1"] != "Hostler") { i = 1; type = Session["Stud_Type1"].ToString(); } else if (Session["Stud_Type"] != "Day Scholar") { i = 1; type = Session["Stud_Type"].ToString(); } } if (arreartag == "0") { SqlCommand studentscmd = new SqlCommand("procindividualsubstud", con); studentscmd.CommandType = CommandType.StoredProcedure; studentscmd.Parameters.AddWithValue("@subject_no", subject_no); studentscmd.Parameters.AddWithValue("@semester", semester); if (type != "") { studentscmd.Parameters.AddWithValue("@stud_type", type); } studentscmd.Parameters.AddWithValue("@i", i); //studentscmd.Parameters.AddWithValue("@stud_type1", type1); SqlDataAdapter studentsda = new SqlDataAdapter(studentscmd); DataSet studentsds = new DataSet(); studentsda.Fill(studentsds); if (studentsds.Tables[0].Rows.Count > 0) { individualsubstud.Visible = true; for (int dd = 0; dd < studentsds.Tables[0].Rows.Count; dd++) { sno++; individualsubstud.Sheets[0].RowCount = individualsubstud.Sheets[0].RowCount + 1; individualsubstud.Sheets[0].SpanModel.Add(individualsubstud.Sheets[0].RowCount - 1, 4, 1, 2); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].Text = sno + ""; individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].Text = studentsds.Tables[0].Rows[dd]["roll_no"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].Text = studentsds.Tables[0].Rows[dd]["reg_no"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center; individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 3].Text = studentsds.Tables[0].Rows[dd]["Stud_type"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 4].Text = studentsds.Tables[0].Rows[dd]["Stud_name"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; } } } if (arreartag == "1") { SqlCommand studentscmdforarrear = new SqlCommand("procindividualsubstudforarrear", con); studentscmdforarrear.CommandType = CommandType.StoredProcedure; studentscmdforarrear.Parameters.AddWithValue("@subject_no", subject_no); if (type != "") { studentscmdforarrear.Parameters.AddWithValue("@stud_type", type); } studentscmdforarrear.Parameters.AddWithValue("@i", i); SqlDataAdapter studentsdaforarrear = new SqlDataAdapter(studentscmdforarrear); DataSet studentsdsforarrear = new DataSet(); studentsdaforarrear.Fill(studentsdsforarrear); if (studentsdsforarrear.Tables[0].Rows.Count > 0) { individualsubstud.Visible = true; for (int dd2 = 0; dd2 < studentsdsforarrear.Tables[0].Rows.Count; dd2++) { sno++; individualsubstud.Sheets[0].RowCount = individualsubstud.Sheets[0].RowCount + 1; individualsubstud.Sheets[0].SpanModel.Add(individualsubstud.Sheets[0].RowCount - 1, 4, 1, 2); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].Text = sno + ""; individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].Text = studentsdsforarrear.Tables[0].Rows[dd2]["roll_no"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].Text = studentsdsforarrear.Tables[0].Rows[dd2]["reg_no"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 3].Text = studentsdsforarrear.Tables[0].Rows[dd2]["Stud_type"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 4].Text = studentsdsforarrear.Tables[0].Rows[dd2]["Stud_name"].ToString(); individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; } } } int totalrows = individualsubstud.Sheets[0].RowCount; individualsubstud.Sheets[0].PageSize = totalrows * 100; individualsubstud.Height = totalrows + 50 * 15; } } }
public void logo_settings() { string query_header = ""; FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo(); style.Font.Size = 10; style.Font.Bold = true; sprdviewrcrd.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style); sprdviewrcrd.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style); sprdviewrcrd.Sheets[0].AllowTableCorner = true; sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua"; sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium; sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true; sprdviewrcrd.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua"; sprdviewrcrd.ActiveSheetView.DefaultStyle.Font.Size = FontUnit.Medium; sprdviewrcrd.Sheets[0].ColumnHeader.Rows[5].BackColor = Color.AliceBlue; col_cnt = Convert.ToInt32(Session["col_cnt"].ToString()); sprdviewrcrd.Sheets[0].ColumnCount = 4 + col_cnt; MyImg mi = new MyImg(); mi.ImageUrl = "~/images/10BIT001.jpeg"; mi.ImageUrl = "Handler/Handler2.ashx?"; MyImg mi2 = new MyImg(); mi2.ImageUrl = "~/images/10BIT001.jpeg"; mi2.ImageUrl = "Handler/Handler5.ashx?"; con_header.Close(); con_header.Open(); query_header = "select collname,address3,pincode from collinfo where college_code=" + Session["collegecode"] + ""; SqlCommand com_header = new SqlCommand(query_header, con_header); SqlDataReader sdr_header; sdr_header = com_header.ExecuteReader(); while (sdr_header.Read()) { sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 5, 2); sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi; sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3); sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].Text = sdr_header.GetString(0) + "."; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].Border.BorderColorBottom = Color.White; sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(1, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3); sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].Text = sdr_header.GetString(1) + " - " + sdr_header.GetString(2) + "."; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].HorizontalAlign = HorizontalAlign.Center; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].Border.BorderColorBottom = Color.White; sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(2, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3); sprdviewrcrd.Sheets[0].ColumnHeader.Cells[2, 2].Text = ""; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[2, 2].Border.BorderColorBottom = Color.White; sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(3, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3); sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].Text = "Students Arrear Status"; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].HorizontalAlign = HorizontalAlign.Center; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].Border.BorderColorBottom = Color.White; sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(4, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);//5th row span sprdviewrcrd.Sheets[0].ColumnHeader.Cells[4, 2].Text = ""; sprdviewrcrd.Sheets[0].ColumnHeader.Cells[4, 2].ForeColor = Color.White; sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, sprdviewrcrd.Sheets[0].ColumnCount - 1, 5, 1); sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, sprdviewrcrd.Sheets[0].ColumnCount - 1].CellType = mi2; } }