private void OpenDataLinkDialog(string connection, dbDriver driver, string caption) { DataLinksClass dl = new MSDASC.DataLinksClass(); ADODB.Connection conn = new ADODB.ConnectionClass(); conn.ConnectionString = connection; object objCn = (object)conn; // dl.PromptNew(); if (dl.PromptEdit(ref objCn)) { this.Text = "MyMeta Browser " + caption; string error = ""; try { myMeta = new dbRoot(); myMeta.Connect(driver, conn.ConnectionString); } catch (Exception ex) { error = ex.Message; } this.InitializeTree(myMeta, error); } }
public static CubeDef GetCubeDef(string cubeName) { ConnectionClass con = new ADODB.ConnectionClass(); con.Open("Location=localhost;Initial Catalog=PsiMedicaCubes;Provider=MSOLAP;",string.Empty,string.Empty,(int)ConnectModeEnum.adModeUnknown); CatalogClass cat = new ADOMD.CatalogClass(); cat.ActiveConnection = con; return cat.CubeDefs[cubeName]; }
public static CubeDef GetCubeDef(string cubeName) { ConnectionClass con = new ADODB.ConnectionClass(); con.Open("Location=localhost;Initial Catalog=PsiMedicaCubes;Provider=MSOLAP;", string.Empty, string.Empty, (int)ConnectModeEnum.adModeUnknown); CatalogClass cat = new ADOMD.CatalogClass(); cat.ActiveConnection = con; return(cat.CubeDefs[cubeName]); }
private void Page_Load(object sender, System.EventArgs e) { ConnectionClass con = new ADODB.ConnectionClass(); con.Open("Location=localhost;Initial Catalog=PsiMedicaCubes;Provider=MSOLAP;", string.Empty, string.Empty, (int)ConnectModeEnum.adModeUnknown); CatalogClass cat = new ADOMD.CatalogClass(); cat.ActiveConnection = con; outputHTML = TransformXMLStream(GetTreeXML(cat, con), Server.MapPath("xsl/tree.xsl")); }
private bool IsColumnReadOnly(string name, string column) { if (radioSql.Checked) { int tableid = Gateway.Default.SelectScalar <int>("select id from sysobjects where [name] = @name", new object[] { name }); byte status = Gateway.Default.SelectScalar <byte>("select status from syscolumns where [name] = @name and id = @id", new object[] { column, tableid }); return(status == 128); } else if (radioOracle.Checked) { return(false); } else if (radioMySql.Checked) { System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex("(^.*database=)([^;]+)(;.*)", System.Text.RegularExpressions.RegexOptions.IgnoreCase); string dbName = r.Replace(txtConnStr.Text, "$2").ToLower(); DataSet ds = Gateway.Default.SelectDataSet("select EXTRA from COLUMNS where TABLE_SCHEMA = '" + dbName + "' and COLUMN_NAME = '" + column + "' and TABLE_NAME = ?TABLE_NAME", new object[] { name }); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i][0].ToString() == "auto_increment") { return(true); } } return(false); } else { ADODB.ConnectionClass conn = new ADODB.ConnectionClass(); conn.Provider = "Microsoft.Jet.OLEDB.4.0"; string connStr = txtConnStr.Text; conn.Open(connStr.Substring(connStr.ToLower().IndexOf("data source") + "data source".Length).Trim('=', ' '), null, null, 0); ADODB.Recordset rs = conn.GetType().InvokeMember("OpenSchema", BindingFlags.InvokeMethod, null, conn, new object[] { ADODB.SchemaEnum.adSchemaColumns }) as ADODB.Recordset; rs.Filter = "TABLE_NAME='" + name + "'"; while (!rs.EOF) { if ((rs.Fields["COLUMN_NAME"].Value as string) == column && ((int)rs.Fields["DATA_TYPE"].Value) == 3 && Convert.ToByte(rs.Fields["COLUMN_FLAGS"].Value) == 90) { return(true); } rs.MoveNext(); } } return(false); }
private bool IsColumnPrimaryKey(string name, string column) { if (radioSql.Checked) { int tableid = Gateway.Default.SelectScalar <int>("select id from sysobjects where [name] = @name", new object[] { name }); DataSet ds = Gateway.Default.SelectDataSet("select a.name FROM syscolumns a inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties' where (SELECT count(*) FROM sysobjects WHERE (name in (SELECT name FROM sysindexes WHERE (id = a.id) AND (indid in (SELECT indid FROM sysindexkeys WHERE (id = a.id) AND (colid in (SELECT colid FROM syscolumns WHERE (id = a.id) AND (name = a.name))))))) AND (xtype = 'PK'))>0 and d.id = @id", new object[] { tableid }); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i][0].ToString() == column) { return(true); } } } else if (radioOracle.Checked) { DataSet ds = Gateway.Default.SelectDataSet("select b.COLUMN_NAME from USER_CONSTRAINTS a,USER_CONS_COLUMNS b where a.CONSTRAINT_NAME=b.CONSTRAINT_NAME and a.table_name=b.table_name and constraint_type='P' and a.owner=b.owner and a.table_name = :name", new object[] { name }); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i][0].ToString() == column) { return(true); } } } else if (radioMySql.Checked) { System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex("(^.*database=)([^;]+)(;.*)", System.Text.RegularExpressions.RegexOptions.IgnoreCase); string dbName = r.Replace(txtConnStr.Text, "$2").ToLower(); DataSet ds = Gateway.Default.SelectDataSet("select COLUMN_NAME from KEY_COLUMN_USAGE where CONSTRAINT_SCHEMA = '" + dbName + "' and CONSTRAINT_NAME = 'PRIMARY' and TABLE_NAME = ?TABLE_NAME", new object[] { name }); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i][0].ToString() == column) { return(true); } } } else { ADODB.ConnectionClass conn = new ADODB.ConnectionClass(); conn.Provider = "Microsoft.Jet.OLEDB.4.0"; string connStr = txtConnStr.Text; conn.Open(connStr.Substring(connStr.ToLower().IndexOf("data source") + "data source".Length).Trim('=', ' '), null, null, 0); ADODB.Recordset rs = conn.GetType().InvokeMember("OpenSchema", BindingFlags.InvokeMethod, null, conn, new object[] { ADODB.SchemaEnum.adSchemaPrimaryKeys }) as ADODB.Recordset; rs.Filter = "TABLE_NAME='" + name + "'"; while (!rs.EOF) { if ((rs.Fields["COLUMN_NAME"].Value as string) == column) { return(true); } rs.MoveNext(); } } return(false); }
private void btnConnect_Click(object sender, EventArgs e) { if (txtConnStr.Text.Trim().Length == 0) { MessageBox.Show("Connection string cannot be null!"); return; } if (btnConnect.Text == "Disconnect") { EnableGenEntity(false); return; } RefreshConnectionStringAutoComplete(); DataSet dsTables = null; DataSet dsViews = null; if (radioSql.Checked || radioAccess.Checked) { try { if (radioSql.Checked) { Gateway.SetDefaultDatabase(DatabaseType.SqlServer, txtConnStr.Text); if (checkSql2005.Checked) { dsTables = Gateway.Default.SelectDataSet("select [name] from sysobjects where xtype = 'U' and [name] <> 'sysdiagrams' order by [name]", null); } else { dsTables = Gateway.Default.SelectDataSet("select [name] from sysobjects where xtype = 'U' and status > 0 order by [name]", null); } foreach (DataRow row in dsTables.Tables[0].Rows) { tables.Items.Add(row["Name"].ToString()); } if (checkSql2005.Checked) { dsViews = Gateway.Default.SelectDataSet("select [name] from sysobjects where xtype = 'V' order by [name]", null); } else { dsViews = Gateway.Default.SelectDataSet("select [name] from sysobjects where xtype = 'V' and status > 0 order by [name]", null); } foreach (DataRow row in dsViews.Tables[0].Rows) { views.Items.Add(row["Name"].ToString()); } } else if (radioAccess.Checked) { Gateway.SetDefaultDatabase(DatabaseType.MsAccess, txtConnStr.Text); ADODB.ConnectionClass conn = new ADODB.ConnectionClass(); conn.Provider = "Microsoft.Jet.OLEDB.4.0"; string connStr = txtConnStr.Text; conn.Open(connStr.Substring(connStr.ToLower().IndexOf("data source") + "data source".Length).Trim('=', ' '), null, null, 0); ADODB.Recordset rsTables = conn.GetType().InvokeMember("OpenSchema", BindingFlags.InvokeMethod, null, conn, new object[] { ADODB.SchemaEnum.adSchemaTables }) as ADODB.Recordset; ADODB.Recordset rsViews = conn.GetType().InvokeMember("OpenSchema", BindingFlags.InvokeMethod, null, conn, new object[] { ADODB.SchemaEnum.adSchemaViews }) as ADODB.Recordset; while (!rsViews.EOF) { if (!(rsViews.Fields["TABLE_NAME"].Value as string).StartsWith("MSys")) { views.Items.Add(rsViews.Fields["TABLE_NAME"].Value.ToString()); } rsViews.MoveNext(); } while (!rsTables.EOF) { if (!(rsTables.Fields["TABLE_NAME"].Value as string).StartsWith("MSys")) { bool isView = false; foreach (string item in views.Items) { if (item.Equals(rsTables.Fields["TABLE_NAME"].Value.ToString())) { isView = true; break; } } if (!isView) { tables.Items.Add(rsTables.Fields["TABLE_NAME"].Value.ToString()); } } rsTables.MoveNext(); } rsTables.Close(); rsViews.Close(); conn.Close(); } EnableGenEntity(true); } catch (Exception ex) { EnableGenEntity(false); MessageBox.Show("Read/write database error!\r\n" + ex.ToString()); } } else if (radioOracle.Checked) { Gateway.SetDefaultDatabase(DatabaseType.Oracle, txtConnStr.Text); dsTables = Gateway.Default.SelectDataSet("select * from user_tables where global_stats = 'NO' and (not table_name like '%$%')", null); foreach (DataRow row in dsTables.Tables[0].Rows) { tables.Items.Add(row["TABLE_NAME"].ToString()); } dsViews = Gateway.Default.SelectDataSet("select * from user_views where (not view_name like '%$%') and (not view_name like 'MVIEW_%') and (not view_name like 'CTX_%') and (not view_name = 'PRODUCT_PRIVS')", null); foreach (DataRow row in dsViews.Tables[0].Rows) { views.Items.Add(row["VIEW_NAME"].ToString()); } EnableGenEntity(true); } else if (radioMySql.Checked) { System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex("(^.*database=)([^;]+)(;.*)", System.Text.RegularExpressions.RegexOptions.IgnoreCase); string dbName = r.Replace(txtConnStr.Text, "$2").ToLower(); Gateway.SetDefaultDatabase(DatabaseType.MySql, r.Replace(txtConnStr.Text, "$1information_schema$3")); dsTables = Gateway.Default.SelectDataSet("select * from TABLES where TABLE_TYPE = 'BASE TABLE' and TABLE_SCHEMA = '" + dbName + "'", null); foreach (DataRow row in dsTables.Tables[0].Rows) { tables.Items.Add(row["TABLE_NAME"].ToString()); } dsViews = Gateway.Default.SelectDataSet("select * from TABLES where TABLE_TYPE = 'VIEW' and TABLE_SCHEMA = '" + dbName + "'", null); foreach (DataRow row in dsViews.Tables[0].Rows) { views.Items.Add(row["TABLE_NAME"].ToString()); } EnableGenEntity(true); } else { EnableGenEntity(false); MessageBox.Show("EntityGen tool only supports SqlServer, MsAccess, MySql and Oracle Database!"); } }
private void Transfer(ListBox _lbxFile, ListBox _lbxRecord, Label _lbNumRec, int _iSEQ_NO, ref bool _bFin) { // bool bContinue = false; SqlConnection SqlCon = new SqlConnection(PublicFunction.C_con.ConnectionString); SqlCon.Open(); string str_Con; //string connection ADODB.Connection ad_Con = new ADODB.ConnectionClass(); ADODB.Recordset ad_Rs = new ADODB.RecordsetClass(); string S_sDir = txt_path1.Text; //T_String.GetDataFromSQL("DIR_DR","GP_SYS_READER","SEQ_NO='" + _iSEQ_NO + "'", SqlCon); string S_sFile = txt_file1.Text; //T_String.GetDataFromSQL("FIL_NM", "GP_SYS_READER", "SEQ_NO='" + _iSEQ_NO + "'", SqlCon); string sDateFormat = PublicFunction.GetOption("SCHEMA_DateFormat"); string sDouble = ""; sDouble = PublicFunction.GetOption("SCHEMA_DOUBLE"); //int S_dbBook = T_String.IsNullTo0(T_String.GetDataFromSQL("RCD_FG", "GP_SYS_READER", "SEQ_NO='" + _iSEQ_NO + "'", SqlCon)); string S_sAppPath = Application.StartupPath.ToString(); if (!GetFileName(_lbxFile, S_sDir, S_sFile, SqlCon)) { _bFin = true; return; } if (!CreateTextFolder(S_sAppPath, _iSEQ_NO)) { _bFin = true; return; } str_Con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + S_sAppPath + "\\PieceRateText" + _iSEQ_NO.ToString() + ";Extended Properties='text;HDR=Yes;FMT=Delimited';"; if (!ADODB_Connect(ad_Con, str_Con)) { _bFin = true; return; } for (int i = 0; i < _lbxFile.Items.Count; i++) { _lbxFile.SelectedIndex = i; ad_Rs = FillTextFileToRecordset(S_sDir, _lbxFile.Items[i].ToString(), S_sAppPath + "\\PieceRateText" + _iSEQ_NO.ToString(), ad_Con); if (ad_Rs.EOF) { } else { while (ad_Rs.EOF == false) { string REA_NO; string sql, EMP_ID; double LSP; if (stop) { ad_Rs.Close(); ADODB_Close(ad_Con); return; } REA_NO = ad_Rs.Fields["READER_NO"].Value.ToString(); EMP_ID = REA_NO.Substring(12, 5); LSP = T_String.IsNullTo00(REA_NO.Substring(19, REA_NO.Length - 19)); // CRD_NO = ad_Rs.Fields["CARD_NO"].Value.ToString(); // CRD_DT=ad_Rs.Fields["DAYS"].Value.ToString(); // CRD_DT.Trim(); try { sql = "UPDATE FILD02A SET PieceRate=" + LSP + " WHERE EMP_ID='" + EMP_ID + "' AND YYY_MM='" + dt1.Text + "' AND SEQ_NO=2"; try { PublicFunction.SQL_Execute(sql, SqlCon); } catch (SqlException ex) { if (ex.Number != 2627) { MessageBox.Show(ex.Message + ""); } } } catch (Exception ex) { // if (bContinue == false) // { if (MessageBox.Show(ex.Message + "\n\rText File: " + _lbxFile.Items[i].ToString() + "\r\nContinue!", "Error!", System.Windows.Forms.MessageBoxButtons.YesNo) == DialogResult.No) { stop = true; } // bContinue = true; // } } _lbxRecord.Items.Add(EMP_ID + " " + LSP.ToString()); _lbxRecord.SelectedIndex = _lbxRecord.Items.Count - 1; // _lbNumRec.Text = (ad_Rs.Bookmark ) + "/" + ad_Rs.RecordCount.ToString(); // _lbNumRec.Text = (S_dbBook.ToString()+1) + "/" + ad_Rs.RecordCount.ToString(); ad_Rs.MoveNext(); } } } _bFin = true; SqlCon.Close(); ad_Rs.Close(); ADODB_Close(ad_Con); }
private void Page_Load(object sender, System.EventArgs e) { ConnectionClass con = new ADODB.ConnectionClass(); con.Open("Location=localhost;Initial Catalog=PsiMedicaCubes;Provider=MSOLAP;",string.Empty,string.Empty,(int)ConnectModeEnum.adModeUnknown); CatalogClass cat = new ADOMD.CatalogClass(); cat.ActiveConnection = con; outputHTML = TransformXMLStream(GetTreeXML(cat,con),Server.MapPath("xsl/tree.xsl")); }
private void TransferY(ListBox _lbxFile, ListBox _lbxRecord, Label _lbNumRec, int _iSEQ_NO, ref bool _bFin) { // bool bContinue = false; SqlConnection SqlCon = new SqlConnection(PublicFunction.C_con.ConnectionString); SqlCon.Open(); string keyD = ""; string stype = ""; int iphut = 0; string str_Con; //string connection ADODB.Connection ad_Con = new ADODB.ConnectionClass(); ADODB.Recordset ad_Rs = new ADODB.RecordsetClass(); string S_sDir = T_String.GetDataFromSQL("DIR_DR", "GP_SYS_READER", "SEQ_NO='" + _iSEQ_NO + "'", SqlCon); string S_sFile = T_String.GetDataFromSQL("FIL_NM", "GP_SYS_READER", "SEQ_NO='" + _iSEQ_NO + "'", SqlCon); string sDateFormat = PublicFunction.GetOption("SCHEMA_DateFormat"); string sDouble = ""; sDouble = PublicFunction.GetOption("SCHEMA_DOUBLE"); int S_dbBook = T_String.IsNullTo0(T_String.GetDataFromSQL("RCD_FG", "GP_SYS_READER", "SEQ_NO='" + _iSEQ_NO + "'", SqlCon)); string S_sAppPath = Application.StartupPath.ToString(); //key SqlConnection SqlCon1 = new SqlConnection(PublicFunction.C_con.ConnectionString); SqlCon1.Open(); Func.RecordSet rsK = new Func.RecordSet("Select * from GP_KEY", SqlCon1); if (rsK.rows > 0) { stype = rsK.record(0, "TYP_MN"); keyD = PublicFunction.encode(rsK.record(0, "COL_DT"), ""); iphut = T_String.IsNullTo0(rsK.record(0, "COL_MN")); } //end DateTime dtFG = AQ800(PublicFunction.S_Left(GetName(S_sFile), 8)); if (dtFG == new DateTime(1, 1, 1)) //if(PublicFunction.CUS_ID=="400") { if (!GetFileNameTHU(_lbxFile, S_sDir, S_sFile, SqlCon)) { _bFin = true; return; } } else { if (!GetFileName(_lbxFile, S_sDir, S_sFile, SqlCon)) { _bFin = true; return; } } if (!CreateTextFolder(S_sAppPath, _iSEQ_NO)) { _bFin = true; return; } str_Con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + S_sAppPath + "\\Text" + _iSEQ_NO.ToString() + ";Extended Properties='text;HDR=Yes;FMT=Delimited';"; if (!ADODB_Connect(ad_Con, str_Con)) { _bFin = true; return; } for (int i = 0; i < _lbxFile.Items.Count; i++) { string sREA_NO = string.Empty; if (dtFG == new DateTime(1, 1, 1)) //if(PublicFunction.CUS_ID=="400")//su dung may van tay { sREA_NO = _lbxFile.Items[i].ToString(); sREA_NO = PublicFunction.S_Left(sREA_NO, sREA_NO.Length - 12); } _lbxFile.SelectedIndex = i; ad_Rs = FillTextFileToRecordset(S_sDir, _lbxFile.Items[i].ToString(), S_sAppPath + "\\Text" + _iSEQ_NO.ToString(), ad_Con); if (ad_Rs.EOF || (S_dbBook > ad_Rs.RecordCount && GetName(S_sFile) == _lbxFile.Items[i].ToString())) { if (i < _lbxFile.Items.Count - 1) { S_dbBook = 1; } } else { if (i > 0) { S_dbBook = 0; } if (S_dbBook > 0) { ad_Rs.Move(S_dbBook - 1, 1); } while (ad_Rs.EOF == false) { string REA_NO, CRD_NO, CRD_DT, CRD_TM, CRD_TM_02 = ""; string sql, EMP_ID; double TM; if (stop) { sql = "UPDATE GP_SYS_READER SET RCD_FG=" + S_dbBook + ",FIL_NM=N'" + S_sDir + "\\" + _lbxFile.Items[i].ToString() + "' where SEQ_NO='" + _iSEQ_NO + "'"; PublicFunction.SQL_Execute(sql, SqlCon); ad_Rs.Close(); ADODB_Close(ad_Con); return; } REA_NO = ad_Rs.Fields["READER_NO"].Value.ToString(); CRD_NO = ad_Rs.Fields["CARD_NO"].Value.ToString(); CRD_DT = ad_Rs.Fields["DAYS"].Value.ToString(); CRD_DT.Trim(); CRD_TM = ""; if (PublicFunction.CUS_ID == "300" && _iSEQ_NO == 1) //KenYa { string sdateh = ""; sdateh = CRD_DT; CRD_NO = "00" + CRD_NO; CRD_DT = sdateh.Substring(0, 10); CRD_DT = CRD_DT.Replace("/", ""); CRD_TM = sdateh.Remove(0, 11); CRD_TM = CRD_TM.Replace(":", ""); } if (dtFG == new DateTime(1, 1, 1)) //if(PublicFunction.CUS_ID=="400")//may van tay { REA_NO = sREA_NO; } if (sDateFormat == "" || sDateFormat == null) { CRD_DT = ad_Rs.Fields["DAYS"].Value.ToString().Replace("/", "").Replace("-", ""); } else if (CRD_DT != "" && sDateFormat == "fr-FR") { try { IFormatProvider culture = new System.Globalization.CultureInfo("fr-FR", true); // Alternate choice: If the string has been input by an end user, you might // want to format it according to the current culture: // IFormatProvider culture = System.Threading.Thread.CurrentThread.CurrentCulture; CRD_DT = DateTime.Parse(CRD_DT, culture, System.Globalization.DateTimeStyles.None).ToString("yyyyMMdd"); // CRD_DT = CRD_DT.Split("d",2);//DateTime.Parse(CRD_DT).ToString() ;// .ToString(sDateFormat); // CRD_DT = DateTime.Parse(CRD_DT).ToString("yyyyMMdd"); } catch { } } if (PublicFunction.CUS_ID != "300" || _iSEQ_NO != 1) //kenya { CRD_TM = ad_Rs.Fields["HOURS"].Value.ToString().Replace(":", ""); } try { if (CRD_NO != "" && CRD_TM != "" && CRD_DT != "") { DateTime dt1 = GetDateTime(CRD_DT, CRD_TM).AddMinutes(-CRD_MN); DateTime dt2 = GetDateTime(CRD_DT, CRD_TM).AddMinutes(CRD_MN); TM = T_String.IsNullTo00(CRD_TM); if (TM == 0) { TM = 2400.0; CRD_TM = "2400"; CRD_DT = GetDate(CRD_DT).AddDays(-1).ToString("yyyyMMdd"); } sql = "(DAT_TM>" + dt1.ToString("yyyyMMddHHmm") + " and DAT_TM<" + dt2.ToString("yyyyMMddHHmm") + ") and CRD_NO=N'" + CRD_NO + "'"; if (!PublicFunction.SqlExists(SqlCon, "FILC01A", "CRD_DT='" + CRD_DT + "' AND CRD_NO='" + CRD_NO + "'" + " AND (DAT_TM BETWEEN '" + dt1.ToString("yyyyMMddHHmm") + "' AND '" + dt2.ToString("yyyyMMddHHmm") + "' OR CRD_TM=" + TM + ")")) { // if(T_String.IsNullTo0(T_String.GetDataFromSQL("top 1 1 ","FILC01A",sql, SqlCon))<=0 && // T_String.IsNullTo0(T_String.GetDataFromSQL("top 1 1", "FILC01A", "DAT_TM=N'"+CRD_DT+CRD_TM+"' and CRD_NO=N'"+CRD_NO+"'", SqlCon))<=0) int index = this.CRD_NO.IndexOf(CRD_NO); if (index >= 0) { EMP_ID = this.EMP_ID[index] + ""; } else { EMP_ID = ""; } //==============================CHIA 2 TH DOC DU LIEU CHAM CONG VA DOC DU LIEU CHO MAY QUAN LY TOILET if (sReaNo_VS1.IndexOf(REA_NO, 0) < 0) //(REA_NO != sReaNo_VS1 && REA_NO != sReaNo_VS2 ) { sql = "Insert into FILC01A(DAT_TM,EMP_ID,SWI_DT,USR_NM,CRD_DT,CRD_TM,CRD_NO,REA_NO,FIL_NM) values("; sql += "N'" + CRD_DT + CRD_TM + "',N'" + EMP_ID + "','" + dt + "',N'" + PublicFunction.A_UserID + "',"; sql += "'" + CRD_DT + "'," + TM + ","; sql += "N'" + CRD_NO + "',N'" + REA_NO + "',"; sql += "N'" + S_sDir + "\\" + _lbxFile.Items[i].ToString() + "')"; } else { sql = "Insert into FILC01A_VS(DAT_TM,EMP_ID,SWI_DT,USR_NM,CRD_DT,CRD_TM,CRD_NO,REA_NO,FIL_NM) values("; sql += "N'" + CRD_DT + CRD_TM + "',N'" + EMP_ID + "','" + dt + "',N'" + PublicFunction.A_UserID + "',"; sql += "'" + CRD_DT + "'," + TM + ","; sql += "N'" + CRD_NO + "',N'" + REA_NO + "',"; sql += "N'" + S_sDir + "\\" + _lbxFile.Items[i].ToString() + "')"; } // sql="Insert into FILC01A(DAT_TM,EMP_ID,SWI_DT,USR_NM,CRD_DT,CRD_TM,CRD_NO,REA_NO,FIL_NM) values("; // sql+="N'"+CRD_DT+CRD_TM+"',N'"+EMP_ID+"','"+dt+"',N'"+PublicFunction.A_UserID+"',"; // sql+="'"+CRD_DT+"',"+TM+","; // sql+="N'"+CRD_NO+"',N'"+REA_NO+"',"; // sql+="N'"+ S_sDir + "\\" + _lbxFile.Items[i].ToString() +"')"; try { PublicFunction.SQL_Execute(sql, SqlCon); } catch (SqlException ex) { if (ex.Number != 2627) { MessageBox.Show(ex.Message + ""); } } } if (sDouble != "" && sDouble != null) { try { CRD_TM_02 = ad_Rs.Fields["HOURS_02"].Value.ToString().Replace(":", ""); } catch { } } if (sDouble != "" && sDouble != null && CRD_TM_02 != "") { dt1 = GetDateTime(CRD_DT, CRD_TM_02).AddMinutes(-CRD_MN); dt2 = GetDateTime(CRD_DT, CRD_TM_02).AddMinutes(CRD_MN); TM = T_String.IsNullTo00(CRD_TM_02); if (TM == 0) { TM = 2400.0; CRD_TM = "2400"; CRD_DT = GetDate(CRD_DT).AddDays(-1).ToString("yyyyMMdd"); } sql = "(DAT_TM>" + dt1.ToString("yyyyMMddHHmm") + " and DAT_TM<" + dt2.ToString("yyyyMMddHHmm") + ") and CRD_NO=N'" + CRD_NO + "'"; // if(T_String.IsNullTo0(T_String.GetDataFromSQL(" top 1 1","FILC01A",sql, SqlCon))<=0 && //COUNT(DAT_TM) // T_String.IsNullTo0(T_String.GetDataFromSQL("top 1 1", "FILC01A", "DAT_TM=N'"+CRD_DT+CRD_TM_02+"' and CRD_NO=N'"+CRD_NO+"'", SqlCon))<=0) //COUNT(EMP_ID) if (!PublicFunction.SqlExists(SqlCon, "FILC01A", "CRD_DT='" + CRD_DT + "' AND CRD_NO='" + CRD_NO + "'" + " AND (DAT_TM BETWEEN '" + dt1.ToString("yyyyMMddHHmm") + "' AND '" + dt2.ToString("yyyyMMddHHmm") + "' OR CRD_TM=" + TM + ")")) { int index = this.CRD_NO.IndexOf(CRD_NO); if (index >= 0) { EMP_ID = this.EMP_ID[index] + ""; } else { EMP_ID = ""; } //==============================CHIA 2 TH DOC DU LIEU CHAM CONG VA DOC DU LIEU CHO MAY QUAN LY TOILET if (sReaNo_VS1.IndexOf(REA_NO, 0) < 0) //(REA_NO != sReaNo_VS1 && REA_NO != sReaNo_VS2) { sql = "Insert into FILC01A(DAT_TM,EMP_ID,SWI_DT,USR_NM,CRD_DT,CRD_TM,CRD_NO,REA_NO,FIL_NM) values("; sql += "N'" + CRD_DT + CRD_TM_02 + "',N'" + EMP_ID + "','" + dt + "',N'" + PublicFunction.A_UserID + "',"; sql += "'" + CRD_DT + "'," + T_String.IsNullTo00(CRD_TM_02) + ","; sql += "N'" + CRD_NO + "',N'" + REA_NO + "',"; sql += "N'" + S_sDir + "\\" + _lbxFile.Items[i].ToString() + "')"; } else { sql = "Insert into FILC01A_VS(DAT_TM,EMP_ID,SWI_DT,USR_NM,CRD_DT,CRD_TM,CRD_NO,REA_NO,FIL_NM) values("; sql += "N'" + CRD_DT + CRD_TM_02 + "',N'" + EMP_ID + "','" + dt + "',N'" + PublicFunction.A_UserID + "',"; sql += "'" + CRD_DT + "'," + T_String.IsNullTo00(CRD_TM_02) + ","; sql += "N'" + CRD_NO + "',N'" + REA_NO + "',"; sql += "N'" + S_sDir + "\\" + _lbxFile.Items[i].ToString() + "')"; } // sql="Insert into FILC01A(DAT_TM,EMP_ID,SWI_DT,USR_NM,CRD_DT,CRD_TM,CRD_NO,REA_NO,FIL_NM) values("; // sql+="N'"+CRD_DT+CRD_TM_02+"',N'"+EMP_ID+"','"+dt+"',N'"+PublicFunction.A_UserID+"',"; // sql+="'"+CRD_DT+"',"+T_String.IsNullTo00(CRD_TM_02)+","; // sql+="N'"+CRD_NO+"',N'"+REA_NO+"',"; // sql+="N'"+ S_sDir + "\\" + _lbxFile.Items[i].ToString() +"')"; try { PublicFunction.SQL_Execute(sql, SqlCon); } catch (SqlException ex) { if (ex.Number != 2627) { MessageBox.Show(ex.Message + ""); } } } } } } catch (Exception ex) { // if (bContinue == false) // { if (MessageBox.Show(ex.Message + "\n\rText File: " + _lbxFile.Items[i].ToString() + ", Bookmarks: " + Convert.ToString(S_dbBook + 1) + "\r\nContinue!", "Error!", System.Windows.Forms.MessageBoxButtons.YesNo) == DialogResult.No) { stop = true; } // bContinue = true; // } } _lbxRecord.Items.Add(CRD_NO + " " + CRD_DT + " " + CRD_TM + " " + CRD_TM_02); _lbxRecord.SelectedIndex = _lbxRecord.Items.Count - 1; // _lbNumRec.Text = (ad_Rs.Bookmark ) + "/" + ad_Rs.RecordCount.ToString(); // _lbNumRec.Text = (S_dbBook.ToString()+1) + "/" + ad_Rs.RecordCount.ToString(); S_dbBook++; ad_Rs.MoveNext(); //Tao khoa lam cho chuyen du lieu chay cham //LAY NGAY KHOA DUOI SQL if (stype.ToUpper() == "AS") { if (DateTime.Now >= DateTime.Parse(keyD)) { Thread.Sleep(500 * iphut); } } } } } if (_lbxFile.Items.Count > 0) { string sql = "update GP_SYS_READER set RCD_FG=" + S_dbBook + ", FIL_NM=N'" + S_sDir + "\\" + _lbxFile.Items[_lbxFile.Items.Count - 1] + "' where SEQ_NO=N'" + _iSEQ_NO + "'"; PublicFunction.SQL_Execute(sql, SqlCon); } _bFin = true; SqlCon.Close(); ad_Rs.Close(); ADODB_Close(ad_Con); }
private void OpenDataLinkDialog(string connection, dbDriver driver, string caption) { DataLinksClass dl = new MSDASC.DataLinksClass(); ADODB.Connection conn = new ADODB.ConnectionClass(); conn.ConnectionString = connection; object objCn = (object) conn; // dl.PromptNew(); if(dl.PromptEdit(ref objCn)) { this.Text = "MyMeta Browser " + caption; string error = ""; try { myMeta = new dbRoot(); myMeta.Connect(driver, conn.ConnectionString); } catch(Exception ex) { error = ex.Message; } this.InitializeTree(myMeta, error); } }