public void ResetTextChange(Control ctr)
{
if (ctr.GetType() == typeof(txtTextBox))
{
txtTextBox t = (txtTextBox)ctr;
t.bTextChange = false;
}
if (ctr.GetType() == typeof(txtTextLookup))
{
txtTextLookup t = (txtTextLookup)ctr;
t.bTextChange = false;
}
foreach (Control ctrl in ctr.Controls)
{
ResetTextChange(ctrl);
}
}
private void SetBorderTextBox(Control ctr, PaintEventArgs e)
{
Color cl = Commons.Common.GetColorBoder();
foreach (Control ctrl in ctr.Controls)
{
if (ctrl.HasChildren)
{
foreach (Control ctrChild in ctrl.Controls)
{
SetBorderTextBox(ctrChild, e);
}
}
if (ctrl.GetType() == typeof(txtTextBox))
{
//ctrl.Location.
txtTextBox t = (txtTextBox)ctrl;
if (t.bRequire)
{
Graphics g = e.Graphics;
Rectangle newRect = new Rectangle(ctrl.Location.X - 1, ctrl.Location.Y - 1,
ctrl.Width + 1, ctrl.Height + 1);
g.DrawRectangle(new Pen(cl, 1), newRect);
}
}
else if (ctrl.GetType() == typeof(txtDateTime))
{
//ctrl.Location.
txtDateTime t = (txtDateTime)ctrl;
if (t.bRequire)
{
Graphics g = e.Graphics;
Rectangle newRect = new Rectangle(ctrl.Location.X - 1, ctrl.Location.Y - 1,
ctrl.Width + 1, ctrl.Height + 1);
g.DrawRectangle(new Pen(cl, 1), newRect);
}
}
}
}
public virtual void Import_Excel_ODBC()
{
txtTextBox txttemp = new txtTextBox();
OpenFileDialog ofdlg = new OpenFileDialog();
ofdlg.Filter = "xls files (*.xls)|*.xls";
ofdlg.RestoreDirectory = true;
//ofdlg.DefaultExt = "xls";
//ofdlg.Filter = "*.xls|*.xls|*.xlsx|*.xlsx";
if (ofdlg.ShowDialog() != DialogResult.OK)
{
return;
}
else
{
txttemp.Text = ofdlg.FileName;
}
//Get Enviroment OS
//string strPath_OS = @"C:\Windows\SysWow64";
//string probeConnStr = string.Empty;
// if (Directory.Exists(strPath_OS)) //Window 64 bit
// {
// probeConnStr = @"Provider=Microsoft.ACE.OLEDB.12.0;
// Data Source= " + ofdlg.FileName + ";" +
// "Extended Properties=\"Excel 8.0;HDR=YES\"";
// }
// else
// {
// probeConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;
// Data Source= " + ofdlg.FileName + ";" +
// "Extended Properties=\"Excel 8.0;HDR=YES\"";
// }
string strConnectString =
"Driver={Microsoft Excel Driver (*.xls)};DBQ=" + txttemp.Text;
OdbcConnection odbcConn = new OdbcConnection(strConnectString);
odbcConn.Open();
OdbcCommand odbcComm = new OdbcCommand();
odbcComm.Connection = odbcConn;
try
{
OdbcDataAdapter odbcDA;
DataTable tbExcel = new DataTable();
odbcComm.CommandText = "SELECT * FROM [Sheet1$] WHERE 0 = 1" + "Where " + strCode + " IS NOT NULL AND " + strName + " IS NOT NULL";
odbcDA = new OdbcDataAdapter(odbcComm);
odbcDA = new OdbcDataAdapter(odbcComm);
odbcDA.Fill(tbExcel);
DataTable dtStruct = DataTool.SQLGetDataTable(strTableName, "TOP 0 * ", " 0 = 1", null);
DataTable dtStruct2 = dtStruct.Clone();
DataRow drNewRow = dtStruct.NewRow();
dtStruct.Rows.Add(drNewRow);
foreach (DataColumn dc in dtStruct2.Columns)
{
if (dc.DataType.ToString() == "System.Byte[]")
{
dtStruct.Columns.Remove(dc.ColumnName);
dtStruct.AcceptChanges();
}
}
//if (drNewRow.Table.Columns.Contains("Hinh"))
//{
// drNewRow.Table.Columns.Remove("Hinh");
// drNewRow.Table.AcceptChanges();
//}
Common.SetDefaultDataRow(ref drNewRow);
string strMsg = (Element.sysLanguage == enuLanguageType.Vietnamese ? "Bạn có muốn ghi đè lên mẫu tin đã tồn tại không ?" : "Do you want to override exists data ?");
bool bIs_Overwrite = Common.MsgYes_No(strMsg);
foreach (DataRow drExcel in tbExcel.Rows)
{
Common.CopyDataRow(drExcel, drNewRow);
drNewRow.AcceptChanges();
if (bIs_Overwrite)
{
DataTool.SQLDelete(strTableName, drNewRow);
DataTool.SQLUpdate(enuEdit.New, strTableName, ref drNewRow);
}
else
{
if (DataTool.SQLCheckExist(strTableName, strCode, (string)drExcel[strCode]))
{
continue;
}
else
{
DataTool.SQLUpdate(enuEdit.New, strTableName, ref drNewRow);
}
}
//if (bIs_Overwrite && DataTool.SQLCheckExist(strTableName, strCode, (string)drExcel[strCode]))
// DataTool.SQLUpdate(enuEdit.Edit, strTableName, ref drNewRow);
//else
// DataTool.SQLUpdate(enuEdit.New, strTableName, ref drNewRow);
}
}
catch (Exception ex)
{
MessageBox.Show("Có lỗi khi import file " + ofdlg.FileName + ex.Message);
}
Type type = this.GetType();
type.InvokeMember("FillData", BindingFlags.InvokeMethod, null, this, null);
Common.MsgOk(Languages.GetLanguage("End_Process"));
}
