public int InsertCardInfo(CardInfo card)
{
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
return cardInfoDA.InsertCardInfo(card);
}
}
public int DeleteTeaCardInfo(string cardNumber)
{
int rowAffected = 0;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
rowAffected = cardInfoDA.DeleteTeaCardInfo(cardNumber);
}
return rowAffected;
}
public int UpdateTeaCardState(string cardNumber)
{
int rowAffected = 0;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
rowAffected = cardInfoDA.UpdateTeaCardState(cardNumber);
}
return rowAffected;
}
public int InsertTeaCardInfo(CardInfo card)
{
int rowAffected = 0;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
rowAffected = cardInfoDA.InsertTeaCardInfo(card);
}
return rowAffected;
}
public void ImportCardExcelFile(string id,string name,string grade,
string atClass,bool isStu,string savePath)
{
if(grade.Equals("全部"))
{
grade = string.Empty;
}
if(atClass.Equals("全部"))
{
atClass = string.Empty;
}
DataSet cardInfo;
object[,] objData;
string excelTempFilePath = AppDomain.CurrentDomain.BaseDirectory;
Excel.Application m_objExcel = null;
Excel.Workbooks m_objBooks = null;
Excel._Workbook m_objBook = null;
Excel.Sheets m_objSheets = null;
Excel._Worksheet m_objSheet = null;
Excel.Range m_objRange = null;
Excel.Font m_objFont = null;
System.Reflection.Missing m_objOpt = System.Reflection.Missing.Value;
try
{
if(isStu)
{
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
cardInfo = cardInfoDA.GetStuCardNumberForExcel(id,name,grade,atClass);
}
if(cardInfo.Tables[0].Rows.Count>0)
{
objData = new Object[cardInfo.Tables[0].Rows.Count,7];
for(int i=0;i<cardInfo.Tables[0].Rows.Count;i++)
{
objData[i,0] = cardInfo.Tables[0].Rows[i][0].ToString();
objData[i,1] = cardInfo.Tables[0].Rows[i][1].ToString();
objData[i,2] = cardInfo.Tables[0].Rows[i][2].ToString();
objData[i,3] = cardInfo.Tables[0].Rows[i][3].ToString();
objData[i,4] = cardInfo.Tables[0].Rows[i][4].ToString();
objData[i,5] = cardInfo.Tables[0].Rows[i][5].ToString();
objData[i,6] = cardInfo.Tables[0].Rows[i][6].ToString();
}
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)m_objBooks.Open(excelTempFilePath+@"report\StudentCardInfo.xls",
m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,
m_objOpt,m_objOpt,m_objOpt);
m_objSheets = (Excel.Sheets)m_objBook.Sheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
m_objRange = m_objSheet.get_Range("A3",m_objOpt);
m_objRange = m_objRange.get_Resize(cardInfo.Tables[0].Rows.Count,7);
m_objRange.Value = objData;
m_objRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
m_objRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
m_objRange.WrapText = true;
m_objRange.Borders.LineStyle = System.Windows.Forms.BorderStyle.FixedSingle;
m_objFont = m_objRange.Font;
m_objFont.Size = 9;
m_objBook.SaveAs(savePath, m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objFont);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objRange);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheets);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBooks);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
}
}
else
{
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
cardInfo = cardInfoDA.GetTeaCardNumberForExcel(id,name,grade,atClass);
}
if(cardInfo.Tables[0].Rows.Count>0)
{
objData = new Object[cardInfo.Tables[0].Rows.Count,6];
for(int i=0;i<cardInfo.Tables[0].Rows.Count;i++)
{
objData[i,0] = cardInfo.Tables[0].Rows[i][0].ToString();
objData[i,1] = cardInfo.Tables[0].Rows[i][1].ToString();
objData[i,2] = cardInfo.Tables[0].Rows[i][2].ToString();
objData[i,3] = cardInfo.Tables[0].Rows[i][3].ToString();
objData[i,4] = cardInfo.Tables[0].Rows[i][4].ToString();
objData[i,5] = cardInfo.Tables[0].Rows[i][5].ToString();
}
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)m_objBooks.Open(excelTempFilePath+@"report\TeacherCardInfo.xls",
m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,
m_objOpt,m_objOpt,m_objOpt);
m_objSheets = (Excel.Sheets)m_objBook.Sheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
m_objRange = m_objSheet.get_Range("A3",m_objOpt);
m_objRange = m_objRange.get_Resize(cardInfo.Tables[0].Rows.Count,6);
m_objRange.Value = objData;
m_objRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
m_objRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
m_objRange.WrapText = true;
m_objRange.Borders.LineStyle = System.Windows.Forms.BorderStyle.FixedSingle;
m_objFont = m_objRange.Font;
m_objFont.Size = 9;
m_objBook.SaveAs(savePath, m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objFont);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objRange);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheets);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBooks);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
}
}
}
catch(Exception ex)
{
Util.WriteLog(ex.Message,Util.EXCEPTION_LOG_TITLE);
}
finally
{
m_objFont = null;
m_objRange = null;
m_objSheet = null;
m_objSheets = null;
m_objBook = null;
m_objBooks = null;
m_objExcel = null;
GC.Collect();
}
}
//退学
public int StuLeaveSchool(string id)
{
int rowAffected = 0;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
rowAffected = cardInfoDA.StuLeaveSchool(id);
}
return rowAffected;
}
public void WriteCardInfoExcel(string savePath)
{
using ( CardInfoDA cardInfoDA = new CardInfoDA() )
{
new CardInfoRule().WriteCardInfoExcel(cardInfoDA.GetExportCard(),savePath);
// new CardInfoRule().WriteCardInfoExcel(cardInfoDA.GetAllCardInfo(),savePath);
}
}
public DataSet GetTeaCardByID(string teaID)
{
DataSet CardInfoList = null;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
CardInfoList = cardInfoDA.GetTeaCardByID(teaID);
}
return CardInfoList;
}
public void DeleteCardInfo(bool isForStudent,string id)
{
using ( CardInfoDA cardInfoDA = new CardInfoDA() )
{
cardInfoDA.DeleteCardInfo(isForStudent,id);
}
}
public DataSet GetTeaBatchCardInfo()
{
DataSet batchCardInfoList = null;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
batchCardInfoList = cardInfoDA.GetTeaBatchCardInfo();
}
return batchCardInfoList;
}
public DataSet GetNoCardTeachers()
{
DataSet noCardTeachers = null;
using ( CardInfoDA cardInfoDA = new CardInfoDA() )
{
noCardTeachers = cardInfoDA.GetNoCardTeachers();
}
return noCardTeachers;
}
public DataSet GetNoCardStudents()
{
DataSet noCardStudents = null;
using ( CardInfoDA cardInfoDA = new CardInfoDA() )
{
noCardStudents = cardInfoDA.GetNoCardStudents();
}
return noCardStudents;
}
public DataSet GetTeaCardInfoList()
{
DataSet CardInfoList = null;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
CardInfoList = cardInfoDA.GetTeaCardInfoList();
}
return CardInfoList;
}
public int GetCardCount(string cardNumber)
{
int rowAffected = 0;
using(CardInfoDA cardInfoDA = new CardInfoDA())
{
rowAffected = cardInfoDA.GetCardCount(cardNumber);
}
return rowAffected;
}