public void RowInAccessibleTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); reader.Read(); // 2nd row _dt.Rows[1].Delete(); string value = reader[1].ToString(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public void CtorTest() { _dt.Rows[1].Delete(); DataTableReader reader = new DataTableReader(_dt); try { int i = 0; while (reader.Read()) i++; reader.Close(); Assert.Equal(2, i); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void SchemaTest() { DataTable another = new DataTable("another"); another.Columns.Add("x", typeof(string)); another.Rows.Add(new object[] { "test 1" }); another.Rows.Add(new object[] { "test 2" }); another.Rows.Add(new object[] { "test 3" }); DataTableReader reader = new DataTableReader(new DataTable[] { _dt, another }); try { DataTable schema = reader.GetSchemaTable(); Assert.Equal(_dt.Columns.Count, schema.Rows.Count); Assert.Equal(_dt.Columns[1].DataType.ToString(), schema.Rows[1]["DataType"].ToString()); reader.NextResult(); //schema should change here schema = reader.GetSchemaTable(); Assert.Equal(another.Columns.Count, schema.Rows.Count); Assert.Equal(another.Columns[0].DataType.ToString(), schema.Rows[0]["DataType"].ToString()); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void GetTest() { _dt.Columns.Add("nullint", typeof(int)); _dt.Rows[0]["nullint"] = 333; DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); int ordinal = reader.GetOrdinal("nullint"); // Get by name Assert.Equal(1, (int)reader["id"]); Assert.Equal(333, reader.GetInt32(ordinal)); Assert.Equal("Int32", reader.GetDataTypeName(ordinal)); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public ImpBLChkLstEntity(DataTableReader reader) { if (HasColumn(reader, "BLId") && reader["BLId"] != DBNull.Value) { this.BLId = Convert.ToInt64(reader["BLId"]); } if (HasColumn(reader, "FooterId") && reader["FooterId"] != DBNull.Value) { this.FooterId = Convert.ToInt64(reader["FooterId"]); } if (HasColumn(reader, "IGMBLNumber") && reader["IGMBLNumber"] != DBNull.Value) { this.IGMBLNumber = Convert.ToString(reader["IGMBLNumber"]); } if (HasColumn(reader, "ImpLineBLNo") && reader["ImpLineBLNo"] != DBNull.Value) { this.ImpLineBLNo = Convert.ToString(reader["ImpLineBLNo"]); } if (HasColumn(reader, "MotherVessel") && reader["MotherVessel"] != DBNull.Value) { this.MotherVessel = Convert.ToString(reader["MotherVessel"]); } if (HasColumn(reader, "ItemLinePrefix") && reader["ItemLinePrefix"] != DBNull.Value) { this.itemLinePrefix = Convert.ToString(reader["ItemLinePrefix"]); } if (HasColumn(reader, "ItemLineNo") && reader["ItemLineNo"] != DBNull.Value) { this.ItemLineNo = Convert.ToString(reader["ItemLineNo"]); } if (HasColumn(reader, "TransportMode") && reader["TransportMode"] != DBNull.Value) { this.TransportMode = Convert.ToString(reader["TransportMode"]); } if (HasColumn(reader, "PortLoading") && reader["PortLoading"] != DBNull.Value) { this.PortLoading = Convert.ToString(reader["PortLoading"]); } if (HasColumn(reader, "FinalDestination") && reader["FinalDestination"] != DBNull.Value) { this.FinalDestination = Convert.ToString(reader["FinalDestination"]); } if (HasColumn(reader, "HazCargo") && reader["HazCargo"] != DBNull.Value) { this.HazCargo = Convert.ToString(reader["HazCargo"]); } if (HasColumn(reader, "CargoType") && reader["CargoType"] != DBNull.Value) { this.CargoType = Convert.ToString(reader["CargoType"]); } if (HasColumn(reader, "PackageDetail") && reader["PackageDetail"] != DBNull.Value) { this.PackageDetail = Convert.ToString(reader["PackageDetail"]); } if (HasColumn(reader, "PackUnit") && reader["PackUnit"] != DBNull.Value) { this.PackUnit = Convert.ToString(reader["PackUnit"]); } if (HasColumn(reader, "Volume") && reader["Volume"] != DBNull.Value) { this.Volume = Convert.ToDecimal(reader["Volume"]); } if (HasColumn(reader, "VolUnit") && reader["VolUnit"] != DBNull.Value) { this.VolUnit = Convert.ToString(reader["VolUnit"]); } if (HasColumn(reader, "FreightType") && reader["FreightType"] != DBNull.Value) { this.FreightType = Convert.ToString(reader["FreightType"]); } if (HasColumn(reader, "CargoNature") && reader["CargoNature"] != DBNull.Value) { this.CargoNature = Convert.ToString(reader["CargoNature"]); } if (HasColumn(reader, "TPBondNo") && reader["TPBondNo"] != DBNull.Value) { this.TPBondNo = Convert.ToString(reader["TPBondNo"]); } if (HasColumn(reader, "FreeOut") && reader["FreeOut"] != DBNull.Value) { this.FreeOut = Convert.ToString(reader["FreeOut"]); } if (HasColumn(reader, "CACode") && reader["CACode"] != DBNull.Value) { this.CACode = Convert.ToString(reader["CACode"]); } //if (HasColumn(reader, "IGMBLDate") && reader["IGMBLDate"] != DBNull.Value) // this.IGMBLDate = Convert.ToString(reader["IGMBLDate"]); if (HasColumn(reader, "IGMBLDate") && reader["IGMBLDate"] != DBNull.Value) { this.IGMBLDate = Convert.ToDateTime(reader["IGMBLDate"]).ToString("dd/MM/yyyy"); } if (HasColumn(reader, "LineBLType") && reader["LineBLType"] != DBNull.Value) { this.LineBLType = Convert.ToString(reader["LineBLType"]); } if (HasColumn(reader, "ItemSubLineNo") && reader["ItemSubLineNo"] != DBNull.Value) { this.ItemSubLineNo = Convert.ToString(reader["ItemSubLineNo"]); } if (HasColumn(reader, "TaxExemption") && reader["TaxExemption"] != DBNull.Value) { this.TaxExemption = Convert.ToString(reader["TaxExemption"]); } if (HasColumn(reader, "PortDischarge") && reader["PortDischarge"] != DBNull.Value) { this.PortDischarge = Convert.ToString(reader["PortDischarge"]); } if (HasColumn(reader, "MovementCode") && reader["MovementCode"] != DBNull.Value) { this.MovementCode = Convert.ToString(reader["MovementCode"]); } if (HasColumn(reader, "MLOCode") && reader["MLOCode"] != DBNull.Value) { this.MLOCode = Convert.ToString(reader["MLOCode"]); } if (HasColumn(reader, "ItemType") && reader["ItemType"] != DBNull.Value) { this.ItemType = Convert.ToString(reader["ItemType"]); } if (HasColumn(reader, "GrossWeight") && reader["GrossWeight"] != DBNull.Value) { this.GrossWeight = Convert.ToDecimal(reader["GrossWeight"]); } if (HasColumn(reader, "WtUnit") && reader["WtUnit"] != DBNull.Value) { this.WtUnit = Convert.ToString(reader["WtUnit"]); } if (HasColumn(reader, "FreigthToCollect") && reader["FreigthToCollect"] != DBNull.Value) { this.FreigthToCollect = Convert.ToDecimal(reader["FreigthToCollect"]); } if (HasColumn(reader, "PartBL") && reader["PartBL"] != DBNull.Value) { this.PartBL = Convert.ToString(reader["PartBL"]); } if (HasColumn(reader, "DirectPortTransfer") && reader["DirectPortTransfer"] != DBNull.Value) { this.DirectPortTransfer = Convert.ToString(reader["DirectPortTransfer"]); } if (HasColumn(reader, "BLContainers") && reader["BLContainers"] != DBNull.Value) { this.BLContainers = Convert.ToString(reader["BLContainers"]); } if (HasColumn(reader, "TranShipment") && reader["TranShipment"] != DBNull.Value) { this.TranShipment = Convert.ToString(reader["TranShipment"]); } if (HasColumn(reader, "ShipperInformation") && reader["ShipperInformation"] != DBNull.Value) { this.ShipperInformation = Convert.ToString(reader["ShipperInformation"]); } if (HasColumn(reader, "ConsigneeInformation") && reader["ConsigneeInformation"] != DBNull.Value) { this.ConsigneeInformation = Convert.ToString(reader["ConsigneeInformation"]); } if (HasColumn(reader, "ConsigneeName") && reader["ConsigneeName"] != DBNull.Value) { this.ConsigneeName = Convert.ToString(reader["ConsigneeName"]); } if (HasColumn(reader, "NotifyPartyInformation") && reader["NotifyPartyInformation"] != DBNull.Value) { this.NotifyPartyInformation = Convert.ToString(reader["NotifyPartyInformation"]); } if (HasColumn(reader, "NotifyName") && reader["NotifyName"] != DBNull.Value) { this.NotifyPartyName = Convert.ToString(reader["NotifyName"]); } if (HasColumn(reader, "MarksNumbers") && reader["MarksNumbers"] != DBNull.Value) { this.MarksNumbers = Convert.ToString(reader["MarksNumbers"]); } if (HasColumn(reader, "GoodDescription") && reader["GoodDescription"] != DBNull.Value) { this.GoodDescription = Convert.ToString(reader["GoodDescription"]); } if (HasColumn(reader, "CargoArrivNotice") && reader["CargoArrivNotice"] != DBNull.Value) { this.CargoArrivNotice = Convert.ToString(reader["CargoArrivNotice"]); } if (HasColumn(reader, "DetentionFree") && reader["DetentionFree"] != DBNull.Value) { this.DetentionFree = Convert.ToInt32(reader["DetentionFree"]); } if (HasColumn(reader, "PGRFreeDays") && reader["PGRFreeDays"] != DBNull.Value) { this.PGRFreeDays = Convert.ToInt32(reader["PGRFreeDays"]); } if (HasColumn(reader, "DetentionSlab") && reader["DetentionSlab"] != DBNull.Value) { this.DetentionSlab = Convert.ToString(reader["DetentionSlab"]); } if (HasColumn(reader, "CntrNo") && reader["CntrNo"] != DBNull.Value) { this.CntrNo = Convert.ToString(reader["CntrNo"]); } if (HasColumn(reader, "CntrSize") && reader["CntrSize"] != DBNull.Value) { this.CntrSize = Convert.ToString(reader["CntrSize"]); } if (HasColumn(reader, "SealNo") && reader["SealNo"] != DBNull.Value) { this.SealNo = Convert.ToString(reader["SealNo"]); } if (HasColumn(reader, "CAgent") && reader["CAgent"] != DBNull.Value) { this.CAgent = Convert.ToString(reader["CAgent"]); } if (HasColumn(reader, "Status") && reader["Status"] != DBNull.Value) { this.Status = Convert.ToString(reader["Status"]); } if (HasColumn(reader, "Package") && reader["Package"] != DBNull.Value) { this.Package = Convert.ToInt32(reader["Package"]); } if (HasColumn(reader, "CntrGrossWeight") && reader["CntrGrossWeight"] != DBNull.Value) { this.CntrGrossWeight = Convert.ToDecimal(reader["CntrGrossWeight"]); } if (HasColumn(reader, "SOC") && reader["SOC"] != DBNull.Value) { this.SOC = Convert.ToString(reader["SOC"]); } if (HasColumn(reader, "Height") && reader["Height"] != DBNull.Value) { this.Height = Convert.ToDecimal(reader["Height"]); } if (HasColumn(reader, "Type") && reader["Type"] != DBNull.Value) { this.Type = Convert.ToString(reader["Type"]); } if (HasColumn(reader, "TareWgt") && reader["TareWgt"] != DBNull.Value) { this.TareWgt = Convert.ToDecimal(reader["TareWgt"]); } if (HasColumn(reader, "Comodity") && reader["Comodity"] != DBNull.Value) { this.Comodity = Convert.ToString(reader["Comodity"]); } if (HasColumn(reader, "MainLineVessel") && reader["MainLineVessel"] != DBNull.Value) { this.MainLineVessel = Convert.ToString(reader["MainLineVessel"]); } if (HasColumn(reader, "MLVoyageNo") && reader["MLVoyageNo"] != DBNull.Value) { this.MLVoyageNo = Convert.ToString(reader["MLVoyageNo"]); } if (HasColumn(reader, "LocName") && reader["LocName"] != DBNull.Value) { this.LocName = Convert.ToString(reader["LocName"]); } if (HasColumn(reader, "VesselName") && reader["VesselName"] != DBNull.Value) { this.VesselName = Convert.ToString(reader["VesselName"]); } if (HasColumn(reader, "VoyageNo") && reader["VoyageNo"] != DBNull.Value) { this.VoyageNo = Convert.ToString(reader["VoyageNo"]); } }
protected override void InitForm() { formCode = "SFRefundment"; base.InitForm(); this.Text = Pub.GetResText(formCode, "mnu" + formCode, "", new string[] { "Main" }); txtMoney.Enter += TextBoxCurrency_Enter; txtMoney.Leave += TextBoxCurrency_Leave; if (SystemInfo.AllowRefAllowance) { txtMoneyBT.Enabled = true; } double d = 0; txtMoney.Text = d.ToString(SystemInfo.CurrencySymbol + "0.00"); txtMoneyBT.Text = d.ToString(SystemInfo.CurrencySymbol + "0.00"); ExistsDepositType = SystemInfo.HasMoreDepositType; if (ExistsDepositType) { DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004013, new string[] { "0" })); if (!dr.Read()) { ExistsDepositType = false; } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } } txtUpDepositType.Enabled = ExistsDepositType; txtUpDepositType.Visible = txtUpDepositType.Enabled; lblUpDepositType.Visible = txtUpDepositType.Enabled; ExistsRefundmentType = SystemInfo.DefMoreRefundmentType; if (ExistsRefundmentType) { cbbType.Items.Clear(); DataTableReader dr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004014, new string[] { "102" })); if (dr.Read()) { cbbType.Items.Add(new TCommonType(dr["SFTypeSysID"].ToString(), dr["SFTypeID"].ToString(), dr["SFTypeName"].ToString(), true)); } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004014, new string[] { "0" })); while (dr.Read()) { cbbType.Items.Add(new TCommonType(dr["GUID"].ToString(), dr["RefundmentTypeID"].ToString(), dr["RefundmentTypeName"].ToString(), true)); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (cbbType.Items.Count > 0) { cbbType.SelectedIndex = 0; } if (cbbType.Items.Count == 1) { ExistsRefundmentType = false; } } txtMoney.Focus(); cbbType.Enabled = ExistsRefundmentType; cbbType.Visible = cbbType.Enabled; label7.Visible = cbbType.Enabled; OkContinue = SystemInfo.ini.ReadIni("Public", "CardOk", true); chkPrint.Checked = SystemInfo.ini.ReadIni("Public", "CheckPrint", false); label8.Enabled = SystemInfo.AllowCheckDepositLimit == 3; textBox1.Visible = SystemInfo.AllowCheckDepositLimit == 3; label8.Enabled = SystemInfo.AllowCheckDepositLimit == 3; textBox1.Visible = SystemInfo.AllowCheckDepositLimit == 3; SetTextboxNumber(textBox1); }
public void DeletePreviousAndAcceptChangesTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row _dt.Rows[0].Delete(); _dt.AcceptChanges(); Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void ClearTest() { DataTableReader reader = null; try { reader = new DataTableReader(_dt); reader.Read(); // first row reader.Read(); // second row _dt.Clear(); try { int i = (int)reader[0]; i++; // supress warning Assert.False(true); } catch (RowNotInTableException) { } // clear and add test reader.Close(); reader = new DataTableReader(_dt); reader.Read(); // first row reader.Read(); // second row _dt.Clear(); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); bool success = reader.Read(); Assert.False(success); // clear when reader is not read yet reader.Close(); reader = new DataTableReader(_dt); _dt.Clear(); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); success = reader.Read(); Assert.True(success); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
private void btnOk_Click(object sender, EventArgs e) { string RuleName = txtName.Text.Trim(); if (!Pub.CheckTextMaxLength(label1.Text, RuleName, txtName.MaxLength)) { return; } if (RuleName == "") { txtName.Focus(); ShowErrorEnterCorrect(label1.Text); return; } int flag = cbbFlag.SelectedIndex; int days = 0; int.TryParse(txtDays.Text, out days); ComboBox cbb; DataTableReader dr = null; bool IsOk = true; List <string> sql = new List <string>(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } if (SysID == "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "5", RuleName })); if (dr.Read()) { IsOk = false; txtName.Focus(); ShowErrorCannotRepeated(label1.Text); } else { sql.Add(Pub.GetSQL(DBCode.DB_002004, new string[] { "7", RuleName, flag.ToString(), days.ToString() })); } } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "6", SysID, RuleName })); if (dr.Read()) { IsOk = false; txtName.Focus(); ShowErrorCannotRepeated(label1.Text); } else { sql.Add(Pub.GetSQL(DBCode.DB_002004, new string[] { "8", RuleName, flag.ToString(), days.ToString(), SysID })); sql.Add(Pub.GetSQL(DBCode.DB_002004, new string[] { "2", SysID })); } } } catch (Exception E) { IsOk = false; Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (!IsOk) { return; } string ShiftNo = ""; for (int i = 1; i <= days; i++) { cbb = (ComboBox)this.Controls["cbbShift" + i.ToString("00")]; ShiftNo = ((TCommonType)cbb.Items[cbb.SelectedIndex]).id; sql.Add(Pub.GetSQL(DBCode.DB_002004, new string[] { "9", i.ToString(), ShiftNo, RuleName })); } if (db.ExecSQL(sql) != 0) { IsOk = false; } if (IsOk) { db.WriteSYLog(this.Text, CurrentOprt, sql); Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); } }
public void AccessBeforeReadTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { int i = (int)reader[0]; i++; // to supress warning } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
private void btnOk_Click(object sender, EventArgs e) { if (txtDepartID.Text.Trim() == "") { txtDepartID.Focus(); ShowErrorEnterCorrect(label2.Text); return; } if (cbbRule.SelectedIndex == -1) { cbbRule.Focus(); ShowErrorSelectCorrect(label3.Text); return; } string DepartID = txtDepartID.Text; string RuleID = ((TIDAndName)cbbRule.Items[cbbRule.SelectedIndex]).id; List <string> sql = new List <string>(); DataTableReader dr = null; bool IsError = false; try { if (SysID == "") { sql.Add(Pub.GetSQL(DBCode.DB_000203, new string[] { "3", RuleID, DepartID })); for (int i = 0; i < tvDepart.Nodes.Count; i++) { GetNodeSql(tvDepart.Nodes[i], RuleID, DepartID, ref sql); } } else { sql.Add(Pub.GetSQL(DBCode.DB_000203, new string[] { "3", RuleID, DepartID })); } } catch (Exception E) { IsError = true; Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (IsError) { return; } if (SystemInfo.db.ExecSQL(sql) != 0) { return; } SystemInfo.db.WriteSYLog(this.Text, CurrentOprt, sql); //Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); }
/// <summary> /// Read columns schema from database /// </summary> private List <DbColumn> ReadColumns(String tableName, string ownerName) { var result = new List <DbColumn>(); using (var adapter = new NpgsqlDataAdapter(String.Format("SELECT * FROM \"{0}\".\"{1}\" LIMIT 1", ownerName, tableName), _dbConnection)) { adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; DataTable columnsSchema; // Jjust to avoid stupid "Failed to enable constraints" error! using (var tempDs = new DataSet()) { // Avoiding stupid "Failed to enable constraints" error! tempDs.EnforceConstraints = false; using (var columnsList = new DataTable()) { tempDs.Tables.Add(columnsList); // Get from db adapter.Fill(columnsList); // Get schema using (var reader = new DataTableReader(columnsList)) columnsSchema = reader.GetSchemaTable(); } } // Used to get columns Npgsql DataType using (DataTable columnsDbTypeTable = _dbConnection.GetSchema("Columns")) { // Fetch the rows foreach (DataRow dr in columnsSchema.Rows) { var columnName = dr["ColumnName"].ToString(); var column = new DbColumn(columnName, columnName) { DataTypeDotNet = dr["DataType"].ToString(), Length = Convert.ToInt32(dr["ColumnSize"]), PrimaryKey = Convert.ToBoolean(dr["IsKey"]), AutoIncrement = Convert.ToBoolean(dr["IsAutoIncrement"]), AllowNull = Convert.ToBoolean(dr["AllowDBNull"]), ColumnOrdinal = Convert.ToInt32(dr["ColumnOrdinal"]), }; column.FieldNameSchema = DbSchemaNames.FieldName_RemoveInvalidChars(column.FieldNameSchema); // Columns which needs additional fetch var succeed = FillColumnAdditionalInfo(column, columnsDbTypeTable, tableName, columnName); // if additional info readin is failed, don't add it to the list if (succeed) { // Add to result result.Add(column); } else { // TODO: inform the user } } } } return(result); }
public List <PalavraSinalDTO> BuscarPalavrasCorretas() { var lstPalavraSinal = new List <PalavraSinalDTO>(); DataSet dataSet = new DataSet(); var connection = conexao.CriaConexao(); conexao.AbrirConexao(connection); SqlCommand command = new SqlCommand("PALAVRA_BUSCAR_CORRETA", connection); command.CommandType = CommandType.StoredProcedure; SqlTransaction transaction = connection.BeginTransaction(); command.Connection = connection; command.Transaction = transaction; try { SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataSet); DataTableReader reader = dataSet.Tables[0].CreateDataReader(); while (reader.Read()) { lstPalavraSinal.Add(new PalavraSinalDTO() { ObjPalavra = new PalavraDTO() { CodigoPalavra = (int)reader["ID_PALAVRA"], Palavra = reader["PALAVRA"].ToString(), CodigoSinal = (int)reader["ID_SINAL"] }, ObjSinal = new SinalDTO() { CodigoSinal = (int)reader["ID_SINAL"], Diretorio = reader["DIRETORIO"].ToString() } }); } ; transaction.Commit(); } catch (Exception ex) { try { transaction.Rollback(); throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } } finally { conexao.FecharConexao(connection); } return(lstPalavraSinal); }
private bool ReadCard(bool IsWrite) { CardData10 = ""; CardDataH = ""; CardData8 = ""; if (!Pub.CheckCardExists(ref CardData10, ref CardDataH, ref CardData8)) { return(false); } pubData = new QHAPI.TCardPubData(); sfData = new QHAPI.TCardSFData(); if (!Pub.ReadCardInfo(ref pubData, ref sfData)) { return(false); } if (!db.CheckCardExists(pubData.CardNo, CardData10)) { return(false); } DateTime dt = new DateTime(); if (!db.GetServerDate(ref dt)) { return(false); } if (!Pub.CheckCardValidDate(dt, pubData.CardBeginDate, pubData.CardEndDate)) { return(false); } DataTableReader dr = null; bool IsOk = false; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } if (!db.CheckDepartPowerByCard(pubData.CardNo)) { return(false); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "215", pubData.CardNo })); if (dr.Read()) { if (Convert.ToInt32(dr["CardStatusID"]) != 20) { Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgCardCostNotNormal", "")); } else { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepartName.Text = dr["DepartName"].ToString(); txtCardSectorNo.Text = dr["CardSectorNo"].ToString(); txtCardStatusName.Text = dr["CardStatusName"].ToString(); txtCardType.Text = dr["CardTypeName"].ToString(); IsOk = true; } } else { Pub.MessageBoxShow(Pub.GetResText("", "ErrorIllegalCard", "")); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } return(IsOk); }
protected override void OnResult(DataTableReader reader, eDBError eError) { //o_nResult = Convert.ToInt32(m_mySqlCommand.Parameters["@o_nResult"].Value); }
public void GetOrdinalTest() { DataTableReader reader = new DataTableReader(_dt); try { Assert.Equal(1, reader.GetOrdinal("name")); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
private void LoadData() { DataTableReader dr = null; TCommonType ctype = new TCommonType("", "", "", true); ComboBox cbb; int row = 0; for (int i = 1; i <= 31; i++) { cbb = (ComboBox)this.Controls["cbbShift" + i.ToString("00")]; cbb.Items.Clear(); cbb.Items.Add(ctype); } try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "3" })); while (dr.Read()) { ctype = new TCommonType(dr["GUID"].ToString(), dr["ShiftNo"].ToString(), dr["ShiftName"].ToString(), true); for (int i = 1; i <= 31; i++) { cbb = (ComboBox)this.Controls["cbbShift" + i.ToString("00")]; cbb.Items.Add(ctype); } } for (int i = 1; i <= 31; i++) { cbb = (ComboBox)this.Controls["cbbShift" + i.ToString("00")]; cbb.SelectedIndex = 0; } if (SysID == "") { cbbFlag.SelectedIndex = 0; } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "4", SysID })); if (dr.Read()) { txtName.Text = dr["ShiftRuleName"].ToString(); cbbFlag.SelectedIndex = Convert.ToInt32(dr["Flag"].ToString()); txtDays.Text = dr["CycDays"].ToString(); } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_002004, new string[] { "10", SysID })); while (dr.Read()) { int.TryParse(dr["ShiftRuleRow"].ToString(), out row); cbb = (ComboBox)this.Controls["cbbShift" + row.ToString("00")]; for (int i = 0; i < cbb.Items.Count; i++) { if (((TCommonType)cbb.Items[i]).id == dr["ShiftNo"].ToString()) { cbb.SelectedIndex = i; break; } } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
public void NoTablesTest() { Assert.Throws<ArgumentException>(() => { DataTableReader reader = new DataTableReader(new DataTable[] { }); try { reader.Read(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
private void loader_DoWork(object _sender, DoWorkEventArgs e) { if (e.Result != null) { try { using (var dtt = e.Result as DataTable) { if (dtt != null) { dtt.Dispose(); } } e.Result = null; } catch (Exception ex) { Lib.Win.Data.Env.WriteToLog(ex); } } using (DataTable dt = Environment.MessageData.GetDocMessages(DocID, out loader.Cmd)) { var it = new DataTable(); if (loader.CancellationPending) { return; } // adding columns // employees it.Columns.Add(new DataColumn(Environment.MessageData.EmployeesField) { DataType = Type.GetType("System.String") }); // dataMessage it.Columns.Add(new DataColumn(Environment.MessageData.DateMessageField) { DataType = Type.GetType("System.String") }); // title it.Columns.Add(new DataColumn(Environment.MessageData.TitleField) { DataType = Type.GetType("System.Boolean") }); // read it.Columns.Add(new DataColumn(Environment.MessageData.ReadField) { DataType = Type.GetType("System.Boolean") }); // origialEmployees it.Columns.Add(new DataColumn(Environment.MessageData.OriginalEmployeesField) { DataType = Type.GetType("System.String") }); // originalDataMessage it.Columns.Add(new DataColumn(Environment.MessageData.OriginalDateMessageField) { DataType = Type.GetType("System.String") }); // originalDataMessage it.Columns.Add(new DataColumn(Environment.MessageData.DateField) { DataType = Type.GetType("System.DateTime") }); // direction it.Columns.Add(new DataColumn(Environment.MessageData.DirectionField) { DataType = Type.GetType("System.Int32") }); if (loader.CancellationPending) { return; } string oldSender = null; DateTime oldSent = DateTime.MinValue; int lastSenderRowIndex = -1; using (DataTableReader dr = dt.CreateDataReader()) while (!loader.CancellationPending && dr.Read()) { var employeeSenderID = (Int32)dr[Environment.MessageData.DirectionField]; var sender = (string)dr[Environment.MessageData.SenderField]; var recipients = (string)dr[Environment.MessageData.RecipientsField]; var sent = (DateTime)dr[Environment.MessageData.SentField]; var message = (string)dr[Environment.MessageData.NameField]; object obj = dr[Environment.MessageData.ReadField]; bool read = !obj.Equals(DBNull.Value); if (sender != oldSender || sent != oldSent) { // inserting empty line if (it.Rows.Count > 0) { it.Rows.Add(new object[] { "", "", false, true, "", "", DateTime.MinValue, 0 }); } string dateStr = sent.AddHours(LocalObject.GetTimeDiff().Hours).ToString(); it.Rows.Add(new object[] { sender, dateStr, true, true, sender, dateStr, sent, employeeSenderID }); lastSenderRowIndex = it.Rows.Count - 1; } it.Rows.Add(new object[] { recipients, message, false, read, recipients, message, sent, employeeSenderID }); if (!read) { it.Rows[lastSenderRowIndex][3] = read; } } if (loader.CancellationPending) { it.Dispose(); it = null; } e.Result = it; } }
public void DontSeeTheEarlierRowsTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row // insert a row at position 0 DataRow r = _dt.NewRow(); r[0] = 0; r[1] = "adhi bagavan"; _dt.Rows.InsertAt(r, 0); Assert.Equal(2, reader.GetInt32(0)); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
private void DEVGrid_CellClick(object sender, DataGridViewCellEventArgs e) { int index = DEVGrid.CurrentRow.Index; //取得选中行的索引 string MacSN = DEVGrid.Rows[index].Cells[1].Value.ToString(); DataTableReader dr = null; string DoorMagnetic_Type = ""; string Anti_back = ""; string ServerRequest = ""; string Use_Alarm = ""; string Wiegand_Output = ""; string Wiegand_Input = ""; dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN })); if (dr.Read()) { cbbGlogWarning.Text = dr["GlogWarning"].ToString(); cbbDoorMagneticDelay.Text = dr["DoorMagneticDelay"].ToString(); cbbAlarmDelay.Text = dr["AlarmDelay"].ToString(); cbbDiMacNo.Text = dr["DiMacNo"].ToString(); cbbOpenDoorDelay.Text = dr["OpenDoorDelay"].ToString(); cbbManagers.Text = dr["Managers"].ToString(); cbbVolume.Text = dr["Volume"].ToString(); cbbMutiUser.Text = dr["MutiUser"].ToString(); cbbShowResultTime.Text = dr["ShowResultTime"].ToString(); cbbReverifyTime.Text = dr["ReverifyTime"].ToString(); cbbScreensaversTime.Text = dr["ScreensaversTime"].ToString(); cbbSleepTime.Text = dr["SleepTime"].ToString(); cbbWiegandType.Text = dr["WiegandType"].ToString(); Wiegand_Output = dr["WiegandOutput"].ToString(); Wiegand_Input = dr["WiegandInput"].ToString(); DoorMagnetic_Type = dr["DoorMagneticType"].ToString(); if (DoorMagnetic_Type == "no") { cbbDoorMagneticType.Text = DoorMagnetic_TypeAll; } else if (DoorMagnetic_Type == "close") { cbbDoorMagneticType.Text = Pub.GetResText(formCode, "close", ""); } else { cbbDoorMagneticType.Text = Pub.GetResText(formCode, "open", ""); } Anti_back = dr["Antiback"].ToString(); if (Anti_back == "no") { cbbAntiback.Text = Anti_backAll; } else { cbbAntiback.Text = Pub.GetResText(formCode, "yes", ""); } Use_Alarm = dr["UseAlarm"].ToString(); if (Use_Alarm == "yes") { cbbUseAlarm.Text = Use_AlarmAll; } else { cbbUseAlarm.Text = Pub.GetResText(formCode, "no", ""); } ServerRequest = dr["ServerRequest"].ToString(); if (ServerRequest == "0") { cbbServerRequest.Text = ServerRequestAll; } else { cbbServerRequest.Text = Pub.GetResText(formCode, "yes", ""); } if (Wiegand_Input == "1") { cbbWiegandInput.Text = Pub.GetResText(formCode, "CardNo", ""); } else { cbbWiegandInput.Text = Pub.GetResText(formCode, "EmpNoParam", ""); } if (Wiegand_Output == "1") { cbbWiegandOutput.Text = Pub.GetResText(formCode, "CardNo", ""); } else { cbbWiegandOutput.Text = Pub.GetResText(formCode, "EmpNoParam", ""); } txtServerIPAddress.Text = dr["ServerIPAddress"].ToString(); txtServerPort.Text = dr["ServerPort"].ToString(); Application.DoEvents(); } else { DefaultControl(); Application.DoEvents(); } }
public void DeleteLastAndAcceptChangesTest2() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row reader.Read(); // third row _dt.Rows[2].Delete(); // delete row, where reader points to _dt.AcceptChanges(); // accept the action Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public void ValidarUsuario(Usuario Datos) { try { object[] Parametros = { Datos.CuentaUsuario, Datos.Password, Comun.MACAddress, Comun.IDProyecto }; DataSet Ds = SqlHelper.ExecuteDataset(Datos.Conexion, "Usuarios.spCSLDB_Login", Parametros); Datos.Completado = false; if (Ds != null) { if (Ds.Tables.Count > 0) { if (Ds.Tables[0] != null) { DataTableReader Dr = Ds.Tables[0].CreateDataReader(); if (Dr.HasRows) { while (Dr.Read() && !Datos.Completado) { Datos.Completado = true; Datos.Resultado = Dr.IsDBNull(Dr.GetOrdinal("Resultado")) ? 0 : Dr.GetInt32(Dr.GetOrdinal("Resultado")); if (Datos.Resultado == 1) { Comun.IDUsuario = Dr.IsDBNull(Dr.GetOrdinal("IDUsuario")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("IDUsuario")); Comun.NombreUsuario = Dr.IsDBNull(Dr.GetOrdinal("NombreUsuario")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("NombreUsuario")); Comun.ApellidoPatUsuario = Dr.IsDBNull(Dr.GetOrdinal("ApellidoPaterno")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("ApellidoPaterno")); Comun.ApellidoMatUsuario = Dr.IsDBNull(Dr.GetOrdinal("ApellidoMaterno")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("ApellidoMaterno")); Comun.IDTipoUsuario = Dr.IsDBNull(Dr.GetOrdinal("IDTipoUsuario")) ? 0 : Dr.GetInt32(Dr.GetOrdinal("IDTipoUsuario")); Comun.IDSucursalCaja = Dr.IsDBNull(Dr.GetOrdinal("IDSucursal")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("IDSucursal")); Datos.CrearIDCaja = Dr.IsDBNull(Dr.GetOrdinal("CrearIDCaja")) ? false : Dr.GetBoolean(Dr.GetOrdinal("CrearIDCaja")); Comun.IDCaja = Dr.IsDBNull(Dr.GetOrdinal("IDCaja")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("IDCaja")); Comun.IDCajaCat = Dr.IsDBNull(Dr.GetOrdinal("IDCatCaja")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("IDCatCaja")); Comun.Impresora = Dr.IsDBNull(Dr.GetOrdinal("Impresora")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("Impresora")); Comun.CuentaUsuario = Dr.IsDBNull(Dr.GetOrdinal("UsuarioCuenta")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("UsuarioCuenta")); Comun.RazonSocial = Dr.IsDBNull(Dr.GetOrdinal("RazonSocial")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("RazonSocial")); Comun.RFC = Dr.IsDBNull(Dr.GetOrdinal("RFC")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("RFC")); Comun.Direccion = Dr.IsDBNull(Dr.GetOrdinal("Direccion")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("Direccion")); Comun.DomicilioFiscal = Dr.IsDBNull(Dr.GetOrdinal("DomicilioFiscal")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("DomicilioFiscal")); Comun.Eslogan = Dr.IsDBNull(Dr.GetOrdinal("Eslogan")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("Eslogan")); Comun.RegimenFiscal = Dr.IsDBNull(Dr.GetOrdinal("RegimenFiscal")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("RegimenFiscal")); Comun.NombreComercial = Dr.IsDBNull(Dr.GetOrdinal("NombreComercial")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("NombreComercial")); Comun.UrlLogo = Dr.IsDBNull(Dr.GetOrdinal("UrlLogo")) ? string.Empty : Dr.GetString(Dr.GetOrdinal("UrlLogo")); Comun.CajaAbierta = Dr.IsDBNull(Dr.GetOrdinal("CajaAbierta")) ? false : Dr.GetBoolean(Dr.GetOrdinal("CajaAbierta")); Comun.FaltaLogo = Dr.IsDBNull(Dr.GetOrdinal("FaltaLogo")) ? false : Dr.GetBoolean(Dr.GetOrdinal("FaltaLogo")); if (Ds.Tables.Count > 1) { if (Ds.Tables[1] != null) { Comun.TablaPermisos = Ds.Tables[1]; } } } } } } } } } catch (Exception ex) { throw new Exception("No se puede obtener la información: " + ex.Message); } }
private void btnFindEmp_Click(object sender, EventArgs e) { IsReadCard = false; DataTableReader dr = null; string sql = Pub.GetSQL(DBCode.DB_001003, new string[] { "224", OprtInfo.DepartPower, txtFind.Text.Trim() }); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(sql); if (dr.Read()) { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepartName.Text = dr["DepartName"].ToString(); txtCardSectorNo.Text = dr["CardSectorNo"].ToString(); txtCardStatusName.Text = dr["CardStatusName"].ToString(); CardUseDate = new DateTime(); DateTime.TryParse(dr["CardUseDate"].ToString(), out CardUseDate); txtCardUseDate.Text = CardUseDate.ToString(); txtCardType.Text = dr["CardTypeName"].ToString(); CardBalance = 0; double.TryParse(dr["CardBalanceBT"].ToString(), out CardBalance); txtCardBalanceBT.Text = CardBalance.ToString(SystemInfo.CurrencySymbol + "0.00"); if (SystemInfo.AllowCustomerCardNo) { txtCardNo.Text = db.GetMaxCardSectorNo(); } CardFee = 0; double.TryParse(dr["CardFee"].ToString(), out CardFee); txtCardFee.Text = CardFee.ToString(SystemInfo.CurrencySymbol + "0.00"); EmpSysID = dr["EmpSysID"].ToString(); CardTypeID = Convert.ToByte(dr["CardTypeID"]); CardPWD = dr["CardPWD"].ToString(); if ((CardPWD == "") || (!Pub.IsNumeric(CardPWD))) { CardPWD = "000000"; } if (Convert.ToInt32(CardPWD) > 999999) { CardPWD = "000000"; } CardStartDate = (DateTime)dr["CardStartDate"]; CardEndDate = (DateTime)dr["CardEndDate"]; CardCheckOrder = Pub.ValueToBool(dr["CardCheckOrder"].ToString()); CardUseTimes = 0; int.TryParse(dr["CardUseTimes"].ToString(), out CardUseTimes); BTFlag = ""; if (dr["LastBTFlag"].ToString() != "") { DateTime dd = new DateTime(); if (DateTime.TryParse(dr["LastBTFlag"].ToString(), out dd)) { BTFlag = dd.ToString("yyMMdd"); } } IsReadCard = true; } if (IsReadCard && SystemInfo.HasSF) { dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "227", EmpSysID })); if (dr.Read()) { double d = 0; double.TryParse(dr["SFCardBalance"].ToString(), out d); if (CardBalance != d) { if (Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "Error001", ""))) { return; } } CardBalance = d; } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } ResetForm(); }
private void btnSave_Click(object sender, EventArgs e) { string DoorMagnetic_Type = ""; string Anti_back = ""; string ServerRequest = ""; string Use_Alarm = ""; string Glog_Warning = ""; string DoorMagnetic_Delay = ""; string Alarm_Delay = ""; string Di_MacNo = ""; string OpenDoor_Delay = ""; string Managers = ""; string Volume = ""; string MutiUser = ""; string Show_ResultTime = ""; string Reverify_Time = ""; string Screensavers_Time = ""; string Sleep_Time = ""; string Wiegand_Type = ""; string Wiegand_Output = ""; string Wiegand_Input = ""; string ServerIPAddress = ""; string ServerPort = ""; string MacSN = ""; string sql = ""; string msg = ""; bool ret = true; string Mac = ""; string Err = ""; Glog_Warning = cbbGlogWarning.Text.Trim(); DoorMagnetic_Delay = cbbDoorMagneticDelay.Text.Trim(); Alarm_Delay = cbbAlarmDelay.Text.Trim(); Di_MacNo = cbbDiMacNo.Text.Trim(); OpenDoor_Delay = cbbOpenDoorDelay.Text.Trim(); Managers = cbbManagers.Text.Trim(); Volume = cbbVolume.Text.Trim(); MutiUser = cbbMutiUser.Text.Trim(); Show_ResultTime = cbbShowResultTime.Text.Trim(); Reverify_Time = cbbReverifyTime.Text.Trim(); Screensavers_Time = cbbScreensaversTime.Text.Trim(); Sleep_Time = cbbSleepTime.Text.Trim(); Wiegand_Type = cbbWiegandType.Text.Trim(); ServerIPAddress = txtServerIPAddress.Text.Trim(); ServerPort = txtServerPort.Text.Trim(); Application.DoEvents(); if (int.Parse(Managers) > 10 || int.Parse(Managers) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label1.Text, 0, 10); Pub.MessageBoxShow(Err); cbbManagers.Focus(); return; } if (int.Parse(Volume) > 10 || int.Parse(Volume) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label2.Text, 0, 10); Pub.MessageBoxShow(Err); cbbVolume.Focus(); return; } if (int.Parse(Glog_Warning) > 1000 || int.Parse(Glog_Warning) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label4.Text, 0, 1000); Pub.MessageBoxShow(Err); cbbGlogWarning.Focus(); return; } if (int.Parse(Show_ResultTime) > 30 || int.Parse(Show_ResultTime) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label3.Text, 0, 30); Pub.MessageBoxShow(Err); cbbShowResultTime.Focus(); return; } if (int.Parse(Reverify_Time) > 60 || int.Parse(Reverify_Time) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label5.Text, 0, 60); Pub.MessageBoxShow(Err); cbbReverifyTime.Focus(); return; } if (int.Parse(Screensavers_Time) > 1440 || int.Parse(Screensavers_Time) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label6.Text, 0, 1440); Pub.MessageBoxShow(Err); cbbScreensaversTime.Focus(); return; } if (int.Parse(Sleep_Time) > 60 || int.Parse(Sleep_Time) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label7.Text, 0, 60); Pub.MessageBoxShow(Err); cbbSleepTime.Focus(); return; } if (int.Parse(OpenDoor_Delay) > 200 || int.Parse(OpenDoor_Delay) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label14.Text, 0, 200); Pub.MessageBoxShow(Err); cbbOpenDoorDelay.Focus(); return; } if (int.Parse(MutiUser) > 10 || int.Parse(MutiUser) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label13.Text, 0, 10); Pub.MessageBoxShow(Err); cbbMutiUser.Focus(); return; } if (int.Parse(DoorMagnetic_Delay) > 200 || int.Parse(DoorMagnetic_Delay) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label15.Text, 0, 200); Pub.MessageBoxShow(Err); cbbDoorMagneticDelay.Focus(); return; } if (int.Parse(Alarm_Delay) > 255 || int.Parse(Alarm_Delay) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label14.Text, 0, 255); Pub.MessageBoxShow(Err); cbbAlarmDelay.Focus(); return; } if (int.Parse(Di_MacNo) > 255 || int.Parse(Di_MacNo) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label9.Text, 0, 255); Pub.MessageBoxShow(Err); cbbDiMacNo.Focus(); return; } Wiegand_Output = cbbWiegandOutput.Text.Trim(); Wiegand_Input = cbbWiegandInput.Text.Trim(); if (Wiegand_Output == Pub.GetResText(formCode, "CardNo", "")) { Wiegand_Output = "1"; } else { Wiegand_Output = "0"; } if (Wiegand_Input == Pub.GetResText(formCode, "CardNo", "")) { Wiegand_Input = "1"; } else { Wiegand_Input = "0"; } DoorMagnetic_Type = cbbDoorMagneticType.Text.Trim(); Anti_back = cbbAntiback.Text.Trim(); ServerRequest = cbbServerRequest.Text.Trim(); Use_Alarm = cbbUseAlarm.Text.Trim(); if (DoorMagnetic_Type == DoorMagnetic_TypeAll) { DoorMagnetic_Type = "no"; } else if (DoorMagnetic_Type == Pub.GetResText(formCode, "close", "")) { DoorMagnetic_Type = "close"; } else { DoorMagnetic_Type = "open"; } if (Anti_back == Anti_backAll) { Anti_back = "no"; } else { Anti_back = "yes"; } if (ServerRequest == ServerRequestAll) { ServerRequest = "0"; } else { ServerRequest = "1"; } if (Use_Alarm == Use_AlarmAll) { Use_Alarm = "yes"; } else { Use_Alarm = "no"; } DataTable dt = (DataTable)bindingSource.DataSource; int index = DEVGrid.CurrentRow.Index; //取得选中行的索引 MacSN = DEVGrid.Rows[index].Cells[1].Value.ToString(); Application.DoEvents(); for (int i = 0; i < dt.Rows.Count; i++) { ret = true; bool Select = false; if (!Convert.IsDBNull(dt.Rows[i]["SelectCheck"])) { Select = Convert.ToBoolean(dt.Rows[i]["SelectCheck"]); } if (MacSN == "") { if (!Select) { continue; } MacSN = dt.Rows[i]["MacSN"].ToString(); if (Mac == MacSN) { MacSN = ""; continue; } } else { Mac = MacSN; i = -1; } msg = " [" + MacSN + "] " + "..."; RefreshMacMsg(msg); DataTableReader dr = null; dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN })); if (dr.Read()) { sql = Pub.GetSQL(DBCode.DB_000002, new string[] { "203", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, Di_MacNo, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input }); } else { sql = Pub.GetSQL(DBCode.DB_000002, new string[] { "202", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, Di_MacNo, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input }); } try { SystemInfo.db.ExecSQL(sql); } catch (Exception E) { ret = false; Pub.ShowErrorMsg(E, sql); } finally { if (dr != null) { dr.Close(); } dr = null; } if (ret) { msg = Pub.GetResText(formCode, "MsgSaveSucceed", ""); } else { msg = Pub.GetResText(formCode, "MsgSaveFail", ""); } UpdateMacMsg(msg, ret); MacSN = ""; Application.DoEvents(); } }
private void LoadData() { DataTableReader dr = null; DataTableReader drr = null; try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } if (SysID == "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004003, new string[] { "101" })); if (dr.Read()) { int no = 0; int.TryParse(dr[0].ToString(), out no); if (no > 9999) { no = 9999; } txtNo.Text = no.ToString(); } drr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004003, new string[] { "102" })); if (drr.Read()) { txtCategory.Text = drr["CategoryName"].ToString(); txtCategory.Tag = drr["CategoryID"].ToString(); } } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004003, new string[] { "4", SysID })); if (dr.Read()) { txtNo.Text = dr["ProductsID"].ToString(); txtName.Text = dr["ProductsName"].ToString(); double d = 0; double.TryParse(dr["ProductsPrice"].ToString(), out d); txtPrice.Text = d.ToString(SystemInfo.CurrencySymbol + "0.00"); txtCategory.Text = dr["CategoryName"].ToString(); txtCategory.Tag = dr["CategoryID"].ToString(); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; if (drr != null) { drr.Close(); } drr = null; } }
public JobEntity(DataTableReader reader) { if (ColumnExists(reader, "pk_JobID")) { if (reader["pk_JobID"] != DBNull.Value) { JobID = Convert.ToInt64(reader["pk_JobID"]); } } if (ColumnExists(reader, "fk_JobTypeID")) { if (reader["fk_JobTypeID"] != DBNull.Value) { JobTypeID = Convert.ToInt32(reader["fk_JobTypeID"]); } } if (ColumnExists(reader, "JobType")) { if (reader["JobType"] != DBNull.Value) { JobType = Convert.ToString(reader["JobType"]); } } if (ColumnExists(reader, "JobDate")) { if (reader["JobDate"] != DBNull.Value) { JobDate = Convert.ToDateTime(reader["JobDate"]); } } if (ColumnExists(reader, "fk_CompanyID")) { if (reader["fk_CompanyID"] != DBNull.Value) { CompanyID = Convert.ToInt32(reader["fk_CompanyID"]); } } if (ColumnExists(reader, "JobPrefix")) { if (reader["JobPrefix"] != DBNull.Value) { JobPrefix = Convert.ToString(reader["JobPrefix"]); } } if (ColumnExists(reader, "JobNo")) { if (reader["JobNo"] != DBNull.Value) { JobNo = Convert.ToString(reader["JobNo"]); } } if (ColumnExists(reader, "PJobNo")) { if (reader["PJobNo"] != DBNull.Value) { PJobNo = Convert.ToString(reader["PJobNo"]); } } if (ColumnExists(reader, "OpsLoc")) { if (reader["OpsLoc"] != DBNull.Value) { OpsLoc = Convert.ToString(reader["OpsLoc"]); } } if (ColumnExists(reader, "JobLoc")) { if (reader["JobLoc"] != DBNull.Value) { JobLoc = Convert.ToString(reader["JobLoc"]); } } if (ColumnExists(reader, "fk_OpsLocID")) { if (reader["fk_OpsLocID"] != DBNull.Value) { OpsLocID = Convert.ToInt32(reader["fk_OpsLocID"]); } } if (ColumnExists(reader, "fk_JobLocID")) { if (reader["fk_JobLocID"] != DBNull.Value) { jobLocID = Convert.ToInt32(reader["fk_JobLocID"]); } } if (ColumnExists(reader, "fk_SalesmanID")) { if (reader["fk_SalesmanID"] != DBNull.Value) { SalesmanID = Convert.ToInt32(reader["fk_SalesmanID"]); } } if (ColumnExists(reader, "fk_SmodeID")) { if (reader["fk_SmodeID"] != DBNull.Value) { SmodeID = Convert.ToInt32(reader["fk_SmodeID"]); } } if (ColumnExists(reader, "fk_prDocID")) { if (reader["fk_prDocID"] != DBNull.Value) { PrDocID = Convert.ToInt32(reader["fk_prDocID"]); } } if (ColumnExists(reader, "ShippingMode")) { if (reader["ShippingMode"] != DBNull.Value) { ShippingMode = Convert.ToString(reader["ShippingMode"]); } } if (ColumnExists(reader, "PrintHBL")) { if (reader["PrintHBL"] != DBNull.Value) { PrintHBL = Convert.ToBoolean(reader["PrintHBL"]); } } if (ColumnExists(reader, "fk_HBLFormatID")) { if (reader["fk_HBLFormatID"] != DBNull.Value) { HBLFormatID = Convert.ToInt32(reader["fk_HBLFormatID"]); } } if (ColumnExists(reader, "ttl20")) { if (reader["ttl20"] != DBNull.Value) { ttl20 = Convert.ToInt32(reader["ttl20"]); } } if (ColumnExists(reader, "ttl40")) { if (reader["ttl40"] != DBNull.Value) { ttl40 = Convert.ToInt32(reader["ttl40"]); } } if (ColumnExists(reader, "grwt")) { if (reader["grwt"] != DBNull.Value) { grwt = Convert.ToDecimal(reader["grwt"]); } } if (ColumnExists(reader, "VolWt")) { if (reader["VolWt"] != DBNull.Value) { VolWt = Convert.ToDecimal(reader["VolWt"]); } } if (ColumnExists(reader, "VolCBM")) { if (reader["VolCBM"] != DBNull.Value) { volCBM = Convert.ToDecimal(reader["VolCBM"]); } } if (ColumnExists(reader, "weightMT")) { if (reader["weightMT"] != DBNull.Value) { weightMT = Convert.ToDecimal(reader["weightMT"]); } } if (ColumnExists(reader, "revTon")) { if (reader["revTon"] != DBNull.Value) { RevTon = Convert.ToDecimal(reader["revTon"]); } } if (ColumnExists(reader, "fk_FLineID")) { if (reader["fk_FLineID"] != DBNull.Value) { FLineID = Convert.ToInt32(reader["fk_FLineID"]); } } if (ColumnExists(reader, "PlaceOfReceipt")) { if (reader["PlaceOfReceipt"] != DBNull.Value) { PlaceOfReceipt = Convert.ToString(reader["PlaceOfReceipt"]); } } if (ColumnExists(reader, "PlaceOfDelivery")) { if (reader["PlaceOfDelivery"] != DBNull.Value) { PlaceOfDelivery = Convert.ToString(reader["PlaceOfDelivery"]); } } if (ColumnExists(reader, "fk_LPortID")) { if (reader["fk_LPortID"] != DBNull.Value) { fk_LportID = Convert.ToInt32(reader["fk_LPortID"]); } } if (ColumnExists(reader, "fk_DPortID")) { if (reader["fk_DPortID"] != DBNull.Value) { fk_DportID = Convert.ToInt32(reader["fk_DPortID"]); } } if (ColumnExists(reader, "POL")) { if (reader["POL"] != DBNull.Value) { POL = Convert.ToString(reader["POL"]); } } if (ColumnExists(reader, "POD")) { if (reader["POD"] != DBNull.Value) { POD = Convert.ToString(reader["POD"]); } } if (ColumnExists(reader, "fk_CustID")) { if (reader["fk_CustID"] != DBNull.Value) { fk_CustID = Convert.ToInt32(reader["fk_CustID"]); } } if (ColumnExists(reader, "fk_CustAgentID")) { if (reader["fk_CustAgentID"] != DBNull.Value) { fk_CustAgentID = Convert.ToInt32(reader["fk_CustAgentID"]); } } if (ColumnExists(reader, "fk_TransID")) { if (reader["fk_TransID"] != DBNull.Value) { fk_TransID = Convert.ToInt32(reader["fk_TransID"]); } } if (ColumnExists(reader, "fk_OSID")) { if (reader["fk_OSID"] != DBNull.Value) { fk_OSID = Convert.ToInt32(reader["fk_OSID"]); } } if (ColumnExists(reader, "EstPayable")) { if (reader["EstPayable"] != DBNull.Value) { EstPayable = Convert.ToDecimal(reader["EstPayable"]); } } if (ColumnExists(reader, "EstReceivable")) { if (reader["EstReceivable"] != DBNull.Value) { EstReceivable = Convert.ToDecimal(reader["EstReceivable"]); } } if (ColumnExists(reader, "dtAdded")) { if (reader["dtAdded"] != DBNull.Value) { CreatedOn = Convert.ToDateTime(reader["dtAdded"]); } } if (ColumnExists(reader, "UserAdded")) { if (reader["UserAdded"] != DBNull.Value) { CreatedBy = Convert.ToInt32(reader["UserAdded"]); } } if (ColumnExists(reader, "JobStatus")) { if (reader["VoyageStatus"] != DBNull.Value) { JobStatus = Convert.ToBoolean(reader["JobStatus"]); } } if (ColumnExists(reader, "fk_JobScopeID")) { if (reader["fk_JobScopeID"] != DBNull.Value) { JobScopeID = Convert.ToInt32(reader["fk_JobScopeID"]); } } if (ColumnExists(reader, "CargoSource")) { if (reader["CargoSource"] != DBNull.Value) { CargoSource = Convert.ToChar(reader["CargoSource"]); } } if (ColumnExists(reader, "CreditDays")) { if (reader["CreditDays"] != DBNull.Value) { CreditDays = Convert.ToInt32(reader["CreditDays"]); } } if (ColumnExists(reader, "DocumentNo")) { if (reader["DocumentNo"] != DBNull.Value) { DocumentNo = Convert.ToString(reader["DocumentNo"]); } } if (ColumnExists(reader, "Vessel")) { if (reader["Vessel"] != DBNull.Value) { Vessel = Convert.ToString(reader["Vessel"]); } } if (ColumnExists(reader, "Voyage")) { if (reader["Voyage"] != DBNull.Value) { Voyage = Convert.ToString(reader["Voyage"]); } } if (ColumnExists(reader, "JobNote1")) { if (reader["JobNote1"] != DBNull.Value) { JobNote1 = Convert.ToString(reader["JobNote1"]); } } if (ColumnExists(reader, "JobNote2")) { if (reader["JobNote2"] != DBNull.Value) { JobNote2 = Convert.ToString(reader["JobNote2"]); } } if (ColumnExists(reader, "UserConfirmation")) { if (reader["UserConfirmation"] != DBNull.Value) { UserConfirmation = Convert.ToBoolean(reader["UserConfirmation"]); } } if (ColumnExists(reader, "fk_CompID")) { if (reader["fk_CompID"] != DBNull.Value) { CompID = Convert.ToInt32(reader["fk_CompID"]); } } if (ColumnExists(reader, "LocName")) { if (reader["LocName"] != DBNull.Value) { LocName = Convert.ToString(reader["LocName"]); } } if (ColumnExists(reader, "JobActive")) { if (reader["JobActive"] != DBNull.Value) { JobActive = Convert.ToChar(reader["JobActive"]); } } EstProfit = (EstReceivable - EstPayable); }
private void WriteCard() { ResetForm(); CurrentOprt = btnOk.Text; string RefundmentType = "20"; string AmountTitle = label6.Text; double dtm = 0; if (ExistsRefundmentType) { RefundmentType = ((TCommonType)cbbType.Items[cbbType.SelectedIndex]).id; AmountTitle = cbbType.Text; } double money = 0; double.TryParse(CurrencyToStringEx(txtMoney.Text), out money); double moneyBT = 0; double.TryParse(CurrencyToStringEx(txtMoneyBT.Text), out moneyBT); if (money <= 0 && moneyBT <= 0) { Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorMoneyZero", "")); return; } if (SystemInfo.AllowCheckDepositLimit == 3) { if (!IsReadCard) { Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardReadFirst", "")); return; } if (textBox1.Enabled) { int.TryParse(textBox1.Text.Trim(), out Discount); } } else { if (!ReadCard()) { return; } } DateTime dt = new DateTime(); if (!db.GetServerDate(this.Text, ref dt)) { return; } if (!Pub.CheckUseDate(dt, sfData.UseDate)) { return; } Pub.ClearCardLimitInfo(dt, ref sfData); double ShowBTMoney = db.GetBTMoney(sfData.BtDate, sfData.BtMonery); if (!SystemInfo.AllowRefAllowance) { ShowBTMoney = 0; } double AllBalance = sfData.Balance; txtCardBalance.Text = AllBalance.ToString(SystemInfo.CurrencySymbol + "0.00"); double BTBalance = ShowBTMoney; txtBTBalance.Text = BTBalance.ToString(SystemInfo.CurrencySymbol + "0.00"); if (AllBalance < money) { Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorBalanceNotEnough", "")); return; } if (BTBalance < moneyBT) { Pub.ShowErrorMsg(Pub.GetResText(formCode, "ErrorBalanceNotEnough", "")); return; } sfData.UseDate = dt; sfData.UseTimes += 1; List <string> sql = new List <string>(); sql.Clear(); DataTableReader dr = null; string OpterStartDate = ""; string OpterEndDate = ""; DateTime StartDt = new DateTime(); DateTime EndDt = new DateTime(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_001003, new string[] { "251", pubData.CardNo })); while (dr.Read()) { OpterStartDate = ""; OpterEndDate = ""; OpterStartDate = dr["OpterStartDate"].ToString(); OpterEndDate = dr["OpterEndDate"].ToString(); if (OpterStartDate != "") { StartDt = Convert.ToDateTime(OpterStartDate); } if (OpterEndDate != "") { EndDt = Convert.ToDateTime(OpterEndDate); } if (OpterStartDate != "" && OpterEndDate != "") { if (dt > StartDt && dt < EndDt) { break; } } else if (OpterStartDate != "" && OpterEndDate == "") { if (dt > StartDt) { OpterEndDate = dt.ToString(SystemInfo.SQLDateTimeFMT); break; } } } if (OpterStartDate != "") { OpterStartDate = Convert.ToDateTime(OpterStartDate).ToString(SystemInfo.SQLDateTimeFMT); } if (OpterEndDate != "") { OpterEndDate = Convert.ToDateTime(OpterEndDate).ToString(SystemInfo.SQLDateTimeFMT); } if (ShowBTMoney == 0) { sfData.Balance -= money; if (sfData.BtMonery > 0 && SystemInfo.AllowRefAllowance) { double m = -sfData.BtMonery; sql.Add(Pub.GetSQL(DBCode.DB_004005, new string[] { "0", pubData.CardNo, "0", dt.ToString(SystemInfo.SQLDateTimeFMT), "0", sfData.Balance.ToString(), "0", "", "0", sfData.UseTimes.ToString(), OprtInfo.OprtSysID, "", "1", "", CardData10, pubData.MacTAG, "", sfData.BtMonery.ToString(), m.ToString(), "0", "0", OpterStartDate, OpterEndDate })); sfData.UseTimes += 1; sfData.BtMonery = 0; } } else { //double olddtm = sfData.BtMonery; //sfData.BtMonery -= money; //dtm = -money; //if (sfData.BtMonery < 0) //{ // sfData.Balance += sfData.BtMonery; // sfData.BtMonery = 0; // dtm = -olddtm; //} dtm = -moneyBT; sfData.BtMonery -= moneyBT; } double DiscountMoney = 0; double mm = 0; if (SystemInfo.AllowCheckDepositLimit == 2 || SystemInfo.AllowCheckDepositLimit == 3) { if (Discount > 0 && Discount != 100) { DiscountMoney = money * Discount / 100; double x = sfData.Balance + money - DiscountMoney /*+ sfData.BtMonery*/; double xx = -DiscountMoney; sql.Add(Pub.GetSQL(DBCode.DB_004005, new string[] { "0", pubData.CardNo, "21", dt.AddSeconds(-1).ToString(SystemInfo.SQLDateTimeFMT), xx.ToString(), x.ToString(), "0", "", "0", sfData.UseTimes.ToString(), OprtInfo.OprtSysID, "", "1", "", CardData10, pubData.MacTAG, "", dtm.ToString(), sfData.BtMonery.ToString(), "0", OpterStartDate, OpterEndDate })); sfData.UseTimes += 1; mm = -(money - DiscountMoney); } } else { mm = -money; // sfData.Balance -= money; } AllBalance = sfData.Balance + sfData.BtMonery; sql.Add(Pub.GetSQL(DBCode.DB_004005, new string[] { "0", pubData.CardNo, RefundmentType, dt.ToString(SystemInfo.SQLDateTimeFMT), mm.ToString(), sfData.Balance.ToString(), "0", "", "0", sfData.UseTimes.ToString(), OprtInfo.OprtSysID, "", "1", "", CardData10, pubData.MacTAG, "", dtm.ToString(), sfData.BtMonery.ToString(), "0", OpterStartDate, OpterEndDate })); string Title = Pub.GetResText(formCode, "RefundmentTitle", ""); double Amount = money + moneyBT; double ReceivablesAmount = money + moneyBT; double CardBalance = AllBalance; if (SystemInfo.AllowCheckDepositLimit == 3) { string msgX = string.Format("本初取出款总金额,其中,\r\n\r\n退款:{0}元\r\n扣除:{1}元", Math.Abs(mm).ToString(SystemInfo.CurrencySymbol + "0.00"), Math.Abs(DiscountMoney).ToString(SystemInfo.CurrencySymbol + "0.00")); Form frm = new Form(); frm.FormBorderStyle = FormBorderStyle.FixedDialog; frm.MaximizeBox = false; frm.MinimizeBox = false; frm.StartPosition = FormStartPosition.CenterScreen; frm.Width = 600; frm.Height = 360; Label lab = new Label(); lab.Left = 10; lab.Top = 14; lab.Text = msgX; lab.AutoSize = false; lab.Left = 0; lab.Top = 0; lab.Width = frm.ClientSize.Width; lab.Height = frm.ClientSize.Height - 50; lab.TextAlign = ContentAlignment.MiddleCenter; lab.Font = new Font(Font.Name, 20, FontStyle.Bold); int BtnLeft = (lab.Width - 100 * 2 - 20) / 2; Button btnOkX = new Button(); btnOkX.Text = Pub.GetResText("Public", "btnOk", ""); btnOkX.Width = 100; btnOkX.Height = 40; btnOkX.Left = BtnLeft; btnOkX.Top = lab.Top + lab.Height; btnOkX.DialogResult = DialogResult.OK; Button btnCancelX = new Button(); btnCancelX.Text = Pub.GetResText("Public", "btnCancel", ""); btnCancelX.Width = 100; btnCancelX.Height = 40; btnCancelX.Left = BtnLeft + 120; btnCancelX.Top = lab.Top + lab.Height; btnCancelX.DialogResult = DialogResult.Cancel; frm.Controls.Add(lab); frm.Controls.Add(btnOkX); frm.Controls.Add(btnCancelX); if (frm.ShowDialog() != DialogResult.OK) { return; } } if (db.ExecSQL(sql) != 0) { return; } int cardRet = 0; string CardNo10 = ""; string CardNoH = ""; string CardNo8 = ""; bool IsSFError = false; string msg = "[" + txtEmpNo.Text + "]" + txtEmpName.Text + ": " + txtCardSectorNo.Text + "/" + txtDepartName.Text; ContinueSF: Application.DoEvents(); if (IsSFError) { CardNo10 = ""; CardNoH = ""; CardNo8 = ""; if (!Pub.CheckCardExists(ref CardNo10, ref CardNoH, ref CardNo8, false)) { lblResult.Text = Pub.GetResText(formCode, "ReadCardError3", ""); goto ContinueSF; } if (CardNo10 != CardData10) { if (OkContinue) { Pub.ShowErrorMsg(Pub.GetResText(formCode, "MsgCardSame", "") + "\r\n\r\n" + Pub.GetResText(formCode, "MsgCardOkContinue", "")); goto ContinueSF; } else { if (Pub.MessageBoxShowQuestion(Pub.GetResText(formCode, "MsgCardSame", ""))) { return; } else { goto ContinueSF; } } } IsSFError = false; } cardRet = Pub.WriteCardInfo(sfData); if (cardRet != 0) { if (OkContinue) { Pub.ShowErrorMsg(Pub.GetCardMsg(cardRet) + "\r\n\r\n" + Pub.GetResText(formCode, "MsgCardOkContinue", "")); IsSFError = true; goto ContinueSF; } else { if (Pub.MessageBoxShowQuestion(Pub.GetCardMsg(cardRet) + Pub.GetResText(formCode, "MsgContinue", ""))) { return; } else { IsSFError = true; goto ContinueSF; } } } double temp = sfData.Balance + db.GetBTMoney(sfData.BtDate, sfData.BtMonery); double tempBalance = sfData.Balance; double tempBT = db.GetBTMoney(sfData.BtDate, sfData.BtMonery); txtCardBalance.Text = tempBalance.ToString(SystemInfo.CurrencySymbol + "0.00"); txtBTBalance.Text = tempBT.ToString(SystemInfo.CurrencySymbol + "0.00"); Pub.CardBuzzer(); msg = msg + string.Format("[{0:f2},{1:f2}]", Amount, temp); db.WriteSYLog(this.Text, CurrentOprt, msg); DispExtScreen(Amount, temp, 1, 2); if (chkPrint.Checked) { PrintCardBill(Title, Amount, ReceivablesAmount, CardBalance, AmountTitle, pubData.CardNo); } lblResult.Text = this.Text + Pub.GetResText(formCode, "MsgSuccess", ""); }
private void LoadData() { cbbSun.Items.Clear(); cbbMon.Items.Clear(); cbbTue.Items.Clear(); cbbWed.Items.Clear(); cbbThu.Items.Clear(); cbbFri.Items.Clear(); cbbSat.Items.Clear(); cbbSun.Items.Add("0"); cbbMon.Items.Add("0"); cbbTue.Items.Add("0"); cbbWed.Items.Add("0"); cbbThu.Items.Add("0"); cbbFri.Items.Add("0"); cbbSat.Items.Add("0"); DataTableReader dr = null; TIDAndName idn; try { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "400" })); while (dr.Read()) { idn = new TIDAndName(dr["PassTimeID"].ToString(), "[" + dr["PassTimeID"].ToString() + "]" + dr["PassTimeName"].ToString()); cbbSun.Items.Add(idn); cbbMon.Items.Add(idn); cbbTue.Items.Add(idn); cbbWed.Items.Add(idn); cbbThu.Items.Add(idn); cbbFri.Items.Add(idn); cbbSat.Items.Add(idn); } dr.Close(); dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000300, new string[] { "601", SysID })); if (dr.Read()) { txtEmpNo.Text = dr["EmpNo"].ToString(); txtEmpName.Text = dr["EmpName"].ToString(); txtDepartName.Text = dr["DepartName"].ToString(); SetTimeIndex(cbbSun, dr["SunID"].ToString()); SetTimeIndex(cbbMon, dr["MonID"].ToString()); SetTimeIndex(cbbTue, dr["TueID"].ToString()); SetTimeIndex(cbbWed, dr["WedID"].ToString()); SetTimeIndex(cbbThu, dr["ThuID"].ToString()); SetTimeIndex(cbbFri, dr["FriID"].ToString()); SetTimeIndex(cbbSat, dr["SatID"].ToString()); DateTime d = new DateTime(); if (DateTime.TryParse(dr["StartDate"].ToString(), out d)) { txtStartDate.Text = d.ToShortDateString(); } if (DateTime.TryParse(dr["EndDate"].ToString(), out d)) { txtEndDate.Text = d.ToShortDateString(); } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } }
public void SeeTheModifiedTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row _dt.Rows[1]["name"] = "mono changed"; reader.Read(); string value = reader[1].ToString(); Assert.Equal("mono changed", value); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
protected override void InitForm() { formCode = "SFMobileCheck"; retGrid.Columns.Clear(); AddColumn(retGrid, 0, "RecordNo", false, true, 1, 60); AddColumn(retGrid, 0, "OrderNo", false, true, 1, 200); AddColumn(retGrid, 0, "OrderTime", false, true, 1, 130); AddColumn(retGrid, 0, "PayTime", false, true, 1, 130); AddColumn(retGrid, 1, "IsWX", false, true, 1, 70); AddColumn(retGrid, 0, "Amount", false, true, 1, 70); AddColumn(retGrid, 0, "OrderRemark", false, true, 1, 270); base.InitForm(); for (int i = 0; i < retGrid.ColumnCount; i++) { retGrid.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } this.Text = Pub.GetResText(formCode, "mnu" + formCode, "", new string[] { "Main" }); dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); dtpEnd.Value = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59); if (StartTime != "") { dtpStart.Value = DateTime.Parse(StartTime); dtpEnd.Value = DateTime.Parse(EndTime); } dtpStart.CustomFormat = SystemInfo.DateTimeFormat; dtpEnd.CustomFormat = SystemInfo.DateTimeFormat; UserList.Clear(); List <string> SysID = new List <string>(); TMobileInfo info = new TMobileInfo(""); //info.MobTyp = 1; //UserList.Add(info); DataTableReader dr = null; string s1 = ""; string s2 = ""; try { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "0" })); while (dr.Read()) { SysID.Add(dr["MacSysID"].ToString()); } for (int i = 0; i < SysID.Count; i++) { dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "7", SysID[i] })); if (dr.Read()) { s1 = dr["MobileInfo"].ToString(); if (s1 == "") { continue; } info = new TMobileInfo(s1); if (UserList.Count > 0) { s1 = UserList[UserList.Count - 1].XJLName + UserList[UserList.Count - 1].XJLPWD; s2 = info.XJLName + info.XJLPWD; if (UserList[UserList.Count - 1].MobTyp == 1 && s1 != s2) { UserList.Add(info); } } else { UserList.Add(info); i = 0; } } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } clbUserInfo.Items.Clear(); for (int i = 0; i < UserList.Count; i++) { info = UserList[i]; s1 = info.XJLName + "[" + info.XJLPWD + "]\r\n"; clbUserInfo.Items.Add(s1); clbUserInfo.SetItemChecked(clbUserInfo.Items.Count - 1, true); } }
public void MultipleResultSetsTest() { DataTable dt1 = new DataTable("test2"); dt1.Columns.Add("x", typeof(string)); dt1.Rows.Add(new object[] { "test" }); dt1.Rows.Add(new object[] { "test1" }); dt1.AcceptChanges(); DataTable[] collection = new DataTable[] { _dt, dt1 }; DataTableReader reader = new DataTableReader(collection); try { int i = 0; do { while (reader.Read()) i++; } while (reader.NextResult()); Assert.Equal(5, i); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public MenuModels ObtenerMenu2(MenuModels Datos) { try { DataSet Ds = SqlHelper.ExecuteDataset(Datos.Conexion, "spCSLDB_get_Menu", Datos.User, Datos.TipoMenu); if (Ds != null) { if (Ds.Tables.Count == 1) { List <MenuModels> ListaPrinc = new List <MenuModels>(); MenuModels Item; DataTableReader DTR = Ds.Tables[0].CreateDataReader(); DataTable Tbl1 = Ds.Tables[0]; while (DTR.Read()) { Item = new MenuModels(); Item.ListaMenuDetalle = new List <MenuModels>(); Item.MenuID = !DTR.IsDBNull(DTR.GetOrdinal("MenuID")) ? DTR.GetInt32(DTR.GetOrdinal("MenuID")) : 0; Item.NombreMenu = !DTR.IsDBNull(DTR.GetOrdinal("NombreMenu")) ? DTR.GetString(DTR.GetOrdinal("NombreMenu")) : string.Empty; Item.OrdenMenu = !DTR.IsDBNull(DTR.GetOrdinal("OrdenMenu")) ? DTR.GetInt32(DTR.GetOrdinal("OrdenMenu")) : 0; Item.IconMenu = !DTR.IsDBNull(DTR.GetOrdinal("Icon")) ? DTR.GetString(DTR.GetOrdinal("Icon")) : string.Empty; Item.UrlMenu = !DTR.IsDBNull(DTR.GetOrdinal("UrlMenu")) ? DTR.GetString(DTR.GetOrdinal("UrlMenu")) : string.Empty; //Item.IDFranquicia = !DTR.IsDBNull(0) ? DTR.GetString(0) : string.Empty; //Item.Descripcion = !DTR.IsDBNull(1) ? DTR.GetString(1) : string.Empty; //string Aux = DTR.GetString(2); string Aux = !DTR.IsDBNull(DTR.GetOrdinal("TablaSubMenu")) ? DTR.GetString(DTR.GetOrdinal("TablaSubMenu")) : string.Empty; Aux = string.Format("<Main>{0}</Main>", Aux); XmlDocument xm = new XmlDocument(); xm.LoadXml(Aux); XmlNodeList Registros = xm.GetElementsByTagName("Main"); XmlNodeList Lista = ((XmlElement)Registros[0]).GetElementsByTagName("C"); List <MenuModels> ListaAux = new List <MenuModels>(); MenuModels ItemAux; foreach (XmlElement Nodo in Lista) { ItemAux = new MenuModels(); XmlNodeList MenuID = Nodo.GetElementsByTagName("MenuID"); XmlNodeList NombreMenu = Nodo.GetElementsByTagName("NombreMenu"); XmlNodeList MenuUrl = Nodo.GetElementsByTagName("MenuUrl"); XmlNodeList MenuIcon = Nodo.GetElementsByTagName("Icono"); ItemAux.MenuID = Convert.ToInt32(MenuID[0].InnerText); ItemAux.NombreMenu = NombreMenu[0].InnerText; ItemAux.UrlMenu = MenuUrl[0].InnerText; ItemAux.IconMenu = MenuIcon[0].InnerText; Item.ListaMenuDetalle.Add(ItemAux); } ListaPrinc.Add(Item); } DTR.Close(); Datos.ListaMenu = ListaPrinc; } } return(Datos); } catch (Exception ex) { throw ex; } }
public void CloseTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { int i = 0; while (reader.Read() && i < 1) i++; reader.Close(); reader.Read(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
public MenuModels ObtenerPermisoUsuario(MenuModels Datos) { try { DataSet Ds = SqlHelper.ExecuteDataset(Datos.Conexion, "spCSLDB_get_PermisosXID", Datos.User); if (Ds != null) { if (Ds.Tables.Count == 1) { List <MenuModels> ListaPrinc = new List <MenuModels>(); MenuModels Item; DataTableReader DTR = Ds.Tables[0].CreateDataReader(); DataTable Tbl1 = Ds.Tables[0]; while (DTR.Read()) { Item = new MenuModels(); Item.ListaPermisoDetalle = new List <MenuModels>(); Item.IDPermiso = !DTR.IsDBNull(DTR.GetOrdinal("IDPermiso")) ? DTR.GetString(DTR.GetOrdinal("IDPermiso")) : string.Empty; Item.MenuID = !DTR.IsDBNull(DTR.GetOrdinal("MenuID")) ? DTR.GetInt32(DTR.GetOrdinal("MenuID")) : 0; Item.NombreMenu = !DTR.IsDBNull(DTR.GetOrdinal("NombreMenu")) ? DTR.GetString(DTR.GetOrdinal("NombreMenu")) : string.Empty; Item.ver = DTR.GetBoolean(DTR.GetOrdinal("ver")); //string Aux = DTR.GetString(2); string Aux = !DTR.IsDBNull(DTR.GetOrdinal("TablaPermiso")) ? DTR.GetString(DTR.GetOrdinal("TablaPermiso")) : string.Empty; Aux = string.Format("<Main>{0}</Main>", Aux); XmlDocument xm = new XmlDocument(); xm.LoadXml(Aux); XmlNodeList Registros = xm.GetElementsByTagName("Main"); XmlNodeList Lista = ((XmlElement)Registros[0]).GetElementsByTagName("C"); List <MenuModels> ListaAux = new List <MenuModels>(); MenuModels ItemAux; foreach (XmlElement Nodo in Lista) { ItemAux = new MenuModels(); XmlNodeList MenuID = Nodo.GetElementsByTagName("MenuID"); XmlNodeList NombreMenu = Nodo.GetElementsByTagName("NombreMenu"); XmlNodeList ver = Nodo.GetElementsByTagName("ver"); XmlNodeList IDPermiso = Nodo.GetElementsByTagName("IDPermiso"); ItemAux.MenuID = Convert.ToInt32(MenuID[0].InnerText); ItemAux.NombreMenu = NombreMenu[0].InnerText; int Visto = 0; int.TryParse(ver[0].InnerText, out Visto); if (Visto == 1) { ItemAux.ver = true; } else { Item.ver = false; } ItemAux.IDPermiso = IDPermiso[0].InnerText; Item.ListaPermisoDetalle.Add(ItemAux); } ListaPrinc.Add(Item); } DTR.Close(); Datos.ListaPermisos = ListaPrinc; } } return(Datos); } catch (Exception ex) { throw ex; } }
public void NoRowsTest() { _dt.Rows.Clear(); _dt.AcceptChanges(); DataTableReader reader = new DataTableReader(_dt); try { Assert.False(reader.Read()); Assert.False(reader.NextResult()); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { /* Obtendo campos do modelo*/ if (comboBox1.SelectedIndex != 0) { SqlConnection conSql = new SqlConnection(ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString"].ConnectionString); SqlCommand comSql = new SqlCommand("select * from modelocampo where idModelo = (select id from modelo where estrutura = '" + comboBox1.Text.Substring(0, comboBox1.Text.Length - 13) + "')", conSql); conSql.Open(); SqlDataReader read = comSql.ExecuteReader(); if (read.HasRows) { int y = 0; string camp = ""; foreach (var item in read) { camp += read["campo"].ToString() + ";"; y++; } campos = camp.Split(';'); read.Close(); read.Dispose(); comSql.CommandText = "select algoritmo from modelo where estrutura = '" + comboBox1.Text.Substring(0, comboBox1.Text.Length - 13) + "'"; read = comSql.ExecuteReader(); read.Read(); if (read["algoritmo"].ToString() == "MTS (Microsoft Time Serial)") { int x = 0; AdomdConnection conn = new AdomdConnection(ConfigurationManager.ConnectionStrings["Comercial.Properties.Settings.COMERCIALConnectionString_Analysis"].ConnectionString); AdomdCommand comand = new AdomdCommand(); conn.Open(); comand.Connection = conn; comand.CommandText = "SELECT StructureColumn('" + campos[0].Trim() + "'),StructureColumn('" + campos[1].Trim() + "') " + "FROM " + comboBox1.Text.Substring(0, comboBox1.Text.Length - 13) + ".CASES"; AdomdDataAdapter ad = new AdomdDataAdapter(comand); table.Clear(); ad.Fill(table); DataTableReader reader = table.CreateDataReader(); // read.Read(); string valores = ""; foreach (var item in reader) { valores += reader[1].ToString() + ","; } valores = valores.Substring(0, valores.Length - 1); try { //chartHist.Clear(); chartHist.Charts[0].SeriesCollection.Delete(0); chartHist.Charts.Delete(0); chartHist.Refresh(); } catch { } chartHist.ResetText(); chartHist.Charts.Add(0); chartHist.Charts[0].SeriesCollection.Add(0); chartHist.Charts[0].Type = OWC11.ChartChartTypeEnum.chChartTypeLine; chartHist.Charts[0].SeriesCollection[0].SetData(OWC11.ChartDimensionsEnum.chDimSeriesNames, Convert.ToInt32(OWC11.ChartSpecialDataSourcesEnum.chDataLiteral), "Quantidade"); chartHist.Charts[0].SeriesCollection[0].SetData(OWC11.ChartDimensionsEnum.chDimValues, Convert.ToInt32(OWC11.ChartSpecialDataSourcesEnum.chDataLiteral), valores); chartHist.Refresh(); } } carregaGrid(); } }
public void ReadAfterClosedTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); reader.Close(); reader.Read(); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
private void btnOK_Click(object sender, EventArgs e) { string Value = ""; string Number = " "; string NumberofTable = " "; string EquipmentNo = " "; string EquipmentName = " "; string NumberName = " "; string Truckid = " "; string IsMaintenance = " "; string TotalUsed = " "; string Trucktype = " "; string main = ""; //Enter Equipment No Or Plate No./Model Name /* * if (rdEqpNo.Checked) * { * Value = "EquipmentNo"; * } * else * { * Value = "ModelName"; * } */ Value = "EquipmentNo"; Number = txtEnternumber.Text; if (Number == " " || Number == "" || Number == null) { MessageBox.Show("Please Enter Equipment No Or Plate No./Model Name"); } else { DialogResult dialogResult = MessageBox.Show("Please Click Yes to Continue", "Search", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { DataSet dsKey = GenericFunc.DataSetFromMSSQL(Connection, ("exec sp_Get_InfoAndMonitoring '" + Value + "'," + "'" + Number + "'")); DataTableReader drKey = dsKey.Tables[0].CreateDataReader(); if (drKey.Read()) { NumberofTable = dsKey.Tables[0].Rows[0]["NumberofTable"].ToString(); main = dsKey.Tables[0].Rows[0]["maintable"].ToString(); if (NumberofTable == "0") { MessageBox.Show("Record Not Found. Please check Equipment No Or Plate No./Model Name."); } else { if (main != "0") { IsMaintenance = dsKey.Tables[1].Rows[0]["IsMaintenance"].ToString(); TotalUsed = dsKey.Tables[1].Rows[0]["TotalUsed"].ToString(); EquipmentNo = dsKey.Tables[2].Rows[0]["EquipmentNo"].ToString(); EquipmentName = dsKey.Tables[2].Rows[0]["Model"].ToString(); NumberName = dsKey.Tables[2].Rows[0]["PlateNo"].ToString(); Truckid = dsKey.Tables[2].Rows[0]["TruckId"].ToString(); Trucktype = dsKey.Tables[2].Rows[0]["Trucktype"].ToString(); AddMonitoring monitoring = new AddMonitoring(); monitoring.Param(EquipmentNo, EquipmentName, NumberName, Truckid, dsKey.Tables[3], NumberofTable, Value, TotalUsed, IsMaintenance, formtype, Trucktype); this.Hide(); monitoring.ShowDialog(this); this.Close(); } else { MessageBox.Show("Record Not Found. Please check Equipment No Or Plate No./Model Name."); } } } else { } } } }
public void InvalidIndexTest() { Assert.Throws<ArgumentOutOfRangeException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); int i = (int)reader[90]; // kidding, ;-) i++; // to supress warning } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
private void LoadData() { DataTableReader dr = null; string consStr = ""; for (int i = 1; i < dataGrid.ColumnCount; i++) { switch (i) { case 1: case 4: case 7: case 10: case 13: case 16: case 19: case 22: case 25: case 28: ((DataGridViewComboBoxColumn)dataGrid.Columns[i]).Items.Clear(); ((DataGridViewComboBoxColumn)dataGrid.Columns[i]).Items.Add(""); ((DataGridViewComboBoxColumn)dataGrid.Columns[i]).Items.Add("Y"); ((DataGridViewComboBoxColumn)dataGrid.Columns[i]).Items.Add("N"); break; case 2: case 5: case 8: case 11: case 14: case 17: case 20: case 23: case 26: case 29: ((DataGridViewComboBoxColumn)dataGrid.Columns[i]).Items.Clear(); ((DataGridViewComboBoxColumn)dataGrid.Columns[i]).Items.Add(""); break; } } sfTypeList.Clear(); try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "108" })); while (dr.Read()) { sfTypeList.Add(new TCommonType(dr["SFTypeSysID"].ToString(), dr["SFTypeID"].ToString(), dr["SFTypeName"].ToString(), true)); for (int i = 2; i < dataGrid.ColumnCount; i++) { switch (i) { case 2: case 5: case 8: case 11: case 14: case 17: case 20: case 23: case 26: case 29: ((DataGridViewComboBoxColumn)dataGrid.Columns[i]).Items.Add(dr["SFTypeName"].ToString()); break; } } } dr.Close(); dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004004, new string[] { "7", SysID })); if (dr.Read()) { consStr = dr["ConsumptionWay"].ToString(); } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } SFConsumptionWay way = new SFConsumptionWay(consStr); rbTime.Checked = way.Way == 1; rbDay.Checked = way.Way == 2; chkAlarm.Checked = way.TwoBJ == 1; string v = ""; for (int i = 0; i < dataGrid.RowCount; i++) { string[] tmp = way.CardTypeTime[i].Split(' '); int i1 = 0; int i2 = 24; if (rbDay.Checked) { i1 = 24; i2 = 30; } for (int j = i1; j < i2; j++) { if (rbDay.Checked) { dataGrid[j + 1, i].Value = tmp[j - i1] == "*" ? "" : tmp[j - i1]; } else { dataGrid[j + 1, i].Value = tmp[j] == "*" ? "" : tmp[j]; } switch (j + 1) { case 1: case 4: case 7: case 10: case 13: case 16: case 19: case 22: case 25: case 28: if (rbTime.Checked) { dataGrid.Columns[j + 1].Width = 40; } if (rbDay.Checked) { v = tmp[j - i1] == "*" ? "" : tmp[j - i1]; } else { v = tmp[j] == "*" ? "" : tmp[j]; } dataGrid[j + 1, i].Value = v.ToUpper(); break; case 3: case 6: case 9: case 12: case 15: case 18: case 21: case 24: case 27: case 30: if (rbTime.Checked) { dataGrid.Columns[j + 1].Width = 60; } if (dataGrid[j + 1, i].Value.ToString() != "") { v = CurrencyToStringEx(dataGrid[j + 1, i].Value.ToString()); v = Convert.ToDecimal(v) <= 0 ? "1" : v; dataGrid[j + 1, i].Value = CurrencyToString(v); } break; default: if (rbTime.Checked) { dataGrid.Columns[j + 1].Width = 70; } if (dataGrid[j + 1, i].Value.ToString() != "") { dataGrid[j + 1, i].Value = GetSFTypeName(dataGrid[j + 1, i].Value.ToString()); } break; } } } RadioButton_Click(null, null); }
public void AddAtPointTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); // second row DataRow r = _dt.NewRow(); r[0] = 0; r[1] = "same point"; _dt.Rows.InsertAt(r, 1); _dt.Rows.Add(new object[] { 4, "mono 4" }); // should not affect the counter Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
public List <UsuarioDTO> ListarUsuario(UsuarioDTO usuario) { DataSet dataSet = new DataSet(); List <UsuarioDTO> lstUsuario = new List <UsuarioDTO>(); var connection = conexao.CriaConexao(); conexao.AbrirConexao(connection); SqlCommand command = new SqlCommand("USUARIO_SELECIONAR", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Id_Usuario", usuario.CodigoUsuario); command.Parameters.AddWithValue("@Nome", (!String.IsNullOrEmpty(usuario.Nome)) ? usuario.Nome.Trim().ToUpper() : ""); command.Parameters.AddWithValue("@Sobrenome", (!String.IsNullOrEmpty(usuario.Sobrenome)) ? usuario.Sobrenome.Trim().ToUpper() : ""); command.Parameters.AddWithValue("@Email", (!String.IsNullOrEmpty(usuario.Email)) ? usuario.Email.Trim().ToUpper() : ""); command.Parameters.AddWithValue("@Username", (!String.IsNullOrEmpty(usuario.Username)) ? usuario.Username.Trim().ToUpper() : ""); command.Parameters.AddWithValue("@Senha", (!String.IsNullOrEmpty(usuario.Senha)) ? usuario.Senha : ""); command.Parameters.AddWithValue("@Ativo", StringAtivo(usuario.Ativo)); SqlTransaction transaction = connection.BeginTransaction(); command.Connection = connection; command.Transaction = transaction; try { SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataSet); DataTableReader reader = dataSet.Tables[0].CreateDataReader(); while (reader.Read()) { lstUsuario.Add(new UsuarioDTO() { CodigoUsuario = (int)reader["ID_USUARIO"], Nome = reader["NOME"].ToString(), Sobrenome = reader["SOBRENOME"].ToString(), Email = reader["EMAIL"].ToString(), Username = reader["USERNAME"].ToString(), Senha = reader["SENHA"].ToString(), Ativo = reader.GetBoolean(reader.GetOrdinal("ATIVO")) }); } transaction.Commit(); } catch (Exception ex) { try { transaction.Rollback(); throw new Exception(ex.Message); } catch (Exception ex2) { throw new Exception(ex2.Message); } } finally { conexao.FecharConexao(connection); } return(lstUsuario); }
public void DeleteFirstCurrentAndAcceptChangesTest() { Assert.Throws<InvalidOperationException>(() => { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row _dt.Rows[0].Delete(); // delete row, where reader points to _dt.AcceptChanges(); // accept the action Assert.Equal(2, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }); }
private void InitParam() { DataTableReader dr = null; string DoorMagnetic_Type = ""; string Anti_back = ""; string Use_Alarm = ""; string Wiegand_Output = ""; string Wiegand_Input = ""; if (MacSN == "") { if (cbbMacSN.Items.Count > 0) { cbbMacSN.SelectedIndex = 0;//机器号1-255 } DefaultControl(); } else { cbbMacSN.Text = MacSN; dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN })); if (dr.Read()) { cbbGlogWarning.Text = dr["GlogWarning"].ToString(); cbbDoorMagneticDelay.Text = dr["DoorMagneticDelay"].ToString(); cbbAlarmDelay.Text = dr["AlarmDelay"].ToString(); cbbOpenDoorDelay.Text = dr["OpenDoorDelay"].ToString(); cbbManagers.Text = dr["Managers"].ToString(); cbbVolume.Text = dr["Volume"].ToString(); cbbMutiUser.Text = dr["MutiUser"].ToString(); cbbShowResultTime.Text = dr["ShowResultTime"].ToString(); cbbReverifyTime.Text = dr["ReverifyTime"].ToString(); cbbScreensaversTime.Text = dr["ScreensaversTime"].ToString(); cbbSleepTime.Text = dr["SleepTime"].ToString(); cbbWiegandType.Text = dr["WiegandType"].ToString(); Wiegand_Output = dr["WiegandOutput"].ToString(); Wiegand_Input = dr["WiegandInput"].ToString(); DoorMagnetic_Type = dr["DoorMagneticType"].ToString(); if (DoorMagnetic_Type == "no") { cbbDoorMagneticType.Text = DoorMagnetic_TypeAll; } else if (DoorMagnetic_Type == "close") { cbbDoorMagneticType.Text = Pub.GetResText(formCode, "close", ""); } else { cbbDoorMagneticType.Text = Pub.GetResText(formCode, "open", ""); } Anti_back = dr["Antiback"].ToString(); if (Anti_back == "no") { cbbAntiback.Text = Anti_backAll; } else { cbbAntiback.Text = Pub.GetResText(formCode, "yes", ""); } Use_Alarm = dr["UseAlarm"].ToString(); if (Use_Alarm == "yes") { cbbUseAlarm.Text = Use_AlarmAll; } else { cbbUseAlarm.Text = Pub.GetResText(formCode, "no", ""); } if (Wiegand_Input == "1") { cbbWiegandInput.Text = Pub.GetResText(formCode, "CardNo", ""); } else { cbbWiegandInput.Text = Pub.GetResText(formCode, "EmpNoParam", ""); } if (Wiegand_Output == "1") { cbbWiegandOutput.Text = Pub.GetResText(formCode, "CardNo", ""); } else { cbbWiegandOutput.Text = Pub.GetResText(formCode, "EmpNoParam", ""); } Application.DoEvents(); } } }
private void btnOk_Click(object sender, EventArgs e) { string DoorMagnetic_Type = ""; string Anti_back = ""; string ServerRequest = ""; string Use_Alarm = ""; string Glog_Warning = ""; string DoorMagnetic_Delay = ""; string Alarm_Delay = ""; string OpenDoor_Delay = ""; string Managers = ""; string Volume = ""; string MutiUser = ""; string Show_ResultTime = ""; string Reverify_Time = ""; string Screensavers_Time = ""; string Sleep_Time = ""; string Wiegand_Type = ""; string Wiegand_Output = ""; string Wiegand_Input = ""; string ServerIPAddress = ""; string ServerPort = ""; List <string> sql = new List <string>(); string msg = ""; bool ret = true; string Err = ""; Glog_Warning = cbbGlogWarning.Text.Trim(); DoorMagnetic_Delay = cbbDoorMagneticDelay.Text.Trim(); Alarm_Delay = cbbAlarmDelay.Text.Trim(); string DiMacNo = cbbMacSN.Text.Trim(); OpenDoor_Delay = cbbOpenDoorDelay.Text.Trim(); Managers = cbbManagers.Text.Trim(); Volume = cbbVolume.Text.Trim(); MutiUser = cbbMutiUser.Text.Trim(); Show_ResultTime = cbbShowResultTime.Text.Trim(); Reverify_Time = cbbReverifyTime.Text.Trim(); Screensavers_Time = cbbScreensaversTime.Text.Trim(); Sleep_Time = cbbSleepTime.Text.Trim(); Wiegand_Type = cbbWiegandType.Text.Trim(); Application.DoEvents(); if (int.Parse(Managers) > 10 || int.Parse(Managers) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label1.Text, 0, 10); Pub.MessageBoxShow(Err); cbbManagers.Focus(); return; } if (int.Parse(Volume) > 10 || int.Parse(Volume) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label2.Text, 0, 10); Pub.MessageBoxShow(Err); cbbVolume.Focus(); return; } if (int.Parse(Glog_Warning) > 1000 || int.Parse(Glog_Warning) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label4.Text, 0, 1000); Pub.MessageBoxShow(Err); cbbGlogWarning.Focus(); return; } if (int.Parse(Show_ResultTime) > 30 || int.Parse(Show_ResultTime) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label3.Text, 0, 30); Pub.MessageBoxShow(Err); cbbShowResultTime.Focus(); return; } if (int.Parse(Reverify_Time) > 60 || int.Parse(Reverify_Time) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label5.Text, 0, 60); Pub.MessageBoxShow(Err); cbbReverifyTime.Focus(); return; } if (int.Parse(Screensavers_Time) > 1440 || int.Parse(Screensavers_Time) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label6.Text, 0, 1440); Pub.MessageBoxShow(Err); cbbScreensaversTime.Focus(); return; } if (int.Parse(Sleep_Time) > 60 || int.Parse(Sleep_Time) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label7.Text, 0, 60); Pub.MessageBoxShow(Err); cbbSleepTime.Focus(); return; } if (int.Parse(OpenDoor_Delay) > 200 || int.Parse(OpenDoor_Delay) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label14.Text, 0, 200); Pub.MessageBoxShow(Err); cbbOpenDoorDelay.Focus(); return; } if (int.Parse(MutiUser) > 10 || int.Parse(MutiUser) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label13.Text, 0, 10); Pub.MessageBoxShow(Err); cbbMutiUser.Focus(); return; } if (int.Parse(DoorMagnetic_Delay) > 200 || int.Parse(DoorMagnetic_Delay) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label15.Text, 0, 200); Pub.MessageBoxShow(Err); cbbDoorMagneticDelay.Focus(); return; } if (int.Parse(Alarm_Delay) > 255 || int.Parse(Alarm_Delay) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label14.Text, 0, 255); Pub.MessageBoxShow(Err); cbbAlarmDelay.Focus(); return; } if (int.Parse(DiMacNo) > 255 || int.Parse(DiMacNo) < 0) { Err = string.Format(Pub.GetResText(formCode, "Error", ""), label9.Text, 0, 255); Pub.MessageBoxShow(Err); cbbMacSN.Focus(); return; } Wiegand_Output = cbbWiegandOutput.Text.Trim(); Wiegand_Input = cbbWiegandInput.Text.Trim(); if (Wiegand_Output == Pub.GetResText(formCode, "CardNo", "")) { Wiegand_Output = "1"; } else { Wiegand_Output = "0"; } if (Wiegand_Input == Pub.GetResText(formCode, "CardNo", "")) { Wiegand_Input = "1"; } else { Wiegand_Input = "0"; } DoorMagnetic_Type = cbbDoorMagneticType.Text.Trim(); Anti_back = cbbAntiback.Text.Trim(); Use_Alarm = cbbUseAlarm.Text.Trim(); if (DoorMagnetic_Type == DoorMagnetic_TypeAll) { DoorMagnetic_Type = "no"; } else if (DoorMagnetic_Type == Pub.GetResText(formCode, "close", "")) { DoorMagnetic_Type = "close"; } else { DoorMagnetic_Type = "open"; } if (Anti_back == Anti_backAll) { Anti_back = "no"; } else { Anti_back = "yes"; } if (ServerRequest == ServerRequestAll) { ServerRequest = "0"; } else { ServerRequest = "1"; } if (Use_Alarm == Use_AlarmAll) { Use_Alarm = "yes"; } else { Use_Alarm = "no"; } DataTableReader dr = null; if (AddList.Count > 0) { for (int i = 0; i < AddList.Count; i++) { MacSN = AddList[i].ToString(); dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN })); if (dr.Read()) { continue; } else { sql.Add(Pub.GetSQL(DBCode.DB_000002, new string[] { "202", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, MacSN, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input })); } } } else if (ConnList.Count > 0) { for (int i = 0; i < ConnList.Count; i++) { MacSN = ConnList[i].MacSN.ToString(); dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN })); if (dr.Read()) { sql.Add(Pub.GetSQL(DBCode.DB_000002, new string[] { "203", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, MacSN, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input })); } else { sql.Add(Pub.GetSQL(DBCode.DB_000002, new string[] { "202", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, MacSN, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input })); } } } else if (MacSN == "") { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", DiMacNo })); if (dr.Read()) { msg = string.Format(Pub.GetResText("", "ErrorCannotRepeated", ""), label9.Text); Pub.MessageBoxShow(msg, MessageBoxIcon.Error); return; } else { sql.Add(Pub.GetSQL(DBCode.DB_000002, new string[] { "202", DiMacNo, DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, DiMacNo, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input })); } } else { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN })); if (dr.Read()) { sql.Add(Pub.GetSQL(DBCode.DB_000002, new string[] { "203", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, DiMacNo, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input })); } else { sql.Add(Pub.GetSQL(DBCode.DB_000002, new string[] { "202", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest, Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, DiMacNo, OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort, Wiegand_Output, Wiegand_Input })); } } try { SystemInfo.db.ExecSQL(sql); } catch (Exception E) { ret = false; Pub.ShowErrorMsg(E, sql); } finally { if (dr != null) { dr.Close(); } dr = null; } if (ret) { msg = Pub.GetResText(formCode, "MsgSaveSucceed", ""); } else { msg = Pub.GetResText(formCode, "MsgSaveFail", ""); } Pub.MessageBoxShow(msg); SystemInfo.db.WriteSYLog(Title, CurrentOprt, msg); Application.DoEvents(); this.DialogResult = DialogResult.OK; this.Close(); }
private void btnOk_Click(object sender, EventArgs e) { string RuleNo = txtGZRuleID.Text.Trim(); string RuleName = txtGZRuleName.Text.Trim(); string RuleMode = cbbmode.SelectedIndex.ToString(); string RuleCash = CurrencyToStringEx(txtGZRuleCash.Text.Trim()); string IsFunction = Convert.ToByte(chkIsFunction.Checked).ToString(); string RuleFunction = ""; string VRuleFunction = ""; for (int i = 0; i < func.Count; i++) { //if (typeof(TIDAndName) == func[i].GetType()) if (f.IsMatch(func[i].ToString()) || isnumber.IsMatch(func[i].ToString())) { RuleFunction += func[i].ToString(); } else { RuleFunction += ((TIDAndName)func[i]).id; } VRuleFunction += func[i].ToString(); } if (RuleNo == "") { txtGZRuleID.Focus(); ShowErrorEnterCorrect(lblGZRuleID.Text); return; } if (RuleName == "") { txtGZRuleName.Focus(); ShowErrorEnterCorrect(lblGZRuleName.Text); return; } if (chkIsFunction.Checked && !checkIsOK()) { return; } if (RuleCash == "") { RuleCash = "0.00"; } if (!Pub.IsNumeric(RuleCash)) { ShowErrorEnterCorrect(lblGZRuleCash.Text); return; } if (chkIsFunction.Checked) { RuleCash = "0.00"; } else { VRuleFunction = ""; RuleFunction = ""; } DataTableReader dr = null; bool IsOk = true; string sql = ""; try { if (IsAdd) { dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000400, new string[] { "2", RuleNo })); if (dr.Read()) { txtGZRuleID.Focus(); ShowErrorCannotRepeated(lblGZRuleID.Text); IsOk = false; } dr.Close(); if (IsOk) { sql = Pub.GetSQL(DBCode.DB_000400, new string[] { "3", RuleNo, RuleName, RuleMode, IsFunction, RuleCash, RuleFunction, VRuleFunction }); } } else { sql = Pub.GetSQL(DBCode.DB_000400, new string[] { "4", RuleName, RuleMode, IsFunction, RuleCash, RuleFunction, VRuleFunction, RuleNo }); } if (IsOk) { SystemInfo.db.ExecSQL(sql); } } catch (Exception E) { IsOk = false; Pub.ShowErrorMsg(E, sql); } finally { if (dr != null) { dr.Close(); } dr = null; } if (IsOk) { SystemInfo.db.WriteSYLog(this.Text, CurrentOprt, sql); //Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); } }
public void MultipleDeleteTest() { _dt.Rows.Add(new object[] { 4, "mono 4" }); _dt.Rows.Add(new object[] { 5, "mono 5" }); _dt.Rows.Add(new object[] { 6, "mono 6" }); _dt.Rows.Add(new object[] { 7, "mono 7" }); _dt.Rows.Add(new object[] { 8, "mono 8" }); _dt.AcceptChanges(); DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row reader.Read(); reader.Read(); reader.Read(); reader.Read(); _dt.Rows[3].Delete(); _dt.Rows[1].Delete(); _dt.Rows[2].Delete(); _dt.Rows[0].Delete(); _dt.Rows[6].Delete(); _dt.AcceptChanges(); Assert.Equal(5, (int)reader[0]); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
private void btnOk_Click(object sender, EventArgs e) { int ProdID = 0; if (Pub.IsNumeric(txtNo.Text.Trim())) { ProdID = Convert.ToInt32(txtNo.Text.Trim()); } string ProdName = txtName.Text.Trim(); string Price = CurrencyToStringEx(txtPrice.Text); string CategoryName = txtCategory.Text; string CategoryID = txtCategory.Tag.ToString(); DataTableReader dr = null; bool IsOk = false; string sql = ""; if (!Pub.CheckTextMaxLength(Label2.Text, ProdName, txtName.MaxLength)) { return; } if ((ProdID < 1) || (ProdID > 9999)) { txtNo.Focus(); ShowErrorEnterCorrect(Label1.Text); return; } if (CategoryName == "") { txtName.Focus(); ShowErrorEnterCorrect(label6.Text); return; } if (ProdName == "") { txtName.Focus(); ShowErrorEnterCorrect(Label2.Text); return; } if (Convert.ToDecimal(Price) <= 0) { txtPrice.Focus(); Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", "")); return; } try { if (!db.IsOpen) { db.Open(SystemInfo.ConnStr); } if (SysID == "") { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004003, new string[] { "5", ProdID.ToString(), CategoryID })); if (dr.Read()) { txtNo.Focus(); ShowErrorCannotRepeated(Label1.Text); } else { sql = Pub.GetSQL(DBCode.DB_004003, new string[] { "1", ProdID.ToString(), ProdName, Price, CategoryID, CategoryName }); db.ExecSQL(sql); IsOk = true; } } else { dr = db.GetDataReader(Pub.GetSQL(DBCode.DB_004003, new string[] { "6", SysID, ProdID.ToString(), CategoryID })); if (dr.Read()) { txtNo.Focus(); ShowErrorCannotRepeated(Label1.Text); } else { sql = Pub.GetSQL(DBCode.DB_004003, new string[] { "2", ProdID.ToString(), ProdName, Price, CategoryID, CategoryName, SysID }); db.ExecSQL(sql); IsOk = true; } } } catch (Exception E) { Pub.ShowErrorMsg(E); } finally { if (dr != null) { dr.Close(); } dr = null; } if (IsOk) { db.WriteSYLog(this.Text, CurrentOprt, sql); Pub.MessageBoxShow(Pub.GetResText(formCode, "MsgSaveSucceed", ""), MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Close(); } }
public void IgnoreDeletedRowsDynamicTest() { DataTableReader reader = new DataTableReader(_dt); try { reader.Read(); // first row _dt.Rows[1].Delete(); reader.Read(); // it should be 3rd row string value = reader[0].ToString(); Assert.Equal("3", value); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
private bool DownloadParam(int MacSN) { bool ret = false; string ServerIPAddress = "192.168.1.100"; int ServerPort = 0; int ServerRequest = 0; int DiMacNo = 0; string DoorMagnetic_Type = "no"; string Anti_back = "no"; string Use_Alarm = "yes"; string Glog_Warning = "0"; string DoorMagnetic_Delay = "10"; string Alarm_Delay = "1"; string OpenDoor_Delay = "5"; string Managers = "5"; string Volume = "5"; string MutiUser = "******"; DataTableReader dr = null; string Show_ResultTime = "1"; string Reverify_Time = "1"; string Screensavers_Time = "60"; string Sleep_Time = "0"; string Wiegand_Type = "34"; string Wiegand_Output = "0"; string Wiegand_Input = "0"; string sql = ""; string[] param = new string[0]; string[] tmp = new string[2]; string vstrJsonStr = new string('a', 500); try { JObject vjobj = new JObject(); vjobj.Add("cmd", "lock_control_get"); vstrJsonStr = vjobj.ToString() + "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" + "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" + "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" + "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" + "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"; ret = DeviceObject.objFK623.ExecJsonCmd(ref vstrJsonStr); if (vstrJsonStr != null && vstrJsonStr != "") { string logText = vstrJsonStr.Replace("\"", "").Replace("{", "").Replace("}", ""); param = logText.Split(','); for (int i = 0; i < param.Length; i++) { tmp = null; tmp = param[i].Split(':'); switch (tmp[0]) { case "Alarm_Delay": Alarm_Delay = tmp[1]; break; case "Anti-back": Anti_back = tmp[1]; break; case "DoorMagnetic_Delay": DoorMagnetic_Delay = tmp[1]; break; case "DoorMagnetic_Type": DoorMagnetic_Type = tmp[1]; break; case "Glog_Warning": Glog_Warning = tmp[1]; break; case "Managers": Managers = tmp[1]; break; case "MutiUser": MutiUser = tmp[1]; break; case "OpenDoor_Delay": OpenDoor_Delay = tmp[1]; break; case "Reverify_Time": Reverify_Time = tmp[1]; break; case "Screensavers_Time": Screensavers_Time = tmp[1]; break; case "Show_ResultTime": Show_ResultTime = tmp[1]; break; case "Sleep_Time": Sleep_Time = tmp[1]; break; case "Use_Alarm": Use_Alarm = tmp[1]; break; case "Volume": Volume = tmp[1]; break; case "Wiegand_Input": Wiegand_Input = tmp[1]; break; case "Wiegand_Output": Wiegand_Output = tmp[1]; break; case "Wiegand_Type": Wiegand_Type = tmp[1]; break; } } ret = DeviceObject.objFK623.GetServerNetInfo(ref ServerIPAddress, ref ServerPort, ref ServerRequest); ret = DeviceObject.objFK623.GetDeviceInfo(2, ref DiMacNo); dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN.ToString() })); if (dr.Read()) { sql = Pub.GetSQL(DBCode.DB_000002, new string[] { "203", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest.ToString(), Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, DiMacNo.ToString(), OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort.ToString(), Wiegand_Output, Wiegand_Input }); } else { sql = Pub.GetSQL(DBCode.DB_000002, new string[] { "202", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest.ToString(), Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, DiMacNo.ToString(), OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort.ToString(), Wiegand_Output, Wiegand_Input }); } SystemInfo.db.ExecSQL(sql); } else { ret = DeviceObject.objFK623.GetServerNetInfo(ref ServerIPAddress, ref ServerPort, ref ServerRequest); ret = DeviceObject.objFK623.GetDeviceInfo(2, ref DiMacNo); if (ret) { cbbServerRequest.Text = ServerRequest.ToString(); //是否传送 txtServerIPAddress.Text = ServerIPAddress; //服务器IP地址 txtServerPort.Text = ServerPort.ToString(); //服务器端口 cbbDiMacNo.Text = DiMacNo.ToString(); //机器号1-255 dr = SystemInfo.db.GetDataReader(Pub.GetSQL(DBCode.DB_000002, new string[] { "201", MacSN.ToString() })); if (dr.Read()) { sql = Pub.GetSQL(DBCode.DB_000002, new string[] { "203", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest.ToString(), Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, DiMacNo.ToString(), OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort.ToString(), Wiegand_Output, Wiegand_Input }); } else { sql = Pub.GetSQL(DBCode.DB_000002, new string[] { "202", MacSN.ToString(), DoorMagnetic_Type, Anti_back, ServerRequest.ToString(), Use_Alarm, Glog_Warning, DoorMagnetic_Delay, Alarm_Delay, DiMacNo.ToString().ToString(), OpenDoor_Delay, Managers, Volume, MutiUser, Show_ResultTime, Reverify_Time, Screensavers_Time, Sleep_Time, Wiegand_Type, ServerIPAddress, ServerPort.ToString(), Wiegand_Output, Wiegand_Input }); } SystemInfo.db.ExecSQL(sql); } else { ret = false; } return(ret); } } catch (Exception E) { ret = false; Pub.ShowErrorMsg(E, sql); } finally { if (dr != null) { dr.Close(); } dr = null; } vstrJsonStr = null; DEVGrid_CellClick(null, null); Application.DoEvents(); return(ret); }