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);
}
