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