public CSVWritter(DataGridViewRowCollection _rows)
{
rows = _rows;
}
void Browser.run()
{
while (true)
{
DataGridViewRowCollection rows = form.getTableRows();
DataGridViewRow row = rows[CommonUtils.GetRandomValue(0, rows.Count)];
DataGridViewCellCollection cells = row.Cells;
//SetAgentType(getCellValue(cells, Main.HEADER_AGENT));
if (!form.isRemainTask())
{
break;
}
if (int.Parse(getCellValue(cells, Main.HEADER_TO_COUNT)) == int.Parse(getCellValue(cells, Main.HEADER_CURR_COUNT)))
{
continue;
}
List <Configuration> Configs = sqlite.SelectAllConfigurationByOwner(getCellValue(cells, Main.HEADER_SLOT));
if (Configs == null || Configs.Count == 0)
{
Configs = sqlite.SelectAllConfigurationByOwner(Configuration.Default);
}
Dictionary <string, string> dictionary = Configuration.ConvertObjectToMap(Configs);
// string searchText = getCellValue(cells, Main.HEADER_SEARCH);
// string nxSearchText = getCellValue(cells, Main.HEADER_NXSEARCH);
try
{
logManager.AppendLog("//========슬롯[{0}]의 작업을 시작합니다.========//", getCellValue(cells, Main.HEADER_SLOT));
form.BeginInvoke(new Action(() => { form.ChangeRowColor(row, Color.LawnGreen); }));
// 브라우저 시작
// StartBrowser( dictionary, getCellValue(cells, Main.HEADER_BROWSER));
// 검색어 입력
//SetSearchText("#query", searchText, false);
// 검색전 체류
Stay("1차 검색 전", dictionary[Configuration.COMMON_PRE_SEARCH_STAY]);
// 1차 검색
if (agentType == Slot.AGENT_TYPE_PC)
{
ClickSearchBtn("search_btn");
}
else
{
ClickSearchBtn("query");
}
// 랭크 처리
// form.SetSearchRank(row, FindSearchRank(nxSearchText));
// 검색 후 체류
Stay("1차 검색 후", dictionary[Configuration.COMMON_SEARCH_STAY]);
// 스크롤 처리
ScrollBy(dictionary);
// 카테고리 이동
// int index = MoveTab( getCellValue(cells, Main.HEADER_CATEGORY));
// 카테고리 이동 후 체류
Stay("카테고리 이동 후", dictionary[Configuration.COMMON_SEARCH_STAY]);
// 2차 검색어 입력
// SetSearchText("#nx_query", nxSearchText, true);
// 검색전 체류
Stay("2차 검색 전", dictionary[Configuration.COMMON_PRE_SEARCH_STAY]);
// 2차 검색
if (agentType == Slot.AGENT_TYPE_PC)
{
ClickSearchBtn("bt_search");
}
else
{
ClickSearchBtn("nx_query");
}
// 검색 후 체류
Stay("2차 검색 후", dictionary[Configuration.COMMON_SEARCH_STAY]);
int MaxPageCount = CommonUtils.GetRandomValue(dictionary[Configuration.COMMON_MAX_PAGE]);
for (int i = 0; i < MaxPageCount; i++)
{
// 스크롤 처리
ScrollBy(dictionary);
// 게시물 조회
// bool isViewSuccess = PostViewBy(index, null, 1500, true);
// 게시물 조회 성공
// if (isViewSuccess)
// {
// 스크롤 처리
// ScrollBy(dictionary);
// 최초방문페이지 체류
Stay("최초 페이지 방문 후", dictionary[Configuration.COMMON_INIT_PAGE_STAY]);
// }
// 이전 히스토리 이동
HistoryBack();
// 이전 히스토리 이동 후 체류 시간
Stay("히스토리 이전으로 이동 후", dictionary[Configuration.COMMON_PRE_HISTORY_MOVE_STAY]);
}
DeleteCookie();
// 쿠키삭제 후 체류
Stay("쿠키 삭제 후", dictionary[Configuration.COOKIE_DELETE_POST_STAY]);
// 카운트 증가
ComplateProcess(row);
//브라우저 종료
CloseBrowser();
// 아이피 변경
ChangeIP(dictionary);
logManager.AppendLog("//========슬롯[{0}]의 작업을 종료합니다.========//", getCellValue(cells, Main.HEADER_SLOT));
}
catch (Exception e)
{
logManager.AppendLog("Nested Exception : {0}", e.Message);
// 작업 종료
if (e is ThreadAbortException)
{
form.EnableWorkBtn(false, "정지 중");
ClosingProcess(row);
logManager.AppendLog("정상적으로 작업이 중지 되었습니다.");
form.EnableWorkBtn(true, "작업 실행");
}
else
{
ClosingProcess(row);
logManager.AppendLog("[EXCEPTION] 브라우저가 강제적으로 종료되었거나 알 수 없는 오류가 발생 하였습니다.");
}
break;
}
form.EnableWorkBtn(true, "작업 실행");
}
}
public static DataGridViewRow AddNew(this DataGridViewRowCollection collection)
{
int iDx = collection.Add();
return(collection[iDx]);
}
private void buttSave_Click(object sender, EventArgs e)
{
if (txtRef.Text == "")
{
string order = "select Deliveryidfrom CustomerOrderDelivery";
DataTable dt1 = dbMainClass.getDetailByQuery(order);
string id2 = "";
string id5 = "";
foreach (DataRow dr in dt1.Rows)
{
id5 = dr[0].ToString();
}
string order1 = "select Orderid from VendorOrderDetails";
DataTable dt4 = dbMainClass.getDetailByQuery(order1);
foreach (DataRow dr in dt4.Rows)
{
id2 = dr[0].ToString();
}
string OrderID = "";
if (id2 == "")
{
id2 = "1";
OrderID = id2;
string insertqurry = "insert into VendorOrderDetails values('" + txtVendorId.Text + "','" + dtpInvoiceDate.Text + "','" + txtTotalAmount.Text + "')";
int insertedRows = dbMainClass.saveDetails(insertqurry);
//if (insertedRows > 0)
//{
DataGridViewRowCollection RowCollection = dataGridView1.Rows;
List <string> sf = new List <string>();
for (int a = 0; a < RowCollection.Count; a++)
{
DataGridViewRow currentRow = RowCollection[a];
DataGridViewCellCollection cellCollection = currentRow.Cells;
string txtItemCod = cellCollection[0].Value.ToString();
string txtRate = cellCollection[2].Value.ToString();
string txtQuanit = cellCollection[3].Value.ToString();
string txtAmoun = cellCollection[5].Value.ToString();
string Query = "insert into VendorOrderDesc Values('" + OrderID + "','" + txtItemCod + "','" + txtRate + "','" + txtQuanit + "','" + txtAmoun + "')";
//MessageBox.Show(Query);
sf.Add(Query);
}
int insertedRows1 = dbMainClass.saveDetails(sf);
if (insertedRows1 > 0)
{
if (id5 == "")
{
string deleteQurry = "delete VendorOrderDesc where Orderid='" + id2 + "'";
DataTable dt = dbMainClass.getDetailByQuery(deleteQurry);
//dataGridView1.DataSource = "";
DataGridViewRowCollection RowCollection2 = dataGridView1.Rows;
List <string> sf1 = new List <string>();
for (int a = 0; a < RowCollection2.Count; a++)
{
DataGridViewRow currentRow = RowCollection2[a];
DataGridViewCellCollection cellCollection = currentRow.Cells;
string txtItemCode = cellCollection[0].Value.ToString();
string txtRate = cellCollection[2].Value.ToString();
string txtQuanity = cellCollection[4].Value.ToString();
string txtAmoun = cellCollection[5].Value.ToString();
string OrderID1 = id2;
string Query = "insert into VendorOrderDesc Values('" + OrderID1 + "','" + txtItemCode + "','" + txtRate + "','" + txtQuanity + "','" + txtAmoun + "')";
//MessageBox.Show(Query);
sf1.Add(Query);
}
int insertedRows4 = dbMainClass.saveDetails(sf1);
if (insertedRows4 > 0)
{
string insertQurry = "insert into CustomerOrderDelivery Values('" + txtRef.Text + "','true','" + dtpInvoiceDate.Text + "')";
int insertedRows2 = dbMainClass.saveDetails(insertQurry);
if (insertedRows2 > 0)
{
MessageBox.Show("Details Saved Successfully");
}
else
{
MessageBox.Show("Details Not Saved Successfully");
}
}
}
}
}
else
{
int id3 = Convert.ToInt32(id2);
int id4 = id3 + 1;
OrderID = id4.ToString();
string insertqurry1 = "insert into VendorOrderDetails values('" + txtVendorId.Text + "','" + dtpInvoiceDate.Text + "','" + txtTotalAmount.Text + "')";
int insertedRows1 = dbMainClass.saveDetails(insertqurry1);
//if (insertedRows1 > 0)
//{
DataGridViewRowCollection RowCollection = dataGridView1.Rows;
List <string> sf = new List <string>();
for (int a = 0; a < RowCollection.Count; a++)
{
DataGridViewRow currentRow = RowCollection[a];
DataGridViewCellCollection cellCollection = currentRow.Cells;
string txtItemCod = cellCollection[0].Value.ToString();
string txtRate = cellCollection[2].Value.ToString();
string txtQuanit = cellCollection[3].Value.ToString();
string txtAmoun = cellCollection[4].Value.ToString();
string Query = "insert into VendorOrderDesc Values('" + OrderID + "','" + txtItemCod + "','" + txtRate + "','" + txtQuanit + "','" + txtAmoun + "')";
//MessageBox.Show(Query);
sf.Add(Query);
}
int insertedRows2 = dbMainClass.saveDetails(sf);
if (insertedRows2 > 0)
{
string deleteQurry1 = "delete VendorOrderDesc where Orderid='" + OrderID + "'";
DataTable dt5 = dbMainClass.getDetailByQuery(deleteQurry1);
//dataGridView1.DataSource = "";
DataGridViewRowCollection RowCollection1 = dataGridView1.Rows;
List <string> sf2 = new List <string>();
for (int a = 0; a < RowCollection1.Count; a++)
{
DataGridViewRow currentRow = RowCollection1[a];
DataGridViewCellCollection cellCollection = currentRow.Cells;
string txtItemCode = cellCollection[0].Value.ToString();
string txtRate = cellCollection[2].Value.ToString();
string txtQuanity = cellCollection[3].Value.ToString();
string txtAmoun = cellCollection[4].Value.ToString();
string OrderID2 = OrderID;
string Query = "insert into VendorOrderDesc Values('" + OrderID2 + "','" + txtItemCode + "','" + txtRate + "','" + txtQuanity + "','" + txtAmoun + "')";
//MessageBox.Show(Query);
sf2.Add(Query);
}
int insertedRows3 = dbMainClass.saveDetails(sf2);
if (insertedRows3 > 0)
{
string insertQurry = "insert into CustomerOrderDelivery Values('" + OrderID + "','true','" + dtpInvoiceDate.Text + "')";
int insertedRows5 = dbMainClass.saveDetails(insertQurry);
if (insertedRows5 > 0)
{
string select1 = "select * from CustomerOrderDelivery where Orderid='" + OrderID + "'";
DataTable dt2 = dbMainClass.getDetailByQuery(select1);
if (dt2 != null && dt2.Rows != null && dt2.Rows.Count > 0)
{
DataRow dr1 = dt2.Rows[0];
string r = dr1[1].ToString();
string s = dr1[0].ToString();
string select = "select * from CustomerOrderDelivery where Deliveryid='" + s + "'";
DataTable dt = dbMainClass.getDetailByQuery(select);
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
string c = dr[0].ToString();
string Qurry1 = "insert into CustomerOrderInvoice Values('" + c + "','" + r + "','" + dtpInvoiceDate.Text + "')";
int insertedRows = dbMainClass.saveDetails(Qurry1);
if (insertedRows > 0)
{
MessageBox.Show("Details Saved Successfully");
}
else
{
MessageBox.Show("Details Not Saved Successfully");
}
}
}
// }
}
}
}
}
int id = Convert.ToInt32(txtSrNo.Text);
int id1 = id + 1;
txtSrNo.Text = id1.ToString();
// F9.MdiParent = this;
Form9 F9 = new Form9(id.ToString());
F9.Show();
makeBlank();
}
if (txtRef.Text != "")
{
string select1 = "select * from CustomerOrderDelivery where Deliveryid='" + txtRef.Text + "'";
DataTable dt2 = dbMainClass.getDetailByQuery(select1);
if (dt2 != null && dt2.Rows != null && dt2.Rows.Count > 0)
{
DataRow dr1 = dt2.Rows[0];
string r = dr1[1].ToString();
string deleteQurry = "delete VendorOrderDesc where Orderid='" + r + "'";
DataTable dt3 = dbMainClass.getDetailByQuery(deleteQurry);
}
counter = 0;
if (counter == 0)
{
//string insertqurry = "insert into VendorOrderDetails values('" +txtVendorId.Text + "','" + txtdate.Text + "','" + txtTotalAmount.Text + "')";
//int insertedRows = dbMainClass.saveDetails(insertqurry);
//if (insertedRows > 0)
//{
// MessageBox.Show("Details Saved Successfully");
//}
//else
//{
// MessageBox.Show("Details Not Saved Successfully");
//}
string select = "select * from CustomerOrderDelivery where Deliveryid='" + txtRef.Text + "'";
DataTable dt = dbMainClass.getDetailByQuery(select);
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
string c = dr[1].ToString();
DataGridViewRowCollection RowCollection4 = dataGridView1.Rows;
List <string> sf4 = new List <string>();
for (int a = 0; a < RowCollection4.Count; a++)
{
DataGridViewRow currentRow = RowCollection4[a];
DataGridViewCellCollection cellCollection = currentRow.Cells;
string txtItemCode = cellCollection[0].Value.ToString();
string txtRate = cellCollection[2].Value.ToString();
string txtQuanity = cellCollection[3].Value.ToString();
string txtAmoun = cellCollection[4].Value.ToString();
string OrderID3 = c;
string Query = "insert into VendorOrderDesc Values('" + OrderID3 + "','" + txtItemCode + "','" + txtRate + "','" + txtQuanity + "','" + txtAmoun + "')";
//MessageBox.Show(Query);
sf4.Add(Query);
}
int insertedRows5 = dbMainClass.saveDetails(sf4);
if (insertedRows5 > 0)
{
string Qurry1 = "insert into CustomerOrderInvoice Values('" + txtRef.Text + "','" + c + "','" + dtpInvoiceDate.Text + "')";
int insertedRows = dbMainClass.saveDetails(Qurry1);
if (insertedRows > 0)
{
MessageBox.Show("Details Saved Successfully");
}
else
{
MessageBox.Show("Details Not Saved Successfully");
}
}
}
}
//}
//F9.MdiParent = this;
makeBlank();
int id = Convert.ToInt32(txtSrNo.Text);
int id1 = id + 1;
txtSrNo.Text = id1.ToString();
Form9 F9 = new Form9(id.ToString());
F9.Show();
}
}
// Local mouse action event handler
public void MouseAction(object sender, MouseActionEventArgs e)
{
Form1 form = (Form1)sender;
DataGridViewRowCollection rows = form.dataGridView1.Rows;
rows[form.index].Cells[0].Value = Enum.GetName(typeof(MouseMessages), e.mouseMessage);
rows[form.index].Cells[1].Value = e.point.x;
rows[form.index].Cells[2].Value = e.point.y;
switch (e.mouseMessage)
{
case MouseMessages.WM_MOUSEMOVE:
if (form.isNewRow)
{
//rows[form.index].Cells[0].Value = "Move";
form.isNewRow = false;
}
// Exits the global low level mouse hook, calls GC.Collect() actively, and then reenters a new hook
form.SetHook(Form1.WH_MOUSE_LL);
return;
/*case MouseMessages.WM_LBUTTONDOWN:
* rows[form.index].Cells[0].Value = "Left Button Down";
* break;
*
* case MouseMessages.WM_RBUTTONDOWN:
* rows[form.index].Cells[0].Value = "Right Button Down";
* break;
*
* case MouseMessages.WM_LBUTTONUP:
* rows[form.index].Cells[0].Value = "Left Button Up";
* break;
*
* case MouseMessages.WM_RBUTTONUP:
* rows[form.index].Cells[0].Value = "Right Button Up";
* break;*/
}
Window win = new Tool().getWindow(e.hWnd, e.point);
if (win != null)
{
//high light window's frame
switch (e.mouseMessage)
{
case MouseMessages.WM_LBUTTONDOWN:
case MouseMessages.WM_RBUTTONDOWN:
win.DrawFrame();
lastWin = win;
break;
case MouseMessages.WM_LBUTTONUP:
case MouseMessages.WM_RBUTTONUP:
lastWin.DrawFrame();
if (lastWin.hWnd != win.hWnd)
{
//win.DrawFrame();
Thread thd = new Thread(Window.DrawFrame);
thd.Name = "delay";
thd.Start(win);
}
lastWin = null;
break;
}
// Exits the global low level mouse hook, calls GC.Collect() actively, and then reenters a new hook
form.SetHook(Form1.WH_MOUSE_LL);
if (!form.windows.ContainsKey(win.hWnd))
{
form.windows.Add(win.hWnd, win);
}
rows[form.index].Cells[3].Value = win.hWnd.ToString();
form.dataGridView1.ClearSelection();
rows[form.index++].Cells[3].Selected = true;
form.isNewRow = true;
if (form.index >= form.dataGridView1.Rows.Count)
{
form.StopTracking_Click(null, null);
}
if (!form.splitContainer1.Panel2Collapsed)
{
form.showWindowProperties(win.hWnd);
}
}
}
/// <summary>
/// Метод инициализации выражений
/// </summary>
/// <param name="dgvrCollection">Строки с таблицы со списком выражений на форме MainForm</param>
/// <param name="newRowIndex">Индекс новой строки в таблице</param>
/// <param name="loggingService">Сервис логирования</param>
public static List <Expression> initExpressions(DataGridViewRowCollection dgvrCollection, int newRowIndex, LoggingService loggingService)
{
loggingService.logString("\n\n----------Ввод выражений:----------------\n");
List <Expression> expressions = new List <Expression>();
bool processingTerminated = false;
int index = 1;
foreach (DataGridViewRow dgvr in dgvrCollection)
{
if (dgvr.Index == newRowIndex)
{
break;
}
if (dgvr.Cells[0].Value == null || dgvr.Cells[0].Value.ToString().Length == 0)
{
loggingService.logError("Ошибка в строке " + dgvr.Index.ToString() + ": не задано выражение ЕСЛИ\n");
processingTerminated = true;
break;
}
if (dgvr.Cells[1].Value == null || dgvr.Cells[1].Value.ToString().Length == 0)
{
loggingService.logError("Ошибка в строке " + dgvr.Index.ToString() + ": не задано выражение ТО\n");
processingTerminated = true;
break;
}
int openBracketCount = 0, closeBracketCount = 0;
foreach (char c in dgvr.Cells[0].Value.ToString())
{
if (c == '(')
{
openBracketCount++;
}
else if (c == ')')
{
closeBracketCount++;
}
}
if (openBracketCount != closeBracketCount)
{
loggingService.logError("Ошибка в строке " + dgvr.Index.ToString() +
": количество открывающих скобок (" + openBracketCount +
") не совпадает с количеством закрывающих (" + closeBracketCount + ")\n");
processingTerminated = true;
break;
}
Expression expression = new Expression(index, dgvr.Cells[0].Value.ToString(), dgvr.Cells[1].Value.ToString(),
dgvr.Cells[2].Value != null ? dgvr.Cells[2].Value.ToString() : string.Empty);
expressions.Add(expression);
index++;
}
if (!processingTerminated)
{
loggingService.logExpressions(expressions);
}
return(expressions);
}
public ShowArticleList(MainForm pParent, DataGridViewRowCollection inrowcol)
{
InitializeComponent();
rowcol = inrowcol;
mParent = pParent;
overlay = mParent.mGFXEngines[(int)eEngines.OVERLAY];
projector = mParent.mGFXEngines[(int)eEngines.PROJECTOR];
lButtons.Add(button1);
lButtons.Add(button2);
lButtons.Add(button3);
lButtons.Add(button4);
lButtons.Add(button5);
lButtons.Add(button6);
lButtons.Add(button7);
lButtons.Add(button8);
lButtons.Add(button9);
lButtons.Add(button10);
lButtons.Add(button11);
lButtons.Add(button12);
lButtons.Add(button13);
lButtons.Add(button14);
lButtons.Add(button15);
larticlesused.Add(marticle1used);
larticlesused.Add(marticle2used);
larticlesused.Add(marticle3used);
larticlesused.Add(marticle4used);
larticlesused.Add(marticle5used);
larticlesused.Add(marticle6used);
larticlesused.Add(marticle7used);
larticlesused.Add(marticle8used);
larticlesused.Add(marticle9used);
larticlesused.Add(marticle10used);
larticlesused.Add(marticle11used);
larticlesused.Add(marticle12used);
larticlesused.Add(marticle13used);
larticlesused.Add(marticle14used);
larticlesused.Add(marticle15used);
int cnt = 0;
foreach (DataGridViewRow row in inrowcol)
{
long templong;
long.TryParse(row.Cells[1].Value.ToString(), out templong);
larticles.Add(new articles(row.Cells[0].Value.ToString(), templong));
//lArticles.Add(row.Cells[0].Value.ToString(), row.Cells[1].Value.ToString());
//lButtons[cnt].Text = row.Cells[0].Value.ToString() +" - " + row.Cells[1].Value.ToString();
cnt++;
}
for (int i = cnt; i < 15; i++)
{
lButtons[i].Visible = false;
}
// new sort the dictionary alphabetic..
//lList = lArticles.Keys.ToList();
//larticles.Sort();
//var lsortedarticles = larticles.OrderBy(price => price).ToList();
larticles.Sort((x, y) => string.Compare(x.name, y.name));
cnt = 0;
foreach (articles art in larticles)
{
lButtons[cnt].Text = art.name + " - " + art.price;
cnt++;
}
}
private void saleLoadData(int pageNum)
{
int total = 0;
dgvSale.Rows.Clear();
DataGridViewRowCollection rows = dgvSale.Rows;
RosterDial_RInfo view = new RosterDial_RInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
if (!string.IsNullOrEmpty(txtSaleItem.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.item.ToString(), txtSaleItem.Text);
}
if (!string.IsNullOrEmpty(txtSaleMain.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.main.ToString(), txtSaleMain.Text);
}
if (!string.IsNullOrEmpty(txtSaleName.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.name.ToString(), txtSaleName.Text);
}
if (!string.IsNullOrEmpty(txtSaleComment.Text))
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.comment.ToString(), txtSaleComment.Text);
}
//if (!string.IsNullOrEmpty(dpkSaleInsertSDTTM.Value.ToString()) && ckbSaleInsertDTTM.Checked)
// view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.createSDTTM.ToString(), dpkSaleInsertSDTTM.Value.ToString("yyyy/MM/dd"));
//if (!string.IsNullOrEmpty(dpkSaleInsertSDTTM.Value.ToString()) && ckbSaleInsertDTTM.Checked)
// view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.createEDTTM.ToString(), dpkSaleInsertSDTTM.Value.ToString("yyyy/MM/dd"));
if (!string.IsNullOrEmpty(dpkSaleModifySDTTM.Value.ToString()) && ckbSaleModifyDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.modifySDTTM.ToString(), dpkSaleModifySDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkSaleModifyEDTTM.Value.ToString()) && ckbSaleModifyDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.modifyEDTTM.ToString(), dpkSaleModifyEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkSaleDealSDTTM.Value.ToString()) && ckbSaleDealDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealSDTTM.ToString(), dpkSaleDealSDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkSaleDealEDTTM.Value.ToString()) && ckbSaleDealDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealEDTTM.ToString(), dpkSaleDealEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (ddlSaleDealer.SelectedIndex != 0)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.dealer.ToString(), ddlSaleDealer.SelectedItem.ToString());
}
if (ddlSaleStatus.SelectedIndex != 0)
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.status.ToString(), ddlSaleStatus.SelectedItem.ToString());
}
if (ddlSaleType.SelectedIndex != 0)
{
if (ddlSaleType.SelectedItem.ToString() == "銷貨淨值") //Harsh Code
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.typelist.ToString(), " '銷貨收入','銷貨折扣'");
}
else
{
view.Conditions += " AND " + view.getCondition(RosterDial_RInfo.ncConditions.type.ToString(), ddlSaleType.SelectedItem.ToString());
}
}
//組排序指令
if (dgvSale.SortedColumn is null)
{
view.OrderBy = view.getOptionOrderBy(RosterDial_RInfo.ncSort.Default.ToString());
}
else
{
string sortname = dgvSale.SortedColumn.Name;
string sortmode = APConfig.GetValueFromDescription <SortMode>(dgvSale.SortOrder.ToString()).ToString();
view.OrderBy = string.Format("{0} {1}", view.getOptionOrderBy(sortname), sortmode);
}
//查詢頁數初始化且自動跳轉至第一頁
if (pageNum == 0)
{
APConfig.loadPage(ddlSalePage, view.calculatePage(APConfig.PageCount));
return;
}
//計算總合
if (view.load())
{
while (!view.IsEof)
{
total += int.Parse(view.RSD_AMOUNT);
view.next();
}
}
//塞入資料
DataSet ds = APConfig.GoPage(view.SQLStatement, pageNum);
foreach (DataRow dr in ds.Tables[0].Rows)
{
rows.Add(new Object[] { dr.ItemArray[0], dr.ItemArray[14], dr.ItemArray[13], dr.ItemArray[1], dr.ItemArray[2], dr.ItemArray[3], dr.ItemArray[6], dr.ItemArray[4], dr.ItemArray[5], dr.ItemArray[7], dr.ItemArray[10] });
}
lblSaleTotal.Text = view.calculateCount().ToString();
lblSaleTotalAmount.Text = string.Format("{0:n0} 元", total);
}
private void memberLoadData(int pageNum)
{
dgvMember.Rows.Clear();
DataGridViewRowCollection rows = dgvMember.Rows;
RosterInfo vRoster = new RosterInfo(APConfig.Conn);
vRoster.Conditions = " 1=1 ";
if (!string.IsNullOrEmpty(txtMemberName.Text))
{
vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.name.ToString(), txtMemberName.Text);
}
if (!string.IsNullOrEmpty(txtMemberTel.Text))
{
vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.phoneLike.ToString(), txtMemberTel.Text);
}
if (!string.IsNullOrEmpty(txtMemberAddr.Text))
{
vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.address.ToString(), txtMemberAddr.Text);
}
if (!string.IsNullOrEmpty(dpkMemberInsertSDTTM.Value.ToString()) && ckbMemberInsertDTTM.Checked)
{
vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.createSDTTM.ToString(), dpkMemberInsertSDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkMemberInsertEDTTM.Value.ToString()) && ckbMemberInsertDTTM.Checked)
{
vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.createEDTTM.ToString(), dpkMemberInsertEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkMemberModifySDTTM.Value.ToString()) && ckbMemberModifyDTTM.Checked)
{
vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.modifySDTTM.ToString(), dpkMemberModifySDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkMemberModifyEDTTM.Value.ToString()) && ckbMemberModifyDTTM.Checked)
{
vRoster.Conditions += " AND " + vRoster.getCondition(RosterInfo.ncConditions.modifyEDTTM.ToString(), dpkMemberModifyEDTTM.Value.ToString("yyyy/MM/dd"));
}
//組排序指令
if (dgvMember.SortedColumn is null)
{
vRoster.OrderBy = vRoster.getOptionOrderBy(RosterInfo.ncSort.Default.ToString());
}
else
{
string sortname = dgvMember.SortedColumn.Name;
string sortmode = APConfig.GetValueFromDescription <SortMode>(dgvMember.SortOrder.ToString()).ToString();
vRoster.OrderBy = string.Format("{0} {1}", vRoster.getOptionOrderBy(sortname), sortmode);
}
//查詢頁數初始化且自動跳轉至第一頁
if (pageNum == 0)
{
APConfig.loadPage(ddlMemberPage, vRoster.calculatePage(APConfig.PageCount));
return;
}
//塞入資料
lblMemberTotal.Text = vRoster.calculateCount().ToString();
DataSet ds = APConfig.GoPage(vRoster.SQLStatement, pageNum);
foreach (DataRow dr in ds.Tables[0].Rows)
{
rows.Add(new Object[] { dr.ItemArray[0], dr.ItemArray[1], dr.ItemArray[6], dr.ItemArray[4], dr.ItemArray[5], dr.ItemArray[8], dr.ItemArray[10], dr.ItemArray[13] });
}
}
private async void btnTeam1_Click(object sender, EventArgs e)// send members and teams to web database
{
Button tmpBtn = (Button)sender;
tmpBtn.Enabled = false;
if (string.IsNullOrWhiteSpace(txtTournament.Text) || btnTournament.Enabled == true)
{
MessageBox.Show("Please name a tournament before you add/update it.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tmpBtn.Enabled = true;
}
foreach (Control g in tmpBtn.Parent.Controls)// for loop to look all datas
{
if (g is GroupBox)
{
int columnCount = 0;
DataGridViewRowCollection rows = table.board.Rows;
teamCount = Convert.ToInt32(table.board.RowCount) + 1;
object[] contains = new object[12];
contains[columnCount] = Convert.ToString(teamCount);
columnCount++;
foreach (Control c in g.Controls)// add all the details to the database and the datagridview in score board
{
if (c is TextBox)
{
if (String.IsNullOrWhiteSpace(c.Text))
{
MessageBox.Show("Please name a team or fill in names of all members.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tmpBtn.Enabled = true;
break;
}
else
{
if (c.Tag.Equals("1"))// if is team name
{
Team team = new Team(c.Text);
contains[columnCount] = team.name; //add team name to scoreboard
columnCount++;
for (int i = 0; i < 5; i++) // all records set to 0
{
contains[columnCount] = 0;
columnCount++;
}
string result = await ApiHandler.addTeam(tournamentID, team);
team = ApiHandler.jsonTo <Team>(result);
teamID = team.id;
}
else
{
Player player = new Player(c.Text);// add all players
contains[columnCount] = player.name;
await ApiHandler.addPlayer(teamID, player);
}
}
}
}
rows.Add(contains);//add to the datagridview
}
}
tmpBtn.Enabled = true;
btnTournament.Enabled = true;
table.Show();// show the score board with teams you have
}
void salvarDataSet()
{
FolderBrowserDialog oDialog = new FolderBrowserDialog();
oDialog.RootFolder = Environment.SpecialFolder.MyComputer;// = Directory.GetCurrentDirectory();
oDialog.SelectedPath = Directory.GetParent(Directory.GetCurrentDirectory()) + "\\Dados";
if (oDialog.ShowDialog() == DialogResult.OK)
{
string fileXML = oDialog.SelectedPath;
DataTable oDataTable = new DataTable();
DataSet oDataSet = new DataSet();
DataGridViewRowCollection tweets = dataGridViewSearchTwieet.Rows;
oDataTable.TableName = "Search" + cmbSize.SelectedItem + "Resultados";
foreach (DataGridViewColumn col in dataGridViewSearchTwieet.Columns)
{
oDataTable.Columns.Add(col.HeaderText);
}
//oDataTable.Rows = (DataGridViewColumn)dataGridViewSearchTwieet.Rows;
try
{
foreach (DataGridViewRow row in tweets)
{
DataRow dRow = oDataTable.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
oDataTable.Rows.Add(dRow);
}
/*foreach (DataGridViewRow row in dataGridViewSearchTwieet.Rows)
* {
* DataRow dRow = oDataTable.NewRow();
*
*
* foreach (DataGridViewCell cell in row.Cells)
* {
* dRow[cell.ColumnIndex] = cell.Value;
* }
*
* oDataTable.Rows.Add(dRow);
* }*/
}
catch (Exception e1)
{
Console.WriteLine(e1.InnerException);
}
oDataSet.Tables.Add(oDataTable);
oDataSet.WriteXml(fileXML + "\\" + oDataTable.TableName + ".xml");
}
///
}
/// <inheritdoc />
public void ShowSettings(DataGridViewRowCollection rows)
{
// title
DataGridViewRow row = new DataGridViewRow();
row.Cells.Add(new DataGridViewTitleCell()
{
LeftColumn = 0, RightColumn = 3, Title = String.Format("Varible of {0}", VariableTypeHelper.FriendlyName(Variable.VariableType))
});
row.Cells[row.Cells.Count - 1].ReadOnly = true;
row.Cells.Add(new DataGridViewTitleCell()
{
LeftColumn = 0, RightColumn = 3
});
row.Cells[row.Cells.Count - 1].ReadOnly = true;
row.Cells.Add(new DataGridViewTitleCell()
{
LeftColumn = 0, RightColumn = 3
});
row.Cells[row.Cells.Count - 1].ReadOnly = true;
row.Cells.Add(new DataGridViewTitleCell()
{
LeftColumn = 0, RightColumn = 3
});
row.Cells[row.Cells.Count - 1].ReadOnly = true;
rows.Add(row);
// name
if (Variable.NamedVariable != null)
{
if (nameVar == null)
{
nameVar = new StringVar()
{
Value = Variable.NamedVariable.Name
};
}
row = new DataGridViewRow();
row.Cells.Add(new DataGridViewDisableCheckBoxCell()
{
Enabled = false
});
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = "Name"
});
row.Cells.Add(nameVar.GetGridCell());
row.Cells[row.Cells.Count - 1].ReadOnly = true;
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = ""
});
rows.Add(row);
}
// value
row = new DataGridViewRow();
row.Cells.Add(new DataGridViewDisableCheckBoxCell()
{
Enabled = false
});
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = "Value"
});
row.Cells.Add(Variable.Value.GetGridCell());
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = VariableTypeHelper.FriendlyName(Variable.VariableType)
});
rows.Add(row);
// comment
if (commentVar == null)
{
commentVar = new StringVar()
{
Value = Variable.Comment
};
commentVar.ValueChanged += (object sender, EventArgs e) => { Variable.Comment = commentVar.Value; };
}
row = new DataGridViewRow();
row.Cells.Add(new DataGridViewDisableCheckBoxCell()
{
Enabled = false
});
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = "Comment"
});
row.Cells.Add(commentVar.GetGridCell());
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = VariableTypeHelper.FriendlyName(commentVar.VariableType)
});
rows.Add(row);
}
private void buttonRefresh_Click(object sender, EventArgs e)
{
String name = null;
try
{
textBoxAction.Text = "Loading";
this.Refresh();
Log.Debug("Loading all channels from the tvguide[s]");
// used for partial matches
TstDictionary guideChannels = new TstDictionary();
Dictionary <string, Channel> guideChannelsExternald = new Dictionary <string, Channel>();
List <Channel> lstTvGuideChannels = readChannelsFromTVGuide();
if (lstTvGuideChannels == null)
{
return;
}
// convert to Dictionary
foreach (Channel ch in lstTvGuideChannels)
{
string tName = ch.DisplayName.Replace(" ", "").ToLowerInvariant();
if (!guideChannels.ContainsKey(tName))
{
guideChannels.Add(tName, ch);
}
// used to make sure that the available mapping is used by default
if (ch.ExternalId != null && !ch.ExternalId.Trim().Equals(""))
{
// need to check this because we can have channels with multiple display-names
// and they're currently handles as one channel/display-name.
// only in the mapping procedure of course
if (!guideChannelsExternald.ContainsKey(ch.ExternalId))
{
guideChannelsExternald.Add(ch.ExternalId, ch);
}
}
}
Log.Debug("Loading all channels from the database");
CBChannelGroup chGroup = (CBChannelGroup)comboBoxGroup.SelectedItem;
IList <Channel> channels;
bool loadRadio = checkBoxLoadRadio.Checked;
if (chGroup != null && chGroup.idGroup != -1)
{
SqlBuilder sb1 = new SqlBuilder(Gentle.Framework.StatementType.Select, typeof(Channel));
SqlStatement stmt1 = sb1.GetStatement(true);
SqlStatement ManualJoinSQL = new SqlStatement(stmt1.StatementType, stmt1.Command,
String.Format(
"select c.* from Channel c join GroupMap g on c.idChannel=g.idChannel where " +
(loadRadio ? "" : " c.isTv = 1 and ") +
" g.idGroup = '{0}' order by g.sortOrder", chGroup.idGroup),
typeof(Channel));
channels = ObjectFactory.GetCollection <Channel>(ManualJoinSQL.Execute());
}
else
{
SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof(Channel));
sb.AddOrderByField(true, "sortOrder");
if (!loadRadio)
{
sb.AddConstraint(" isTv = 1");
}
SqlStatement stmt = sb.GetStatement(true);
channels = ObjectFactory.GetCollection <Channel>(stmt.Execute());
}
progressBar1.Minimum = 0;
progressBar1.Maximum = channels.Count;
progressBar1.Value = 0;
dataGridChannelMappings.Rows.Clear();
int row = 0;
if (channels.Count == 0)
{
MessageBox.Show("No tv-channels available to map");
return;
}
// add as many rows in the datagrid as there are channels
dataGridChannelMappings.Rows.Add(channels.Count);
DataGridViewRowCollection rows = dataGridChannelMappings.Rows;
// go through each channel and try to find a matching channel
// 1: matching display-name (non case-sensitive)
// 2: partial search on the first word. The first match will be selected in the dropdown
foreach (Channel ch in channels)
{
Boolean alreadyMapped = false;
DataGridViewRow gridRow = rows[row++];
DataGridViewTextBoxCell idCell = (DataGridViewTextBoxCell)gridRow.Cells["Id"];
DataGridViewTextBoxCell channelCell = (DataGridViewTextBoxCell)gridRow.Cells["tuningChannel"];
DataGridViewTextBoxCell providerCell = (DataGridViewTextBoxCell)gridRow.Cells["tuningChannel"];
DataGridViewCheckBoxCell showInGuideCell = (DataGridViewCheckBoxCell)gridRow.Cells["ShowInGuide"];
channelCell.Value = ch.DisplayName;
idCell.Value = ch.IdChannel;
showInGuideCell.Value = ch.VisibleInGuide;
DataGridViewComboBoxCell guideChannelComboBox = (DataGridViewComboBoxCell)gridRow.Cells["guideChannel"];
// always add a empty item as the first option
// these channels will not be updated when saving
guideChannelComboBox.Items.Add("");
// Start by checking if there's an available mapping for this channel
Channel matchingGuideChannel = null;
if (guideChannelsExternald.ContainsKey(ch.ExternalId))
{
matchingGuideChannel = guideChannelsExternald[ch.ExternalId];
alreadyMapped = true;
}
// no externalid mapping available, try using the name
if (matchingGuideChannel == null)
{
string tName = ch.DisplayName.Replace(" ", "").ToLowerInvariant();
if (guideChannels.ContainsKey(tName))
{
matchingGuideChannel = (Channel)guideChannels[tName];
}
}
Boolean exactMatch = false;
Boolean partialMatch = false;
if (!alreadyMapped)
{
if (matchingGuideChannel != null)
{
exactMatch = true;
}
else
{
// No name mapping found
// do a partial search, default off
if (checkBoxPartialMatch.Checked)
{
// do a search using the first word(s) (skipping the last) of the channelname
name = ch.DisplayName.Trim();
int spaceIdx = name.LastIndexOf(" ");
if (spaceIdx > 0)
{
name = name.Substring(0, spaceIdx).Trim();
}
else
{
// only one word so we'll do a partial match on the first 3 letters
if (name.Length > 3)
{
name = name.Substring(0, 3);
}
}
try
{
// Note: the partial match code doesn't work as described by the author
// so we'll use PrefixMatch method (created by a codeproject user)
ICollection partialMatches = guideChannels.PrefixMatch(name.Replace(" ", "").ToLowerInvariant());
if (partialMatches != null && partialMatches.Count > 0)
{
IEnumerator pmE = partialMatches.GetEnumerator();
pmE.MoveNext();
matchingGuideChannel = (Channel)guideChannels[(string)pmE.Current];
partialMatch = true;
}
}
catch (Exception ex)
{
Log.Error("Error while searching for matching guide channel :" + ex.Message);
}
}
}
}
// add the channels
// set the first matching channel in the search above as the selected
Boolean gotMatch = false;
string ALREADY_MAPPED = "Already mapped (got external id)";
string EXACT_MATCH = "Exact match";
string PARTIAL_MATCH = "Partial match";
string NO_MATCH = "No match";
DataGridViewCell cell = gridRow.Cells["matchType"];
foreach (DictionaryEntry de in guideChannels)
{
Channel guideChannel = (Channel)de.Value;
String itemText = guideChannel.DisplayName + " (" + guideChannel.ExternalId + ")";
guideChannelComboBox.Items.Add(itemText);
if (!gotMatch && matchingGuideChannel != null)
{
if (guideChannel.DisplayName.ToLowerInvariant().Equals(matchingGuideChannel.DisplayName.ToLowerInvariant()))
{
// set the matchtype row color according to the type of match(already mapped,exact, partial, none)
if (alreadyMapped)
{
cell.Style.BackColor = Color.White;
cell.ToolTipText = ALREADY_MAPPED;
// hack so that we can order the grid by mappingtype
cell.Value = "";
}
else if (exactMatch)
{
cell.Style.BackColor = Color.Green;
cell.ToolTipText = EXACT_MATCH;
cell.Value = " ";
}
else if (partialMatch)
{
cell.Style.BackColor = Color.Yellow;
cell.ToolTipText = PARTIAL_MATCH;
cell.Value = " ";
}
guideChannelComboBox.Value = itemText;
guideChannelComboBox.Tag = ch.ExternalId;
gotMatch = true;
}
}
}
if (!gotMatch)
{
cell.Style.BackColor = Color.Red;
cell.ToolTipText = NO_MATCH;
cell.Value = " ";
}
progressBar1.Value++;
}
textBoxAction.Text = "Finished";
}
catch (Exception ex)
{
Log.Error("Failed loading channels/mappings : channel {0} erro {1} ", name, ex.Message);
Log.Error(ex.StackTrace);
textBoxAction.Text = "Error";
}
}
public void ByLisencePlate(licensePlatePrefix licensePlatePrefix, DataGridView dgv)
{
DataGridViewRowCollection collection = dgv.Rows;
dgv.CurrentCell = null;
int counter = 0;
for (int i = 0; i < Administrator.listaVehiculos.Count; i++)
{
collection[i].Visible = true;
licensePlatePrefixLevel prefixLevel = GetLicensePlatePrefixLevel(licensePlatePrefix);
#region For two and three cases
string licensePlatePrefixString = licensePlatePrefix.ToString();
#endregion
switch (prefixLevel)
{
case licensePlatePrefixLevel.one:
char licensePlatePrefixChar = Convert.ToChar(licensePlatePrefix.ToString());
if (licensePlatePrefixChar != Administrator.listaVehiculos[i].LicensePlate[0])
{
collection[i].Visible = false;
counter++;
}
break;
case licensePlatePrefixLevel.two:
string licenPlaceFirstTwoChars
= Administrator.listaVehiculos[i].LicensePlate[0].ToString()
+ Administrator.listaVehiculos[i].LicensePlate[1].ToString();
if (licensePlatePrefixString != licenPlaceFirstTwoChars)
{
collection[i].Visible = false;
counter++;
}
break;
case licensePlatePrefixLevel.tree:
string licenPlaceFirstThreeChars
= Administrator.listaVehiculos[i].LicensePlate[0].ToString()
+ Administrator.listaVehiculos[i].LicensePlate[1].ToString()
+ Administrator.listaVehiculos[i].LicensePlate[2].ToString();
if (licensePlatePrefixString != licenPlaceFirstThreeChars)
{
collection[i].Visible = false;
counter++;
}
break;
}
}
}
public PrintDataGrid(DataGridViewRowCollection rowCollection)
{
this.rowColl = rowCollection;
}
private void Get_Data(String user_name, String Date)
{
DataGridViewRowCollection DGVR = dataGridView_workinfo.Rows;
ArrayList OnDutyDate = new ArrayList();
ArrayList OnDutyTime = new ArrayList();
ArrayList OffDutyTime = new ArrayList();
ArrayList Single_Total = new ArrayList();
ArrayList Sum = new ArrayList();
List <int> Total = new List <int>();
ArrayList Check = new ArrayList();
int Total_SUM = 0;
DGVR.Clear();
String SQL_CMD = "Select OnDutyDate,OnDutyTime,OffDutyTime,Single_total,Check From " + user_name + " WHERE OnDutyDate LIKE '" + Date + "%'";
//"SELECT Meal,Date,nop FROM meal WHERE name LIKE" + "'" + show_customer_LbSelected + "'";
FL_OLE.conn.Open();
cmd.Connection = FL_OLE.conn;
cmd.CommandText = SQL_CMD;
dr = cmd.ExecuteReader();
while (dr.Read())
{
OnDutyDate.Add(dr[0]);
OnDutyTime.Add(dr[1]);
OffDutyTime.Add(dr[2]);
Single_Total.Add(dr[3]);
Check.Add(dr[4]);
// DGVR.Add(dr[0],dr[1], dr[2], dr[3],dr[4]);
}
if (OnDutyDate.Count == 0)
{
DGVR.Add("無資料", "無資料", "無資料", "無資料", "無資料");
}
else
{
//foreach (String all in Single_Total)//處理型態要轉換時間顯示
//{
// Total.Add(Int32.Parse(all));
//}
for (int k = 0; k < Single_Total.Count; k++)
{
if (Single_Total[k].ToString() == "")
{
break;
}
else
{
Total.Add(Int32.Parse(Single_Total[k].ToString()));
}
}
for (int i = 0; i < Total.Count; i++)
{
Total_SUM += Total[i];
Sum.Add(change2Hour(Total[i]).ToString());
textBox1.Text += " 轉型態 : " + change2Hour(Total[i]).ToString();
}
textBox1.Text += OnDutyDate.Count + " " + OnDutyTime.Count + " " + OffDutyTime.Count + " " + Sum.Count + " " + Check.Count;
try
{
if (Sum.Count < OnDutyDate.Count)
{
for (int j = 0; j < OnDutyDate.Count; j++)
{
//55545問題解決
if (j == OnDutyDate.Count - 1)
{
DGVR.Add(OnDutyDate[j], OnDutyTime[j], "尚未打卡下班", "無資料", "無資料");
MessageBox.Show("缺少打卡下班\r\n請管理者補打下班卡\r\n", "警告訊息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DGVR.Add(OnDutyDate[j], OnDutyTime[j], OffDutyTime[j], Sum[j], Check[j]);
}
}
}
else
{
for (int j = 0; j < OnDutyDate.Count; j++)
{
DGVR.Add(OnDutyDate[j], OnDutyTime[j], OffDutyTime[j], Sum[j], Check[j]);
}
}
}
catch (Exception ex)
{
MessageBox.Show("[ 缺少打卡下班 ]\r\n請老闆補打下班卡\r\n才會顯示之後打卡資料\r\n", "提醒訊息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
FL_OLE.conn.Close();
label_sum.Text = "總時數為 : " + change2Hour(Total_SUM);
}
/// <inheritdoc />
public void ShowSettings(DataGridViewRowCollection rows)
{
row = new DataGridViewRow();
DataGridViewDisableCheckBoxCell visibleCell = new DataGridViewDisableCheckBoxCell()
{
Value = VariableNodeSocket.Visible, Enabled = VariableNodeSocket.Connections.Count == 0
};
visibleCell.ValueChanged += (object sender, EventArgs e) =>
{
VariableNodeSocket.Visible = (bool)visibleCell.Value;
if (!VariableNodeSocket.Visible && VariableNodeSocket.Connections.Count != 0)
{
VariableNodeSocket.Visible = true;
}
else
{
Node.Refresh();
}
};
row.Cells.Add(visibleCell);
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = VariableNodeSocket.Name
});
// variable in
if (VariableNodeSocket.Type == NodeSocketType.VariableIn)
{
if (VariableNodeSocket.Connections.Count == 0)
{
// edit value
if (!VariableNodeSocket.NodeSocketData.CanBeEmpty)
{
row.Cells.Add(VariableNodeSocket.Value.GetGridCell());
}
// only connection is possible
else
{
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = "(connection-only)"
});
row.Cells[row.Cells.Count - 1].ReadOnly = true;
}
}
// socket used
else
{
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = "(socket used)"
});
row.Cells[row.Cells.Count - 1].ReadOnly = true;
}
}
// variable out
else
{
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = "(read-only)"
});
row.Cells[row.Cells.Count - 1].ReadOnly = true;
}
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = VariableTypeHelper.FriendlyName(VariableNodeSocket.VariableType)
});
rows.Add(row);
}
private void btnParse_Click(object sender, EventArgs e)
{
try
{
string FileToLoad = Base_Folder_Path + comboBoxFileSelect.Items[comboBoxFileSelect.SelectedIndex].ToString();
if (File.Exists(FileToLoad))
{
if (chkParseParam.Checked || textBoxRE.Text != "")
{
// make sure that all the data is gone before continuing
dataGridView1.Columns.Clear();
StreamReader sr = new StreamReader(FileToLoad, (System.Text.Encoding.GetEncoding(1252)));
string ToParse = sr.ReadToEnd();
Regex temprx;
MatchCollection tmatches;
String WideCondition = "";
String NarrowCondition = "";
// Use built in REexpression
if (chkParseParam.Checked)
{
// First parse out what we need from the selection box
temprx = new Regex(@"\d\)\s(?<sename>.*)\s-\s(?<pname>.*).txt");
Match tmatch = temprx.Match(comboBoxFileSelect.Items[comboBoxFileSelect.SelectedIndex].ToString());
// Now Assign the correct RE
NarrowCondition = tmatch.Groups["sename"].ToString();
WideCondition = tmatch.Groups["pname"].ToString();
temprx = p_DailyR.GetRESubExpression(NarrowCondition); //, tmatch.Groups["pname"].ToString());
}
else
{
temprx = new Regex(@textBoxRE.Text);
}
string[] Groups = temprx.GetGroupNames();
int noOfGroups = 0; // we don't need digit groups
// first calculate the number of non-digit groups
foreach (string str in Groups)
{
if (!char.IsDigit(str, 0))
{
++noOfGroups;
}
}
System.Windows.Forms.DataGridViewTextBoxColumn dl = new System.Windows.Forms.DataGridViewTextBoxColumn();
dl.HeaderText = "LineNumber";
dl.Name = "LineNumber";
dl.FillWeight = 25;
this.dataGridView1.Columns.Add(dl);
// Now calculate and draw out the column headers and group names
ArrayList grouplist = new ArrayList();
foreach (string str in Groups)
{
// we only want to show named groups
if (!char.IsDigit(str, 0))
{
System.Windows.Forms.DataGridViewTextBoxColumn dg = new System.Windows.Forms.DataGridViewTextBoxColumn();
dg.HeaderText = str;
dg.Name = str;
dg.FillWeight = (100 / noOfGroups);
this.dataGridView1.Columns.Add(dg);
grouplist.Add(str);
}
}
// Now Parse the TextFile and we'll see what happens yeah! :)
tmatches = temprx.Matches(ToParse);
string[] tstring = new string[(noOfGroups + 1)];
DataGridViewRowCollection rows = this.dataGridView1.Rows;
int it = 1;
foreach (Match tmatch in tmatches)
{
tstring[0] = it.ToString();
// we don't need group 0
for (int i = 1; i < (noOfGroups + 1); ++i)
{
string groupname = grouplist[i - 1].ToString();
if (chkParseParam.Checked)
{
Parser pr = p_DailyR.get_Parser_pointer;
PropertyDetails pd = new PropertyDetails();
Match t = tmatch;
pr.ParsePropertyDetail(ref t, WideCondition, NarrowCondition, ref pd);
if (groupname == "addr")
{
tstring[i] = pd.Address;
}
else if (groupname == "city")
{
tstring[i] = pd.City;
}
else if (groupname == "zip")
{
tstring[i] = pd.ZipCode.ToString();
}
else
{
tstring[i] = tmatch.Groups[groupname].ToString();
}
}
else
{
tstring[i] = tmatch.Groups[groupname].ToString();
}
}
++it;
rows.Add(tstring);
}
}
else
{
MessageBox.Show("Enter Regular Expression");
}
}
}
catch (Exception eC)
{
MessageBox.Show("Regulare Expression Error - " + eC.Message);
}
}
/*
* --------------------------------------------------------------------------------------------
* IMPLEMENTATION TO BE USED IN LAB 2.
* --------------------------------------------------------------------------------------------
*/
// Here you need to implement your own methods that call the stored procedures
// addStudent and addStudentPhoneNo
public bool CallSPAddStudent(string studentID, string firstName, string lastName, string gender, string streetAddress, string zipCode, string city, string country, string birthDate, string studentType, DataGridViewRowCollection phoneEntries)
{
if (studentID.Length == 0 || studentID.Length > 8)
{
MessageBox.Show("Error: Incorrect student ID", "Data validation error");
return(false);
}
if (firstName.Length == 0 || firstName.Length > 50)
{
MessageBox.Show("Error: Incorrect first name", "Data validation error");
return(false);
}
if (lastName.Length == 0 || lastName.Length > 50)
{
MessageBox.Show("Error: Incorrect last name", "Data validation error");
return(false);
}
if (gender != "male" && gender != "female")
{
MessageBox.Show("Error: Incorrect gender", "Data validation error");
return(false);
}
if (streetAddress.Length > 100)
{
MessageBox.Show("Error: Incorrect street address", "Data validation error");
return(false);
}
if (city.Length == 0 || city.Length > 50)
{
MessageBox.Show("Error: Incorrect city", "Data validation error");
return(false);
}
if (country.Length == 0 || country.Length > 50)
{
MessageBox.Show("Error: Incorrect country", "Data validation error");
return(false);
}
if (studentType.Length == 0 || studentType.Length > 50)
{
MessageBox.Show("Error: Incorrect student type", "Data validation error");
return(false);
}
for (int i = 0; i < phoneEntries.Count - 1; i++)
{
if ((String)phoneEntries[i].Cells[0].Value == null)
{
MessageBox.Show($"Error: Type is missing for phone number field no. {i + 1}.", "Data validation error");
return(false);
}
else if ((String)phoneEntries[i].Cells[1].Value == null)
{
MessageBox.Show($"Error: Number is missing for phone number field no. {i + 1}.", "Data validation error");
return(false);
}
}
int rowsAffected;
// Call the stored procedure
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("addStudent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentID", studentID);
cmd.Parameters.AddWithValue("@FirstName", firstName);
cmd.Parameters.AddWithValue("@LastName", lastName);
cmd.Parameters.AddWithValue("@Gender", gender);
cmd.Parameters.AddWithValue("@StreetAddress", streetAddress);
cmd.Parameters.AddWithValue("@ZipCode", zipCode);
cmd.Parameters.AddWithValue("@City", city);
cmd.Parameters.AddWithValue("@Country", country);
cmd.Parameters.AddWithValue("@BirthDate", birthDate);
cmd.Parameters.AddWithValue("@StudentType", studentType);
rowsAffected = cmd.ExecuteNonQuery();
for (int i = 0; i < phoneEntries.Count - 1; i++)
{
cmd = new SqlCommand("addStudentPhoneNo", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@studentID", studentID);
cmd.Parameters.AddWithValue("@phoneType", (String)phoneEntries[i].Cells[0].Value);
cmd.Parameters.AddWithValue("@number", (String)phoneEntries[i].Cells[1].Value);
cmd.ExecuteNonQuery();
}
} catch (SqlException exception)
{
// non-unique StudentID
if (exception.Number == 2627)
{
MessageBox.Show("Error: Student with this ID already exists", "Primary key violation");
}
else
{
MessageBox.Show($"Error: {exception.Message}", "SQL Error");
}
con.Close();
return(false);
}
con.Close();
return(rowsAffected > 0);
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (!validacion())
{
return;
}
entradasmat c = new entradasmat();
c.nsis = this.textBox1.Text.Trim();
c.nrec = this.textBox2.Text.Trim();
c.fech = this.dateTimePicker1.Value;
c.prov = this.comboBox3.SelectedValue.ToString();
c.mat = this.comboBox2.SelectedValue.ToString();
c.equ = this.textBox3.Text.Trim();
c.ope = this.textBox14.Text.Trim();
c.rkm = Convert.ToDecimal(this.textBox4.Text.Trim());
c.volm = Convert.ToDecimal(this.textBox5.Text.Trim());
c.cosm = Convert.ToDecimal(this.textBox6.Text.Trim());
c.flem = Convert.ToDecimal(this.textBox7.Text.Trim());
c.ttra = this.comboBox1.SelectedValue.ToString();
c.matfle = Convert.ToDecimal(c.Matfle);
c.tifkm = Convert.ToDecimal(c.Tifkm);
c.timat = Convert.ToDecimal(c.Timat);
c.hfin = this.maskedTextBox2.Text;
c.hini = this.maskedTextBox1.Text;
c.dcarg = this.comboBox4.SelectedValue.ToString();
c.usu = Operaciones.op_var.usu;
TimeSpan a = TimeSpan.Parse(c.hfin) - TimeSpan.Parse(c.hini);
this.label5.Text = "Tiempo de Respuesta: " + a.ToString();
//this.label15.Text = String.Format("{0:0.00}",c.matfle);
//this.textBox10.Text =String.Format("{0:0.00}", c.tifkm);
//this.textBox11.Text=String.Format("{0:0.00}",c.timat);
//c.matfle = Convert.ToDecimal(this.label15.Text.Trim());
//c.tifkm = Convert.ToDecimal(this.textBox10.Text.Trim());
//c.timat = Convert.ToDecimal(this.textBox11.Text.Trim());
dataGridView1.Visible = true;
DataGridViewRowCollection dr = dataGridView1.Rows;
dr.Clear();
dr.Add("INGRESO POR FLETE - KM", c.tifkm.ToString("c"));
dr.Add("INGRESO POR MATERIAL", c.timat.ToString("c"));
dr.Add("TOTAL", c.matfle.ToString("c"));
int rowsAffected = 0;
if (string.IsNullOrEmpty(_id))
{
rowsAffected = op_entradasmat.accion(c, 1);
}
else
{
this.textBox1.ReadOnly = true;
//this.textBox12.ReadOnly = true;
rowsAffected = op_entradasmat.accion(c, 2);
}
if (rowsAffected > 0)
{
if (rowsAffected == 1)
{
MessageBox.Show(mensajes.MsjProc1, Application.ProductName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information);
operacion();
this.toolStripButton3.Visible = true;
this.toolStripButton1.Visible = false;
}
if (rowsAffected == 2)
{
MessageBox.Show(mensajes.MsjProc2, Application.ProductName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information);
operacion();
this.toolStripButton3.Visible = true;
this.toolStripButton1.Visible = false;
}
if (rowsAffected == 3)
{
MessageBox.Show(mensajes.MsjProc3, Application.ProductName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (rowsAffected == 4)
{
if (MessageBox.Show(mensajes.MsjProc4 + " " + mensajes.MsjProc5, Application.ProductName.ToString(), MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
rowsAffected = op_entradasmat.accion(c, 2);
}
}
}
else
{
MessageBox.Show(mensajes.MsjProc0, Application.ProductName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
//this.label10.Text = "EMPLEADO: " + c.NombreCompleto;
}
///<summary>
/// 修改节点时需要调用的传值方法
///</summary>
public void modify()
{
DisplayName.Text = Basic[0];
if (Basic[1] != "")
{
MColorChange = true;
ModuleColorRGB = StrToRGB(Basic[1]);
ModuleOfColor.BackColor = Color.FromArgb(ModuleColorRGB[1], ModuleColorRGB[2], ModuleColorRGB[3]);
}
else
{
ModuleOfColor.BackColor = tabPage1.BackColor;
}
ModuleSort.Text = Basic[2];
ModuleName.Text = Basic[3];
if (Basic[4] != "")
{
TColorChange = true;
TextColorRGB = StrToRGB(Basic[4]);
TextOfColor.BackColor = Color.FromArgb(TextColorRGB[1], TextColorRGB[2], TextColorRGB[3]);
}
else
{
TextOfColor.BackColor = tabPage1.BackColor;
}
OutputName.Text = Basic[5];
this.InputInfo = Basic[6];
if (Basic[6].Split(';').Length > 1)
{
string[] temp = Basic[6].Split(';');
List <string> tempInfo = new List <string>();
foreach (string info in temp)
{
tempInfo.Add(info.Split(',')[0]);
}
InputName.Text = String.Join(",", tempInfo.ToArray());
}
else
{
InputName.Text = Basic[6];//输入初值信息20090616
}
ControlTacticName.Text = Basic[7];
DataGridViewRowCollection rows = this.dataGridView1.Rows;
for (int i = 0; i < index2; i++)
{
rows.Add(function[i, 0], function[i, 1], function[i, 2], function[i, 3], function[i, 4],
function[i, 5], function[i, 6], function[i, 7], function[i, 8], function[i, 9]);
}
OtherInfo = code;
infoName.SelectedIndex = 0;
infoText.Text = code[0];
if (index2 == 0)//没有功能属性
{
DeleteFunction.Enabled = false;
ModifyFunction.Enabled = false;
}
if (FirstTime == true)
{
Savemode = true;
FirstTime = false;
}
}
private void frmmovimientosdetEXT_Load(object sender, EventArgs e)
{
//textBox7.Text = op_sql.parametro1("Select flete from conf_transp");
IntPtr hmenu = GetSystemMenu(this.Handle, 0);
int cnt = GetMenuItemCount(hmenu);
// remove 'close' action
RemoveMenu(hmenu, cnt - 1, MF_DISABLED | MF_BYPOSITION);
// remove extra menu line
RemoveMenu(hmenu, cnt - 2, MF_DISABLED | MF_BYPOSITION);
DrawMenuBar(this.Handle);
//int hora=DateTime.Now.Hour;
//int minuto = DateTime.Now.Minute;
//maskedTextBox1.Text = DateTime.Now.Hour();
textBox1.Text = op_sql.parametro("Select num from tmpautonumerico where tabla=@tabla", "tabla", "entmat").PadLeft(10, '0');
//textBox12.Text = DateTime.Now.ToShortDateString();
comboBox3.DataSource = op_combos.FillCombo("select cod, nom from proveedores order by 2");
comboBox3.DisplayMember = "nom";
comboBox3.ValueMember = "cod";
comboBox3.Text = null;
comboBox4.DataSource = op_combos.FillCombo("select idproy as cod, nomproy as nom from proyectos where activo=1 order by 2");
comboBox4.DisplayMember = "nom";
comboBox4.ValueMember = "cod";
comboBox4.Text = null;
comboBox1.DataSource = op_documentos.transaccion();
comboBox1.DisplayMember = "nom";
comboBox1.ValueMember = "cod";
comboBox1.Text = null;
if (!string.IsNullOrEmpty(_id))
{
entradasmat c = op_entradasmat.GellIdentradasmat(_id, 1);
if (c != null)
{
this.Text = "Editando Registro: [Recibo: " + c.nrec + " Equipo: " + c.equ + "]";
this.textBox1.Text = c.nsis;
this.textBox2.Text = c.nrec;
this.textBox3.Text = c.equ;
this.textBox7.Text = c.flem.ToString();
this.comboBox2.SelectedValue = c.mat;
this.comboBox3.SelectedValue = c.prov;
this.comboBox4.SelectedValue = c.dcarg;
this.textBox14.Text = c.ope;
this.maskedTextBox2.Text = c.hfin;
this.maskedTextBox1.Text = c.hini;
this.dateTimePicker1.Value = c.fech;
this.textBox4.Text = c.rkm.ToString();
this.textBox5.Text = c.volm.ToString();
this.textBox6.Text = c.cosm.ToString();
this.comboBox1.SelectedValue = c.ttra;
TimeSpan a = TimeSpan.Parse(c.hfin) - TimeSpan.Parse(c.hini);
this.label5.Text = "Tiempo de Respuesta: " + a.ToString();
dataGridView1.Visible = true;
DataGridViewRowCollection dr = dataGridView1.Rows;
dr.Clear();
dr.Add("INGRESO POR FLETE - KM", c.Tifkm.ToString("c"));
dr.Add("INGRESO POR MATERIAL", c.Timat.ToString("c"));
dr.Add("TOTAL", c.matfle.ToString("c"));
this.textBox13.Text = op_sql.parametro("select nomempl from empleados where codempl=@cod order by 1", "@cod", c.ope);
toolStripButton5.Visible = true;
toolStripButton1.Visible = false;
toolStripButton3.Visible = false;
operacion();
//foreach (Control u in this.Controls)
//{
// if (u is Button)
// u.Enabled = true;
//}
}
}
else
{
toolStripButton3.Visible = false;
toolStripButton5.Visible = false;
toolStripButton1.Visible = true;
this.label5.Text = null;
this.Text = "Nuevo Registro - Entrada de Materiales";
}
textBox3.AutoCompleteCustomSource = Operaciones.autocompletar.LoadAutoComplete();
textBox3.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox3.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
public ListEditor()
{
InitializeComponent();
listref = listBox.Rows;
}
public Frequencia(DataGridViewRowCollection rows, int columnCount)
{
this.Rows = rows;
this.ColumnCount = columnCount;
}
private void search_single_staff(excel.Worksheet sheet)
{
DataGridViewRowCollection DGVC = dataGridView_check.Rows;
ArrayList staff_name = new ArrayList();
ArrayList staff_OnDuty_Date = new ArrayList();
ArrayList staff_OnDuty_Time = new ArrayList();
ArrayList staff_OffDuty_Time = new ArrayList();
ArrayList staff_check = new ArrayList();
ArrayList staff_remark = new ArrayList();
ArrayList staff_single = new ArrayList();
ArrayList all_time = new ArrayList();
ArrayList all_name = new ArrayList();
for (int i = 0; i < Input_Employee_2combo.Count; i++)
{
staff_single.Clear();
String SQL_CMD = "Select * From " + Input_Employee_2combo[i].ToString() + " WHERE OnDutyDate LIKE '" + (DateTime.Now.Year - 1911).ToString() + "/"
+ (DateTime.Now.Month - 1) + "/%'";
List <int> count_time = new List <int>();
int total_single = 0;
FL_OLE.conn.Open();
cmd.Connection = FL_OLE.conn;
cmd.CommandText = SQL_CMD;
dr = cmd.ExecuteReader();
while (dr.Read())
{
staff_name.Add(dr[1]);
staff_OnDuty_Date.Add(dr[2]);
staff_OnDuty_Time.Add(dr[3]);
staff_OffDuty_Time.Add(dr[4]);
staff_single.Add(dr[5]);
staff_check.Add(dr[6]);
staff_remark.Add(dr[7]);
// DGVC.Add(Input_Employee_2combo[i].ToString(), "當月無上班資料", "當月無上班資料", "當月無上班資料", "當月無上班資料", "當月無上班資料", "當月無上班資料");
DGVC.Add(dr[1], dr[2], dr[3], dr[4], dr[5], dr[6], dr[7]);
}
FL_OLE.conn.Close();
for (int j = 0; j < staff_single.Count; j++)
{
if (staff_single[j].ToString() == "")
{
count_time.Add(0);
}
else
{
count_time.Add(Int32.Parse(staff_single[j].ToString()));
}
}
for (int k = 0; k < count_time.Count; k++)
{
if (staff_check[k].ToString() != "未審核上班")
{
total_single += count_time[k];
}
}
all_name.Add(Input_Employee_2combo[i].ToString());
all_time.Add("[" + (DateTime.Now.Month - 1) + "月] 時數 : " + FL_OLE.change2Hour(total_single));
//DGVC.Add("", "", "", "", "", "" ,Input_Employee_2combo[i].ToString() +"[" +(DateTime.Now.Month - 1) + "月] 時數 = "+FL_OLE.change2Hour(total_single));
}
//DGVC.Add("", "", "", "員工名字", "總時數統計", "", "");
sheet.Cells[1, 9] = "員工名字";
sheet.Cells[1, 10] = "總時數統計";
for (int i = 0; i < all_time.Count; i++)
{
sheet.Cells[i + 2, 9] = all_name[i].ToString();
sheet.Cells[i + 2, 10] = all_time[i].ToString();
//DGVC.Add("", "", "", all_name[i].ToString(), all_time[i].ToString(), "", "");
}
sheet.Cells[all_time.Count + 2, 10] = "※注意 顯示未審核上班 不列入總時數統計";
//DGVC.Add("", "", "", "", "※注意 顯示未審核上班 不列入總時數統計", "", "");
sheet.Cells[1, 1] = "姓名";
sheet.Cells[1, 2] = "上班日期";
sheet.Cells[1, 3] = "上班時間";
sheet.Cells[1, 4] = "下班時間";
sheet.Cells[1, 5] = "單日上班時數(分鐘)";
sheet.Cells[1, 6] = "上班審核";
sheet.Cells[1, 7] = "備註";
for (int l = 0; l < DGVC.Count; l++)
{
for (int j = 0; j < dataGridView_check.Columns.Count; j++)
{
string value = dataGridView_check[j, l].Value.ToString();
sheet.Cells[l + 2, j + 1] = value;
}
}
sheet.Columns.EntireColumn.AutoFit();
}
public static void export(DateTime currMonth, DataGridViewRowCollection rows,
string templatePath, string exportPath)
{
Excel.Application app = new Excel.Application();
app.Visible = true; // DEBUG
Excel.Workbook workbook = app.Workbooks.Open(templatePath);
Excel.Worksheet wsheet = (Excel.Worksheet)workbook.ActiveSheet;
// Set Month
((Excel.Range)wsheet.Cells[2, 2]).Value2 = engMonths[currMonth.Month - 1];
// Set year:
((Excel.Range)wsheet.Cells[3, 2]).Value2 = currMonth.Year;
int currentCol = 5;
foreach (DataGridViewRow row in rows)
{
try
{
TimeSpan rowWorkLength = TimeSpan.Parse((string)row.Cells["cTIME"].Value);
TimeSpan rowStartTime = TimeSpan.Parse((string)row.Cells["cStart"].Value);
if (rowWorkLength.TotalMinutes > 0)
{
if (rowWorkLength < minWorkdayLength)
{
throw new Exception("Not enough hours for this day!");
}
TimeSpan rowBreakLength = TimeSpan.Zero;
if (rowWorkLength > minWorkForBreak)
{
rowBreakLength = breakLength;
}
HourTypeRow workType = HourTypeRow.WORK;
if (rowWorkLength - rowBreakLength < minWorkForBreak)
{
// if you work 6.10 but taken 0.5 break you left with 5.4 and not qulify
// for break, so we need special code:
workType = HourTypeRow.WORK_FORCE_BREAK;
}
((Excel.Range)wsheet.Cells[workType, currentCol]).Value
= timeStr(rowStartTime);
((Excel.Range)wsheet.Cells[workType, currentCol + 1]).Value
= timeStr(rowStartTime + rowWorkLength - rowBreakLength);
if (rowBreakLength.TotalMinutes > 0)
{
((Excel.Range)wsheet.Cells[HourTypeRow.BREAK, currentCol]).Value
= timeStr(rowStartTime + rowWorkLength - rowBreakLength);
((Excel.Range)wsheet.Cells[HourTypeRow.BREAK, currentCol + 1]).Value
= timeStr(rowStartTime + rowWorkLength);
}
}
else
{
// No work hours ! Find reason:
DataGridViewComboBoxCell cell =
((DataGridViewComboBoxCell)row.Cells["cOther"]);
rowWorkLength = fulldayLength;
rowStartTime = defaultDayStart;
if (cell.Value == null)
{
throw new Exception("No time and no reason!");
}
else
{
int reasonIndex = cell.Items.IndexOf(cell.Value);
if (reasonIndex == 0)
{
// Ignore
}
else
{
int rowIndex = (int)HourTypeRow.OTHER_START - 1 + reasonIndex;
((Excel.Range)wsheet.Cells[rowIndex, currentCol]).Value = timeStr(rowStartTime);
((Excel.Range)wsheet.Cells[rowIndex, currentCol + 1]).Value = timeStr(rowStartTime + rowWorkLength);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error on date:" + row.Cells[0].Value.ToString() + Environment.NewLine +
ex.Message + Environment.NewLine + ex.StackTrace
);
}
currentCol += 3;
}
workbook.SaveAs(exportPath);
workbook.Close(SaveChanges: false);
app.Quit();
}
private void inventoryLoadData(int pageNum)
{
int importTotal = 0, exportTotal = 0, itemTotal = 0, netTotal = 0, returnTotal = 0;
dgvInventory.Rows.Clear();
DataGridViewRowCollection rows = dgvInventory.Rows;
InventroyRPTInfo view = new InventroyRPTInfo(APConfig.Conn);
view.Conditions = " 1=1 ";
if (!string.IsNullOrEmpty(txtInventoryName.Text))
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.name.ToString(), txtInventoryName.Text);
}
if (!string.IsNullOrEmpty(dpkInventoryINSDTTM.Value.ToString()) && ckbInventoryINDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.importSDTTM.ToString(), dpkInventoryINSDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkInventoryINEDTTM.Value.ToString()) && ckbInventoryINDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.importEDTTM.ToString(), dpkInventoryINEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkInventoryOUTSDTTM.Value.ToString()) && ckbInventoryOUTDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.exportSDTTM.ToString(), dpkInventoryOUTSDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkInventoryOUTEDTTM.Value.ToString()) && ckbInventoryOUTDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.exportEDTTM.ToString(), dpkInventoryOUTEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkInventoryRETURNSDTTM.Value.ToString()) && ckbInventoryRETURNDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.returnSDTTM.ToString(), dpkInventoryRETURNSDTTM.Value.ToString("yyyy/MM/dd"));
}
if (!string.IsNullOrEmpty(dpkInventoryRETURNEDTTM.Value.ToString()) && ckbInventoryRETURNDTTM.Checked)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.returnEDTTM.ToString(), dpkInventoryRETURNEDTTM.Value.ToString("yyyy/MM/dd"));
}
if (ddlInventoryVendor.SelectedIndex != 0)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.vendor.ToString(), ddlInventoryVendor.SelectedItem.ToString());
}
if (ddlInventoryDealer.SelectedIndex != 0)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.dealer.ToString(), ddlInventoryDealer.SelectedItem.ToString());
}
if (ddlInventoryStatus.SelectedIndex != 0)
{
view.Conditions += " AND " + view.getCondition(InventroyRPTInfo.ncConditions.status.ToString(), ddlInventoryStatus.SelectedItem.ToString());
}
view.condFormat(string.Format(" AND {0} ", view.Conditions));
//組排序指令
if (dgvInventory.SortedColumn is null)
{
view.OrderBy = view.getOptionOrderBy(RosterDial_RInfo.ncSort.Default.ToString());
}
else
{
string sortname = dgvInventory.SortedColumn.Name;
string sortmode = APConfig.GetValueFromDescription <SortMode>(dgvInventory.SortOrder.ToString()).ToString();
view.OrderBy = string.Format("{0} {1}", view.getOptionOrderBy(sortname), sortmode);
}
//查詢頁數初始化且自動跳轉至第一頁
if (pageNum == 0)
{
APConfig.loadPage(ddlInventoryPage, view.calculatePage(APConfig.PageCount));
return;
}
//塞入資料
DataSet ds = APConfig.GoPage(view.SQLStatement, pageNum);
foreach (DataRow dr in ds.Tables[0].Rows)
{
rows.Add(new Object[] { dr.ItemArray[4], dr.ItemArray[0], dr.ItemArray[1], dr.ItemArray[2], dr.ItemArray[3], dr.ItemArray[5], dr.ItemArray[6], dr.ItemArray[7], dr.ItemArray[8], dr.ItemArray[9], dr.ItemArray[10], dr.ItemArray[11], dr.ItemArray[12] });
}
//計算總合
if (view.load())
{
while (!view.IsEof)
{
importTotal += view.INTOTAL;
exportTotal += view.OUTTOTAL;
netTotal += view.NET;
returnTotal += view.RETURNTOTAL;
itemTotal += Convert.ToInt32(view.STOCK);
view.next();
}
}
lblInventoryTotal.Text = string.Format("{0}", itemTotal.ToString());
lblInventoryINAMT.Text = string.Format("{0:n0} 元", importTotal);
lblInventoryOUTAMT.Text = string.Format("{0:n0} 元", exportTotal);
lblInventoryRETURNAMT.Text = string.Format("{0:n0} 元", returnTotal);
lblInventoryNETTotal.Text = string.Format("{0:n0} 元", netTotal);
}
public static IEnumerable <T> Select <T>(this DataGridViewRowCollection rows, Func <DataGridViewRow, T> selector)
{
return(rows.Cast <DataGridViewRow>().Select(selector));
}
/// <summary>
/// printReport
/// PDFを出力する
/// </summary>
private void printReport()
{
//PDF作成後の入れ物
string strFile = "";
//データの取り出し用
DataTable dtPrintData = new DataTable();
//列情報を取得
DataGridViewColumnCollection cols = gridTokuteimukesakiTanka.Columns;
//行情報を取得
DataGridViewRowCollection rows = gridTokuteimukesakiTanka.Rows;
//取引先経理情報登録時の情報
List <string> lstTorihiki = new List <string>();
foreach (DataGridViewColumn c in cols)
{
if (c.ValueType != null)
{
dtPrintData.Columns.Add(c.Name, c.ValueType);
}
else
{
dtPrintData.Columns.Add(c.Name);
}
}
foreach (DataGridViewRow r in rows)
{
List <object> array = new List <object>();
foreach (DataGridViewCell cell in r.Cells)
{
array.Add(cell.Value);
}
dtPrintData.Rows.Add(array.ToArray());
}
//ビジネス層のインスタンス生成
M1160_TokuteimukesakiTanka_B tokuteimukesakitankaB = new M1160_TokuteimukesakiTanka_B();
try
{
//初期値
Common.Form.PrintForm pf = new Common.Form.PrintForm(this, "", CommonTeisu.SIZE_A4, YOKO);
pf.ShowDialog(this);
//プレビューの場合
if (this.printFlg == CommonTeisu.ACTION_PREVIEW)
{
this.Cursor = Cursors.WaitCursor;
//現在時間と使用者ＰＣユーザー名を確保
lstTorihiki.Add(DateTime.Now.ToString());
lstTorihiki.Add(SystemInformation.UserName);
//結果セットをレコードセットに
strFile = tokuteimukesakitankaB.dbToPdf(dtPrintData, lstTorihiki);
this.Cursor = Cursors.Default;
//印刷できなかった場合
if (strFile == "")
{
//印刷時エラーメッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, "印刷", "印刷時エラーです。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
// プレビュー
pf.execPreview(strFile);
}
// 一括印刷の場合
else if (this.printFlg == CommonTeisu.ACTION_PRINT)
{
this.Cursor = Cursors.WaitCursor;
//現在時間と使用者ＰＣユーザー名を確保
lstTorihiki.Add(DateTime.Now.ToString());
lstTorihiki.Add(SystemInformation.UserName);
//結果セットをレコードセットに
strFile = tokuteimukesakitankaB.dbToPdf(dtPrintData, lstTorihiki);
this.Cursor = Cursors.Default;
//印刷できなかった場合
if (strFile == "")
{
//印刷時エラーメッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, "印刷", "印刷時エラーです。", CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
// 一括印刷
pf.execPrint(null, strFile, CommonTeisu.SIZE_A4, CommonTeisu.YOKO, true);
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
//エラーロギング
new CommonException(ex);
//例外発生メッセージ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_ERROR, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
return;
}
}
public void ScenariosView_GenerateCalculations_ChangesCorrectlyObservedAndSynced()
{
// Setup
var mocks = new MockRepository();
var messageProvider = mocks.Stub <IImporterMessageProvider>();
mocks.ReplayAll();
using (var form = new Form())
{
var assessmentSection = new AssessmentSection(AssessmentSectionComposition.Dike);
DataImportHelper.ImportReferenceLine(assessmentSection);
StabilityPointStructuresFailureMechanism failureMechanism = assessmentSection.StabilityPointStructures;
DataImportHelper.ImportFailureMechanismSections(assessmentSection, failureMechanism);
CalculationGroup calculationsGroup = assessmentSection.StabilityPointStructures.CalculationsGroup;
var view = new StabilityPointStructuresScenariosView(calculationsGroup, assessmentSection.StabilityPointStructures);
form.Controls.Add(view);
form.Show();
var structuresImporter = new StabilityPointStructuresImporter(assessmentSection.StabilityPointStructures.StabilityPointStructures,
assessmentSection.ReferenceLine, filePath, messageProvider,
new StabilityPointStructureReplaceDataStrategy(failureMechanism));
structuresImporter.Import();
var listBox = (ListBox) new ControlTester("listBox").TheObject;
var dataGridView = (DataGridView) new ControlTester("dataGridView").TheObject;
listBox.SelectedItem = failureMechanism.Sections.ElementAt(50);
// Precondition
DataGridViewRowCollection rows = dataGridView.Rows;
CollectionAssert.IsEmpty(rows);
// Call
foreach (StabilityPointStructure structure in assessmentSection.StabilityPointStructures.StabilityPointStructures)
{
calculationsGroup.Children.Add(new StructuresCalculationScenario <StabilityPointStructuresInput>
{
Name = NamingHelper.GetUniqueName(((CalculationGroup)view.Data).Children, structure.Name, c => c.Name),
InputParameters =
{
Structure = structure
}
});
}
calculationsGroup.NotifyObservers();
// Assert
Assert.AreEqual(1, rows.Count);
DataGridViewCellCollection cells = rows[0].Cells;
Assert.AreEqual(4, cells.Count);
Assert.IsTrue(Convert.ToBoolean(cells[isRelevantColumnIndex].FormattedValue));
Assert.AreEqual(new RoundedDouble(2, 100).ToString(), cells[contributionColumnIndex].FormattedValue);
Assert.AreEqual("Eerste kunstwerk punt 6-3", cells[nameColumnIndex].FormattedValue);
Assert.AreEqual("-", cells[failureProbabilityColumnIndex].FormattedValue);
}
mocks.VerifyAll();
}
