public static List <Area> GetArea()
{
List <Area> theList = new List <Area>();
Area theUser = null;
AreaTableAdapter theAdapter = new AreaTableAdapter();
try
{
AreaDS.AreaDataTable table = theAdapter.GetArea();
if (table != null && table.Rows.Count > 0)
{
foreach (AreaDS.AreaRow row in table.Rows)
{
theUser = FillUserRecord(row);
theList.Add(theUser);
}
}
}
catch (Exception q)
{
log.Error("el error ocurrio mientras obtenia la lista del Area de la base de datos", q);
return(null);
}
return(theList);
}
//public static Area GetArea()
//{
// AreaTableAdapter localAdapter = new AreaTableAdapter();
// Area theUser = null;
// try
// {
// AreaDS.AreaDataTable table = localAdapter.GetArea();
// if (table != null && table.Rows.Count > 0)
// {
// AreaDS.AreaRow row = table[0];
// theUser = FillUserRecord(row);
// }
// }
// catch (Exception q)
// {
// log.Error("Un error ocurrio mientras obtenia el Area de la base de dato", q);
// return null;
// }
// return theUser;
//}
public static Area GetAreaById(int idArea)
{
AreaTableAdapter localAdapter = new AreaTableAdapter();
if (idArea <= 0)
{
return(null);
}
Area theUser = null;
try
{
AreaDS.AreaDataTable table = localAdapter.GetAreaById(idArea);
if (table != null && table.Rows.Count > 0)
{
AreaDS.AreaRow row = table[0];
theUser = FillUserRecord(row);
}
}
catch (Exception q)
{
log.Error("Un error ocurrio mientras obtenia el Area de la base de dato", q);
return(null);
}
return(theUser);
}
public static List <Area> GetAreaJoinModuloListForSearch(string whereSql)
{
if (string.IsNullOrEmpty(whereSql))
{
whereSql = "1 = 1";
}
List <Area> theList = new List <Area>();
Area theUser = null;
AreaTableAdapter theAdapter = new AreaTableAdapter();
try
{
AreaDS.AreaDataTable table = theAdapter.GetAreaJoinModuloForSearch(whereSql);
if (table != null && table.Rows.Count > 0)
{
foreach (AreaDS.AreaRow row in table.Rows)
{
theUser = FillUserRecord(row);
theList.Add(theUser);
}
}
}
catch (Exception q)
{
log.Error("el error ocurrio mientras obtenia la lista del Area de la base de datos", q);
//return null;
}
return(theList);
}
public static Area GetAreaById(int areaId)
{
if (areaId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroAreaId);
}
Area theData = null;
try
{
AreaTableAdapter localAdapter = new AreaTableAdapter();
AreaDS.AreaDataTable theTable = localAdapter.GetAreaById(areaId);
if (theTable != null && theTable.Rows.Count > 0)
{
AreaDS.AreaRow theRow = theTable[0];
theData = FillRecord(theRow);
}
}
catch (Exception exc)
{
log.Error("Ocurrió un error mientras se obtenía el area de id: " + areaId, exc);
throw exc;
}
return(theData);
}
public static int InsertArea(int organizationId, string name)
{
if (organizationId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroOrganizationId);
}
if (string.IsNullOrEmpty(name))
{
throw new ArgumentException(Resources.Organization.MessageEmptyNameArea);
}
AreaTableAdapter localAdapter = new AreaTableAdapter();
int?areaId = 0;
try
{
localAdapter.InsertArea(organizationId, name, ref areaId);
}
catch (Exception exc)
{
log.Error(Resources.Organization.MessageErrorCreateArea, exc);
throw exc;
}
if ((int)areaId <= 0)
{
log.Error(Resources.Organization.MessageErrorCreateArea);
throw new ArgumentException(Resources.Organization.MessageErrorCreateArea);
}
return((int)areaId);
}
static public int AddAnArea(string AreaTitle, int AreaCode)
{
VehiclePackingDataSet.AreaDataTable atable = new VehiclePackingDataSet.AreaDataTable( );
VehiclePackingDataSet.AreaRow row = atable.NewAreaRow( );
row.titleArea = AreaTitle;
row.zipCode = AreaCode;
AreaTableAdapter ata = new AreaTableAdapter( );
atable.Rows.Add(row);
int num = ata.Update(atable);
if (num != 1)
{
return(-1);
}
return(atable[0].Id);
//ata.Fill( atable );
//var aid = from a in atable
// where a.zipCode == AreaCode // && a.titleArea == AreaTitle
// select a.Id;
//int id = -1;
//if( aid.Count( ) != 0 )
// id = ( (int[ ]) aid.ToArray<int>( ) )[ 0 ];
//return id;
}
public static void InserTArea(Area objUsuario)
{
try
{
AreaTableAdapter localAdapter = new AreaTableAdapter();
object resutl = localAdapter.InsertArea(
string.IsNullOrEmpty(objUsuario.Descripcion) ? "" : objUsuario.Descripcion);
log.Debug("Se insertó el area de: " + objUsuario.Descripcion);
}
catch (Exception q)
{
log.Error("Ocurrió un error al insertar el Area", q);
throw q;
}
}
public static void DeleteArea(int areaId)
{
if (areaId <= 0)
{
throw new ArgumentException("El area no puede ser menor o igual a cero.");
}
try
{
AreaTableAdapter theAdapter = new AreaTableAdapter();
theAdapter.DeleteArea(areaId);
}
catch (Exception ex)
{
log.Error("Ocurrio un error al Eliminar el Area.", ex);
throw;
}
}
public static void DeleteArea(int areaId)
{
if (areaId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroAreaId);
}
AreaTableAdapter localAdapter = new AreaTableAdapter();
try
{
localAdapter.DeleteArea(areaId);
}
catch (Exception exc)
{
log.Error(Resources.Organization.MessageErrorDeleteArea, exc);
throw new Exception(Resources.Organization.MessageErrorDeleteArea);
}
}
public static void UpdateArea(Area objArea)
{
if (objArea.AreaId <= 0)
{
throw new ArgumentException("El Area no puede ser menor o igual a cero.");
}
try
{
AreaTableAdapter localAdapter = new AreaTableAdapter();
object resutl = localAdapter.UpdateArea(
string.IsNullOrEmpty(objArea.Descripcion) ? "" : objArea.Descripcion,
objArea.AreaId);
log.Debug("Se actualizo el area " + objArea.AreaId);
}
catch (Exception q)
{
log.Error("Ocurrió un error al actualizar el Area", q);
throw q;
}
}
public static List <Area> GetAreasForAutocomplete(int organizationId, string filter)
{
List <Area> theList = new List <Area>();
Area theData = null;
try
{
AreaTableAdapter localAdapter = new AreaTableAdapter();
AreaDS.AreaDataTable theTable = localAdapter.GetAreasForAutocomplete(organizationId, filter);
if (theTable != null && theTable.Rows.Count > 0)
{
foreach (AreaDS.AreaRow theRow in theTable)
{
theData = FillRecord(theRow);
theList.Add(theData);
}
}
}
catch (Exception exc)
{
throw exc;
}
return(theList);
}
public static void UpdateArea(int areaId, string name)
{
if (areaId <= 0)
{
throw new ArgumentException(Resources.Organization.MessageZeroAreaId);
}
if (string.IsNullOrEmpty(name))
{
throw new ArgumentException(Resources.Organization.MessageEmptyNameArea);
}
AreaTableAdapter localAdapter = new AreaTableAdapter();
try
{
localAdapter.UpdateArea(areaId, name);
}
catch (Exception exc)
{
log.Error(Resources.Organization.MessageErrorUpdateArea, exc);
throw exc;
}
}
private void rbnCreateModel_Click(object sender, EventArgs e)
{
if (!rcbDeliveryDate.Checked || rtbDate.TextBoxText == "")
{
MessageBox.Show(this, "只能進行單日貨單的合車演算。\n請選擇有貨單尚未送貨的送貨日。", "出貨日未設定", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Cursor = Cursors.WaitCursor;
theProblem = new VehiclePackingProblem(rtbDate.TextBoxText);
rcbOrders_TextBoxTextChanged(null, null);
rckSplitable_CheckBoxCheckChanged(null, null);
// 問題產生後，已經載入到他的資料表內。檢出該問題內容視覺展出
// dgvVehicles.DataSource = theProblem.ProblemDS.Vehicle;
//theProblem.ProblemDS.Vehicle.Where<>()
dgvVehicles.DataSource = (from v in theProblem.ProblemDS.Vehicle select new { v.licensePlate, v.weightLimit, v.Id }).ToList();
dgvVehicles.AutoGenerateColumns = true;
dgvVehicles.Columns[0].HeaderText = "車牌";
dgvVehicles.Columns[1].HeaderText = "載種噸數";
dgvVehicles.Columns[2].Visible = false;
foreach (DataGridViewColumn c in dgvVehicles.Columns)
{
c.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
dgvVehicles.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvVehicles.MultiSelect = false;
dgvVehicles.RowHeadersVisible = false;
labVehicle.Text = $"貨車啟用 {theProblem.ProblemDS.Vehicle.Rows.Count} 台";
if (cumulatedValues == null || cumulatedValues.Length != theProblem.ProblemDS.Vehicle.Rows.Count)
{
cumulatedValues = new double[theProblem.ProblemDS.Vehicle.Rows.Count];
}
// 整理 area 顏色
if (GroupIdForIds.Count == 0)
{
AreaTableAdapter areaTA = new AreaTableAdapter();
areaTA.Fill(areasTB);
ColorForIds = new Dictionary <int, Color>();
for (int i = 0; i < areasTB.Rows.Count; i++)
{
GroupIdForIds.Add(areasTB[i].Id, areasTB[i].groupID);
ColorForIds.Add(areasTB[i].Id, Color.FromArgb(areasTB[i].color));
}
}
// 檢出 貨單
dgvOrders.DataSource = (from o in theProblem.ProblemDS.Orders join a in areasTB on o.areaId equals a.Id select new { o.Id, o.product, o.netWeight, a.titleArea, a.groupID }).ToList();
dgvOrders.AutoGenerateColumns = true;
dgvOrders.Columns[0].Visible = false;
dgvOrders.Columns[1].HeaderText = "貨品名稱";
dgvOrders.Columns[2].HeaderText = "重量";
dgvOrders.Columns[3].HeaderText = "地區";
dgvOrders.Columns[4].HeaderText = "區群別";
foreach (DataGridViewColumn c in dgvOrders.Columns)
{
c.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
dgvOrders.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvOrders.MultiSelect = false;
dgvOrders.RowHeadersVisible = false;
labOrders.Text = $"{rtbDate.TextBoxText} 貨單共有 {theProblem.ProblemDS.Orders.Rows.Count} 筆";
// 啟動合車按鈕
rplSmallGA.Enabled = rplEvenGA.Enabled = rplSmallExperience.Enabled = true;
Cursor = Cursors.Default;
}
