private void setControl() { matr = mposC.mposDB.matrDB.selectByPk1(matr_id); txtMatrId.Value = matr.matr_id; if (matr.matr_date.Length > 0) { txtMatrDate.Value = mposC.datetoShow(matr.matr_date); } txtRemark.Value = matr.remark; txtMatrCode.Value = matr.matr_code; setGrfMatr(); }
private void setControl() { matd = mposC.mposDB.matdDB.selectByPk1(matd_id); txtMatdId.Value = matd.matd_id; if (matd.matd_date.Length > 0) { txtMatrDate.Value = mposC.datetoShow(matd.matd_date); } txtRemark.Value = matd.remark; txtMatdCode.Value = matd.matd_code; setGrfMatd(); }
private void setGrfMatr() { DataTable dt = new DataTable(); dt = mposC.mposDB.matrDB.selectByYearId(cboYear.Text); grfMatr.Rows.Count = 1; grfMatr.Cols.Count = 9; grfMatr.Cols[colcode].Width = 120; grfMatr.Cols[colDate].Width = 120; grfMatr.Cols[colRemark].Width = 200; grfMatr.Cols[colTotal].Width = 120; grfMatr.Cols[colCnt].Width = 120; grfMatr.Cols[colRemark].Width = 60; grfMatr.Cols[colcode].Caption = "เลขที่"; grfMatr.Cols[colDate].Caption = "วันที่"; grfMatr.Cols[colRemark].Caption = "หมายเหตุ"; grfMatr.Cols[colTotal].Caption = "รวมราคา"; grfMatr.Cols[colCnt].Caption = "รวมจำนวน"; //grfMatr.Cols[colName].Editor = cboMethod; grfMatr.ShowCursor = true; if (dt.Rows.Count == 0) { grfMatr.Rows.Count = 2; } int i = 0; foreach (DataRow row in dt.Rows) { i++; Row row1 = grfMatr.Rows.Add(); row1[0] = i; row1[colID] = row[mposC.mposDB.matrDB.matr.matr_id].ToString(); row1[colcode] = row[mposC.mposDB.matrDB.matr.matr_code].ToString(); row1[colDate] = mposC.datetoShow(row[mposC.mposDB.matrDB.matr.matr_date].ToString()); row1[colRemark] = row[mposC.mposDB.matrDB.matr.remark].ToString(); row1[colTotal] = row["total1"].ToString(); row1[colCnt] = row["cnt"].ToString(); row1[colEdit] = "0"; if (i % 2 == 0) { row1.StyleNew.BackColor = ColorTranslator.FromHtml(mposC.iniC.grfRowColor); } } grfMatr.Cols[colID].Visible = false; grfMatr.Cols[colEdit].Visible = false; grfMatr.Cols[colcode].AllowEditing = false; grfMatr.Cols[colDate].AllowEditing = false; grfMatr.Cols[colRemark].AllowEditing = false; }
private void setGrf(C1FlexGrid grf, String matid) { grf.Clear(); DataTable dt = new DataTable(); dt = mposC.mposDB.stkDB.selectByMatId(matid); //grfExpn.Rows.Count = dt.Rows.Count + 1; grf.Rows.Count = dt.Rows.Count + 1; //grfSperm.DataSource = dt; grf.Cols.Count = 7; grf.Cols[colCode].Caption = "วันที่"; grf.Cols[colName].Caption = "รายการ"; grf.Cols[colPrice].Caption = "Price"; grf.Cols[colWeight].Caption = "Weight"; grf.Cols[colOnhand].Caption = "OnHand"; grf.Cols[colCode].Width = 120; grf.Cols[colName].Width = 200; grf.Cols[colPrice].Width = 120; grf.Cols[colWeight].Width = 120; grf.Cols[colOnhand].Width = 120; grf.ShowCursor = true; int i = 0; decimal aaa = 0; foreach (DataRow row in dt.Rows) { try { i++; //if (i == 1) continue; //Decimal.TryParse(row[ic.ivfDB.oLabiDB.labI.Price].ToString(), out aaa); grf[i, colId] = row[mposC.mposDB.stkDB.stkc.stock_id].ToString(); grf[i, colCode] = mposC.datetoShow(row[mposC.mposDB.stkDB.stkc.rec_draw_date].ToString()); grf[i, colName] = row[mposC.mposDB.stkDB.stkc.status_rec_draw].ToString().Equals("1") ? "รับเข้า" : row[mposC.mposDB.stkDB.stkc.status_rec_draw].ToString().Equals("2") ? "เบิกจ่าย" : row[mposC.mposDB.stkDB.stkc.status_rec_draw].ToString().Equals("3") ? "ขาย" : "อื่นๆ"; grf[i, colPrice] = row[mposC.mposDB.stkDB.stkc.price].ToString(); grf[i, colWeight] = row[mposC.mposDB.stkDB.stkc.weight].ToString(); grf[i, colOnhand] = row[mposC.mposDB.stkDB.stkc.onhand].ToString(); //grfOrder[i, colRsLotInput] = row[ic.ivfDB.lbresDB.lbRes.lot_input].ToString(); row[0] = (i - 2); } catch (Exception ex) { String err = ""; } } CellNoteManager mgr = new CellNoteManager(grf); grf.Cols[colId].Visible = false; //grfOrder.Cols[colRsLabId].Visible = false; //grfOrder.Cols[colRsReqId].Visible = false; //grfOrder.Cols[colRsEdit].Visible = false; //grfOrder.Cols[colRsLotInput].Visible = false; grf.Cols[colCode].AllowEditing = false; grf.Cols[colOnhand].AllowEditing = false; grf.Cols[colName].AllowEditing = false; grf.Cols[colPrice].AllowEditing = false; grf.Cols[colWeight].AllowEditing = true; //theme1.SetTheme(grfFinish, ic.theme); }