///<summary>
/// spd的初始属性设置.(回车跳格,清除split,锁定行高列宽.直接更改文本)
///</summary>
public static void SpdLoad(FpSpread ospd)
{
//回车进行到下一个单元格
InputMap im;
im = ospd.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F1, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F2, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F3, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F4, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Remove(new FarPoint.Win.Spread.Keystroke(Keys.C, Keys.Control));
im.Remove(new FarPoint.Win.Spread.Keystroke(Keys.V, Keys.Control));
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.C, Keys.Control), SpreadActions.Redo);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.V, Keys.Control), SpreadActions.Redo);
im = ospd.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F1, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F2, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F3, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.F4, Keys.None), FarPoint.Win.Spread.SpreadActions.None);
im.Remove(new FarPoint.Win.Spread.Keystroke(Keys.C, Keys.Control));
im.Remove(new FarPoint.Win.Spread.Keystroke(Keys.V, Keys.Control));
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.C, Keys.Control), SpreadActions.Redo);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.V, Keys.Control), SpreadActions.Redo);
// 清除split按钮
ospd.RowSplitBoxPolicy = SplitBoxPolicy.Never;
ospd.ColumnSplitBoxPolicy = SplitBoxPolicy.Never;
//锁定列宽和行高
//ospd.ActiveSheet.Columns[0, ospd.ActiveSheet.ColumnCount - 1].Resizable = false;
//ospd.ActiveSheet.Rows[0, ospd.ActiveSheet.RowCount - 1].Resizable = false;
//单元格进入后文本全选.
ospd.EditModeReplace = true;
}
public FpSpreadHelper(FpSpread fps)
{
_fps = fps;
_sheets = fps.Sheets;
_acsheet = fps.ActiveSheetView;
_editSheet = fps.ActiveSheetView;
}
///<summary>
/// 获取指定单元格内的值 参数:表格对象,单元格行号,单元格列号 返回:值(文本)
///</summary>
public static string SpdGetValue(FpSpread ospd, int orow, int ocol)
{
string str = "";
if (orow >= 0 && ocol >= 0)
{
if (ospd.ActiveSheet.GetValue(orow, ocol) != null)
{
str = ospd.ActiveSheet.GetValue(orow, ocol).ToString().Trim();
}
}
return str;
}
private FpSpread LoadSpread(FpSpread spread, Guid moduleID)
{
try
{
ProgressScreen.Current.ShowSplashScreen();
ProgressScreen.Current.SetStatus = "正在打开模板...";
//增加水印、图章
//spread.Watermark = ModuleHelperClient.GetWatermarkByModuleID(moduleID);
Dictionary <Guid, SheetView> SheetCollection = new Dictionary <Guid, SheetView>();
List <FarPoint.CalcEngine.FunctionInfo> Infos = FunctionItemInfoUtil.getFunctionItemInfos();
JZDocument defaultDocument = ModuleHelperClient.GetDefaultDocument(moduleID);
List <JZFormulaData> CrossSheetLineFormulaInfos = ModuleHelperClient.GetLineFormulaByModuleIndex(moduleID);
foreach (JZSheet sheet in defaultDocument.Sheets)
{
ProgressScreen.Current.SetStatus = "正在初始化表单‘" + sheet.Name + "’";
String sheetXML = ModuleHelperClient.GetSheetXMLByID(sheet.ID);
SheetView SheetView = Serializer.LoadObjectXml(typeof(SheetView), sheetXML, "SheetView") as SheetView;
SheetView.Tag = sheet.ID;
SheetView.SheetName = sheet.Name;
SheetView.Cells[0, 0].Value = "";
SheetView.Protect = true;
FpSpread.Sheets.Add(SheetView);
DataTable dtCellStyle = ModuleHelperClient.GetCellStyleBySheetID(sheet.ID);
for (int i = 0; i < dtCellStyle.Rows.Count; i++)
{
if (dtCellStyle.Rows[i]["CellStyle"] != null)
{
JZCellStyle CurrentCellStyle = Newtonsoft.Json.JsonConvert.DeserializeObject <JZCellStyle>(dtCellStyle.Rows[i]["CellStyle"].ToString());
if (CurrentCellStyle != null)
{
string strCellName = dtCellStyle.Rows[i]["CellName"].ToString();
Cell cell = SheetView.Cells[strCellName];
cell.ForeColor = CurrentCellStyle.ForColor;
cell.BackColor = CurrentCellStyle.BackColor;
cell.Font = new Font(CurrentCellStyle.FamilyName, CurrentCellStyle.FontSize, CurrentCellStyle.FontStyle);
}
}
}
SheetCollection.Add(sheet.ID, SheetView);
foreach (FarPoint.CalcEngine.FunctionInfo Info in Infos)
{
SheetView.AddCustomFunction(Info);
}
}
ProgressScreen.Current.SetStatus = "正在初始化跨表公式...";
spread.LoadFormulas(false);
foreach (JZFormulaData formula in CrossSheetLineFormulaInfos)
{
if (!SheetCollection.ContainsKey(formula.SheetIndex))
{
continue;
}
SheetView Sheet = SheetCollection[formula.SheetIndex];
Cell cell = Sheet.Cells[formula.RowIndex, formula.ColumnIndex];
if (cell != null)
{
try
{
if (formula.Formula.ToUpper().Trim() == "NA()")
{
cell.Formula = "";
}
else
{
cell.Formula = formula.Formula;
}
}
catch
{
}
}
}
spread.LoadFormulas(true);
ProgressScreen.Current.SetStatus = "正在显示资料...";
return(spread);
}
catch (Exception ex)
{
}
finally
{
try
{
//this.RemoveOwnedForm(ProgressScreen.Current);
ProgressScreen.Current.CloseSplashScreen();
}
catch
{
}
}
return(null);
}
///<summary>
/// 设置多行颜色
///<summary>
public static void SpdBackColor(FpSpread ospd, int srow, int scol, int erow, int ecol, Color color)
{
ospd.ActiveSheet.Cells[srow, scol, erow, ecol].BackColor = color;
}
///<summary>
///设定单元格的锁定(多行多列,去掉附颜色) 参数:表格对象,开始行号,开始列号,终止行号,终止列号
///</summary>
public static void SpdLockNoBC(FpSpread ospd, int orow1, int ocol1, int orow2, int ocol2)
{
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].Locked = true;
}
///<summary>
///获得尾行(不空)行号
///</summary>
public static int SpdFullRow(FpSpread ospd)
{
return(ospd.ActiveSheet.NonEmptyRowCount);
}
/////<summary>
///// 清除spd中文本 参数:表格对象
/////</summary>
public static void SpdTextClear(FpSpread ospd)
{
//其中,true是只清除文本,false是清除文本+sheet内部所有的格式.
ospd.ActiveSheet.ClearRange(0, 0, ospd.ActiveSheet.RowCount, ospd.ActiveSheet.ColumnCount, true);
}
public SpreadHelper(ref FpSpread spread, int iSpreadWidth, int iSpreadHeight)
{
_spread = spread;
_spread.Width = iSpreadWidth;
_spread.Height = iSpreadHeight;
}
public KeyboardSpread(FpSpread view)
{
m_owner = view;
}
///<summary>
/// 设定指定单元格内的值 参数:表格对象,值,单元格行号,单元格列号
///</summary>
public static void SpdSetValue(FpSpread ospd, object str, int orow, int ocol)
{
if (orow >= 0 && ocol >= 0)
{
ospd.ActiveSheet.SetValue(orow, ocol, str);
}
}
///<summary>
/// 设定指定单元格内的值 参数:表格对象,值,单元格行号,单元格列号
///</summary>
public static void SpdSetText(FpSpread ospd, string str, int orow, int ocol)
{
if (orow >= 0 && ocol >= 0)
{
ospd.ActiveSheet.SetText(orow, ocol, str);
}
}
///<summary>
/// 设定单元格的焦点 参数:表格对象,单元格行号,单元格列号
///</summary>
public static void SpdSetFocus(FpSpread ospd, int orow, int ocol)
{
if (orow >= 0 && ocol >= 0)
{
ospd.Focus();
//ospd.ActiveSheet.SetActiveCell(orow,ocol,false);
ospd.ActiveSheet.ActiveRowIndex = orow;
ospd.ActiveSheet.ActiveColumnIndex = ocol;
}
}
///<summary>
///设定单元格的锁定(多行多列,去掉附颜色) 参数:表格对象,开始行号,开始列号,终止行号,终止列号
///</summary>
public static void SpdLockNoBC(FpSpread ospd, int orow1, int ocol1, int orow2, int ocol2)
{
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].Locked = true;
}
///<summary>
/// spd 按回车光标横向移动,跳过lock的单元格.在spd的LeaveCell事件中使用.参数:sender,事件
///</summary>
public static void SpdLockCheck(FpSpread ospd, object sender, LeaveCellEventArgs e)
{
if (ospd.ActiveSheet.Cells[e.NewRow, e.NewColumn].Locked == true)
{
System.Windows.Forms.SendKeys.Send("{ENTER}");
}
}
///<summary>
///设定单元格的锁定(区域) 参数:表格对象,行号,列号,是否锁定，背景颜色
///</summary>
public static void SpdLock(FpSpread ospd, int orow1, int ocol1, int orow2, int ocol2, bool blnLocked, Color backColor)
{
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].Locked = blnLocked;
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].BackColor = backColor;
}
public void Execute(IJobExecutionContext context)
{
//获得当前用户名称和单位类型
String Project = context.Scheduler.Context.GetString("project");
String CompanyIndex = context.Scheduler.Context.GetString("currentCompanyIndex");
String CompanyType = context.Scheduler.Context.GetString("currentCompanyType");
Boolean IsAdmin = context.Scheduler.Context.GetBoolean("isAdmin");
if (!string.IsNullOrEmpty(Project) && !string.IsNullOrEmpty(CompanyType) && CompanyType != "@unit_施工单位")
{
List <String> RoomCodes = DepositoryEvaluateDataList.GetTestRoomList(IsAdmin, CompanyIndex, CompanyType);
logger.Info(string.Format("[{0}]获得监管的试验室编码完成，编码列表为：{1}", Project, string.Join(",", RoomCodes.ToArray())));
DataTable Data = DepositoryEvaluateDataList.GetReminderInfos(RoomCodes.ToArray(), DateTime.Now, DateTime.Now);
if (Data != null)
{
logger.Info(string.Format("[{0}]获取不合格报告信息成功，共{1}条信息。", Project, Data.Rows.Count));
if (Data.Rows.Count > 0)
{
logger.Info(string.Format("[{0}]正在初始化不合格报告信息...", Project));
ReportEvaluateDialog Dialog = new ReportEvaluateDialog(Project);
FpSpread FpSpread = Dialog.FpSpread;
SheetView FpSpread_Info = Dialog.FpSpread_Info;
FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
text.Multiline = true;
text.WordWrap = true;
FpSpread_Info.Columns[0, 2].CellType = text;
FpSpread_Info.Rows.Count = Data.Rows.Count;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Height = 25;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].Locked = true;
FpSpread_Info.Columns[0, FpSpread_Info.Columns.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Rows[0, FpSpread_Info.Rows.Count - 1].HorizontalAlignment = CellHorizontalAlignment.Center;
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "DataIndex" || Column.ColumnName == "ModelCode" || Column.ColumnName == "ModelIndex")
{
continue;
}
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Columns[i - 4].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Columns[i - 4].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
FpSpread_Info.Cells[j, i - 4].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].Tag = Row["DataIndex"].ToString() + "," + Row["ModelCode"].ToString() + "," + Row["ModelIndex"].ToString() + "," + Row["ID"].ToString();
}
logger.Info(string.Format("[{0}]正在显示提醒窗口...", Project));
Dialog.ShowDialog();
}
}
else
{
logger.Info(string.Format("[{0}]获取不合格报告信息失败。", Project));
}
logger.Info(string.Format("[{0}]不合格报告提醒完毕", Project));
}
}
protected void SaveDetails()
{
try
{
string degreecode = rs.GetSelectedItemsValue(cbldepartment);
string batchyear = Convert.ToString(ddlbatch.SelectedItem.Text);
string type = Convert.ToString(ddltype.SelectedItem.Text);
string edulevel = Convert.ToString(ddledulevel.SelectedItem.Text);
string Query = " select r.App_No,r.roll_no,r.Reg_No,r.Roll_Admit,r.stud_name,case when sex='0' then 'Male' when sex='1' then 'Female' end sex ,r.degree_code,dt.Dept_Name,c.Course_Name ,r.Batch_Year,r.Current_Semester,c.Course_Id,r.sections,h.HostelMasterFK,hm.HostelName,isnull(a.studhouse,'')studhouse from applyn a, degree d,Department dt,Course C,Registration r left join HT_HostelRegistration h on r.App_No=h.APP_No left join hm_hostelmaster hm on h.HostelMasterFK=hm.HostelMasterPK where a.app_no =r.App_No and d.Degree_Code =r.degree_code and d.Dept_Code =dt.Dept_Code and c.Course_Id =d.Course_Id and isconfirm ='1' and c.type ='" + type + "' and c.Edu_Level ='" + edulevel + "' and a.college_code='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' and r.batch_year in('" + batchyear + "') and d.Degree_Code in ('" + degreecode + "') order by isnull(d.Dept_Priority,10000),r.Reg_No asc";//c.Course_Id,d.Degree_Code,AdmitedDate";
Query += " select HouseName+'$'+CONVERT(varchar(10), HousePK) as HouseName,Gender,GenderPriority from HousingDetails where collegecode='" + Convert.ToString(ddl_collegename.SelectedItem.Value) + "' order by isnull(HousePriority,0),ISNULL(GenderPriority,0),isnull(OrderBy,0) asc";
ds.Clear();
//ds = d2.select_method_wo_parameter(Query, "Text");
Hashtable HouseDetHash = new Hashtable();
HouseDetHash.Add("stream", type);
HouseDetHash.Add("eduLevel", edulevel);
HouseDetHash.Add("collegeCode", Convert.ToString(ddl_collegename.SelectedItem.Value));
HouseDetHash.Add("degreecode", degreecode);
HouseDetHash.Add("batchYear", batchyear);
ds = d2.select_method("AutohouseGeneration", HouseDetHash, "sp");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
rs.Fpreadheaderbindmethod("S.No-50/Student Name-220/Roll No-150/Reg No-150/Admission No-150/Gender-70/Section-70/" + lblDeg.Text + "-100/" + lblBran.Text + "-200/House Name-180", FpSpread, "FALSE");
int MaleCurrentRow = 0;
int FemaleCurrentRow = 0;
List <String> MaleHousingArr = new List <string>();
List <String> FemaleHousingArr = new List <string>();
if (ds.Tables[1].Rows.Count > 0)
{
MaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 0).Select(r => r.Field <String>("HouseName")).ToList <String>();
FemaleHousingArr = ds.Tables[1].AsEnumerable().Where(r => r.Field <byte>("Gender") == 1).Select(r => r.Field <String>("HouseName")).ToList <String>();
}
//if (MaleHousingArr.Contains(""))
// MaleHousingArr.IndexOf("hha");
foreach (DataRow dr in ds.Tables[0].Rows)
{
FpSpread.Sheets[0].Rows.Count++;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread.Sheets[0].Rows.Count);
FpSpread.Sheets[0].Columns[2].Visible = false;
FpSpread.Sheets[0].Columns[3].Visible = false;
FpSpread.Sheets[0].Columns[4].Visible = false;
if (Convert.ToString(Session["Rollflag"]) == "1")
{
FpSpread.Sheets[0].Columns[2].Visible = true;
}
if (Convert.ToString(Session["Regflag"]) == "1")
{
FpSpread.Sheets[0].Columns[3].Visible = true;
}
if (Convert.ToString(Session["Admissionflag"]) == "1")
{
FpSpread.Sheets[0].Columns[4].Visible = true;
}
FarPoint.Web.Spread.TextCellType txt = new FarPoint.Web.Spread.TextCellType();
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Tag = Convert.ToString(dr["App_No"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Note = Convert.ToString(dr["Stud_Type"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Text = Convert.ToString(dr["stud_name"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].CellType = txt;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Text = Convert.ToString(dr["roll_no"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].CellType = txt;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Text = Convert.ToString(dr["Reg_No"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].CellType = txt;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Text = Convert.ToString(dr["Roll_Admit"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Text = Convert.ToString(dr["sex"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Text = Convert.ToString(dr["sections"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Text = Convert.ToString(dr["Course_Name"]);
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Text = Convert.ToString(dr["Dept_Name"]);
string studhouse = Convert.ToString(dr["HouseName"]);
string studhousePK = Convert.ToString(dr["HousePK"]);
string Hostelname = Convert.ToString(dr["HostelName"]);
string HousePk = Convert.ToString(dr["HostelMasterFK"]);
if (GenerateBool)
{
if (string.IsNullOrEmpty(Hostelname) && string.IsNullOrEmpty(HousePk) && string.IsNullOrEmpty(studhouse))
{
#region Auto Allotment
if (Convert.ToString(dr["sex"]).ToUpper() == "MALE")
{
if (MaleHousingArr.Count <= MaleCurrentRow)
{
MaleCurrentRow = 0;
string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
MaleCurrentRow++;
}
else
{
string[] houseDet = Convert.ToString(MaleHousingArr[MaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
MaleCurrentRow++;
}
}
if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE")
{
if (FemaleHousingArr.Count <= FemaleCurrentRow)
{
FemaleCurrentRow = 0;
string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
FemaleCurrentRow++;
}
else
{
string[] houseDet = Convert.ToString(FemaleHousingArr[FemaleCurrentRow]).Split('$');
Hostelname = Convert.ToString(houseDet[0]);
HousePk = Convert.ToString(houseDet[1]);
FemaleCurrentRow++;
}
}
#endregion
}
else
{
if (string.IsNullOrEmpty(Hostelname))
{
Hostelname = Convert.ToString(dr["HouseName"]);
HousePk = Convert.ToString(dr["HousePK"]);
string HouseName = Hostelname + '$' + HousePk;
if (Convert.ToString(dr["sex"]).ToUpper() == "MALE")
{
if (MaleHousingArr.Count <= MaleCurrentRow)
{
if (MaleHousingArr.Contains(HouseName))
{
//MaleCurrentRow = MaleHousingArr.IndexOf(HouseName);
MaleCurrentRow = 0;
}
}
else
{
if (MaleHousingArr.Contains(HouseName))
{
MaleCurrentRow = MaleHousingArr.IndexOf(HouseName);
MaleCurrentRow++;
}
}
}
if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE")
{
if (FemaleHousingArr.Count <= FemaleCurrentRow)
{
if (FemaleHousingArr.Contains(HouseName))
{
//FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName);
FemaleCurrentRow = 0;
}
}
else
{
if (FemaleHousingArr.Contains(HouseName))
{
FemaleCurrentRow = FemaleHousingArr.IndexOf(HouseName);
FemaleCurrentRow++;
}
}
}
//if (Convert.ToString(dr["sex"]).ToUpper() == "MALE")
//{
// if (MaleHousingArr.Count <= MaleCurrentRow)
// {
// MaleCurrentRow = 0;
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// MaleCurrentRow++;
// }
// else
// {
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// MaleCurrentRow++;
// }
//}
//if (Convert.ToString(dr["sex"]).ToUpper() == "FEMALE")
//{
// if (FemaleHousingArr.Count <= FemaleCurrentRow)
// {
// FemaleCurrentRow = 0;
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// FemaleCurrentRow++;
// }
// else
// {
// Hostelname = Convert.ToString(dr["HouseName"]);
// HousePk = Convert.ToString(dr["HousePK"]);
// FemaleCurrentRow++;
// }
//}
}
}
}
else
{
if (string.IsNullOrEmpty(Hostelname))
{
Hostelname = Convert.ToString(dr["HouseName"]);
HousePk = Convert.ToString(dr["HousePK"]);
}
}
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Text = Hostelname;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Tag = HousePk;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Locked = true;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 0].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 1].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 2].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 3].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 4].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 5].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 6].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 7].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].HorizontalAlign = HorizontalAlign.Center;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 8].Font.Name = "Book Antiqua";
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].HorizontalAlign = HorizontalAlign.Left;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Size = FontUnit.Medium;
FpSpread.Sheets[0].Cells[FpSpread.Sheets[0].RowCount - 1, 9].Font.Name = "Book Antiqua";
}
FpSpread.Sheets[0].PageSize = FpSpread.Sheets[0].RowCount;
FpSpread.Visible = true;
FpSpread.SaveChanges();
lbl_error.Visible = false;
rprint.Visible = true;
}
else
{
rprint.Visible = false;
FpSpread.Visible = false;
lbl_error.Visible = true;
lbl_error.Text = "No Record Founds";
}
}
catch (Exception ex)
{
alertpopwindow.Visible = true;
lblalerterr.Text = ex.ToString();
}
}
/////<summary>
///// 清除spd中文本 参数:表格对象
/////</summary>
public static void SpdTextClear(FpSpread ospd)
{
//其中,true是只清除文本,false是清除文本+sheet内部所有的格式.
ospd.ActiveSheet.ClearRange(0, 0, ospd.ActiveSheet.RowCount, ospd.ActiveSheet.ColumnCount, true);
}
public SymbolManager(FpSpread FpSpread, ToolStrip SymbolBar)
{
_FpSpread = FpSpread;
_SymbolBar = SymbolBar;
}
///<summary>
///获得尾行(不空)行号
///</summary>
public static int SpdFullRow(FpSpread ospd)
{
return ospd.ActiveSheet.NonEmptyRowCount;
}
///<summary>
///设定单元格的锁定(区域) 参数:表格对象,行号,列号,是否锁定，背景颜色
///</summary>
public static void SpdLock(FpSpread ospd, int orow1, int ocol1, int orow2, int ocol2, bool blnLocked, Color backColor)
{
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].Locked = blnLocked;
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].BackColor = backColor;
}
//Spread 离开Cells变色
public static void Spread_LeaveCellBColor(FpSpread Spd, LeaveCellEventArgs e, Color bColor, int startColumn, int endColumn)
{
if (e.NewRow < Spd.ActiveSheet.RowCount)
{
//Spd.ActiveSheet.Cells[startRow,startColumn,endRow,endColumn].BackColor = Color.Empty;
if (Spd.ActiveSheet.Cells[e.Row, startColumn, e.Row, endColumn].BackColor != Color.Pink)
Spd.ActiveSheet.Cells[e.Row, startColumn, e.Row, endColumn].BackColor = Color.Empty;
Spd.ActiveSheet.Cells[e.NewRow, startColumn, e.NewRow, endColumn].BackColor = bColor;
}
}
///<summary>
/// 设置多行颜色
///<summary>
public static void SpdBackColor(FpSpread ospd, int srow, int scol, int erow, int ecol, Color color)
{
ospd.ActiveSheet.Cells[srow, scol, erow, ecol].BackColor = color;
}
public DmySpread()
{
FpSpread fpS = new FpSpread();
}
///<summary>
///设定单元格的锁定(多行多列) 参数:表格对象,开始行号,开始列号,终止行号,终止列号
///</summary>
public static void SpdLock(FpSpread ospd, int orow1, int ocol1, int orow2, int ocol2)
{
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].Locked = true;
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].BackColor = Color.LightYellow;
}
///<summary>
///设定单元格的锁定(多行多列) 参数:表格对象,开始行号,开始列号,终止行号,终止列号
///</summary>
public static void SpdLock(FpSpread ospd, int orow1, int ocol1, int orow2, int ocol2)
{
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].Locked = true;
ospd.ActiveSheet.Cells[orow1, ocol1, orow2, ocol2].BackColor = Color.LightYellow;
}
///<summary>
///设定单元格的锁定(单个) 参数:表格对象,行号,列号
///</summary>
public static void SpdLock(FpSpread ospd, int orow, int ocol)
{
ospd.ActiveSheet.Cells[orow, ocol].Locked = true;
ospd.ActiveSheet.LockBackColor = Color.LightYellow;
}
///<summary>
///设定单元格的锁定(单个) 参数:表格对象,行号,列号
///</summary>
public static void SpdLock(FpSpread ospd, int orow, int ocol)
{
ospd.ActiveSheet.Cells[orow, ocol].Locked = true;
ospd.ActiveSheet.LockBackColor = Color.LightYellow;
}
private void BindDayList()
{
ProgressScreen.Current.ShowSplashScreen();
ProgressScreen.Current.SetStatus = "正在获取数据...";
DataTable Data = ModuleHelperClient.GetTemperatureList(testroom, StartDate, EndDate, TemperatureType);
if (Data != null)
{
FpSpread_Info.DataSource = Data;
FpSpread_Info.Columns[2].Width = 100;
FpSpread_Info.Columns[3].Width = 100;
FpSpread_Info.Columns[4].Width = 100;
FpSpread_Info.Columns[5].Width = 100;
FpSpread_Info.Columns[6].Width = 100;
FpSpread_Info.Columns[7].Width = 200;
FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
FpSpread_Info.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Columns[i].Width = 100;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
FpSpread_Info.Cells[j, i].Value = Row[Column.ColumnName];
}
}
double fTemperatureSum = 0;
object TemperatureAvg = null;
object oLastEditTime = null;
DateTime dtLastEditTime = new DateTime();
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
FpSpread_Info.Rows[j].Tag = Row["ID"] == DBNull.Value ? "" : Row["ID"].ToString();
TemperatureAvg = Row["TemperatureAvg"];
oLastEditTime = Row["LastEditTime"];
if (TemperatureAvg != DBNull.Value)
{
fTemperatureSum += Convert.ToDouble(TemperatureAvg);
}
if (oLastEditTime != DBNull.Value)
{
dtLastEditTime = DateTime.Parse(oLastEditTime.ToString());
if (dtLastEditTime.AddDays(2).CompareTo(DateTime.Now.Date) < 0 && !Yqun.Common.ContextCache.ApplicationContext.Current.IsAdministrator)
{
FpSpread_Info.Rows[j].Locked = true;
}
}
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
}
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
if (Data == null)
{
TotalCount.Text = string.Format("本次查询共 {0} 条记录", 0);
}
else
{
TotalCount.Text = string.Format("本次查询共 {0} 条记录", Data.Rows.Count);
}
}
public DmySpread()
{
FpSpread fpS = new FpSpread();
}
