private void OzelDrmAddDict(string tbl, OpsDataSet.OPHRow ophRow, DataColumn dataCol)
{
string ozlDrm;
if (!ophRow.IsNull(dataCol))
{
ozlDrm = opsQueriesTableAdapter.OZEL_DURUM(tbl, ophRow[dataCol].ToString()).ToString();
OzlDrm[dataCol.ColumnName] = ozlDrm;
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
// Duplicate
var view = ophLayoutView;
dRow = (OpsDataSet.OPHRow)view.GetDataRow(view.FocusedRowHandle);
bindingNavigatorAddNewItem.PerformClick();
}
private void layoutView1_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
var view = sender as DevExpress.XtraGrid.Views.Layout.LayoutView;
if (dRow == null)
{
int PK = (int)Program.MF.mainQueriesTableAdapter.GET_PK("OPS");
view.SetRowCellValue(e.RowHandle, colOPHID, PK);
view.SetRowCellValue(e.RowHandle, colNSTU, "B");
view.SetRowCellValue(e.RowHandle, colOWNR, "1");
view.SetRowCellValue(e.RowHandle, colTOB, "B");
view.SetRowCellValue(e.RowHandle, colROT, "E");
view.SetRowCellValue(e.RowHandle, colMOT, "A");
view.SetRowCellValue(e.RowHandle, colORG, "TR");
}
else
{
int PK = (int)Program.MF.mainQueriesTableAdapter.GET_PK("OPS");
view.SetRowCellValue(e.RowHandle, colOPHID, PK);
view.SetRowCellValue(e.RowHandle, colNSTU, "B");
view.SetRowCellValue(e.RowHandle, colOWNR, "1");
view.SetRowCellValue(e.RowHandle, colTOB, "B");
view.SetRowCellValue(e.RowHandle, colROT, "E");
view.SetRowCellValue(e.RowHandle, colMOT, "A");
view.SetRowCellValue(e.RowHandle, colSHPID, dRow["SHPID"]);
view.SetRowCellValue(e.RowHandle, colB_PUDPT, dRow["B_PUDPT"]);
view.SetRowCellValue(e.RowHandle, colORG, dRow["ORG"]);
view.SetRowCellValue(e.RowHandle, colB_SNDINFO, dRow["B_SNDINFO"]);
view.SetRowCellValue(e.RowHandle, colB_NOA, dRow["B_NOA"]);
view.SetRowCellValue(e.RowHandle, colB_NOF, dRow["B_NOF"]);
view.SetRowCellValue(e.RowHandle, colB_NOT, dRow["B_NOT"]);
view.SetRowCellValue(e.RowHandle, colB_NOR, dRow["B_NOR"]);
view.SetRowCellValue(e.RowHandle, colB_CCC, dRow["B_CCC"]);
view.SetRowCellValue(e.RowHandle, colB_KUTUGONDER, dRow["B_KUTUGONDER"]);
view.SetRowCellValue(e.RowHandle, colB_DLGONDER, dRow["B_DLGONDER"]);
view.SetRowCellValue(e.RowHandle, colB_BOXTYP, dRow["B_BOXTYP"]);
view.SetRowCellValue(e.RowHandle, colEOH, dRow["EOH"]);
view.SetRowCellValue(e.RowHandle, colACCID, dRow["ACCID"]);
view.SetRowCellValue(e.RowHandle, colB_TOS, dRow["B_TOS"]);
view.SetRowCellValue(e.RowHandle, colCNEID, dRow["CNEID"]);
view.SetRowCellValue(e.RowHandle, colDST, dRow["DST"]);
view.SetRowCellValue(e.RowHandle, colB_RCVINFO, dRow["B_RCVINFO"]);
view.SetRowCellValue(e.RowHandle, colB_TEMPLATE, dRow["B_TEMPLATE"]);
view.SetRowCellValue(e.RowHandle, colB_PRTNO, dRow["B_PRTNO"]);
view.SetRowCellValue(e.RowHandle, colB_SMPTYP, dRow["B_SMPTYP"]);
view.SetRowCellValue(e.RowHandle, colB_SITENO, dRow["B_SITENO"]);
view.SetRowCellValue(e.RowHandle, colB_MRKBILDIR, dRow["B_MRKBILDIR"]);
view.SetRowCellValue(e.RowHandle, colB_KUTUDONDU, dRow["B_KUTUDONDU"]);
view.SetRowCellValue(e.RowHandle, colB_DLDONDU, dRow["B_DLDONDU"]);
dRow = null;
}
}
private void LoadAll()
{
opsDataSet.Clear();
OzlDrm.Clear();
if (PK == 0) // New
{
newRecord();
return;
}
this.ophTableAdapter.FillByPK(this.opsDataSet.OPH, PK); // House
this.oppTableAdapter.FillByOP(this.opsDataSet.OPP, PK); // Packages
this.opshTableAdapter.FillByOP(this.opsDataSet.OPSH, PK); // StatuHistory
this.opoTableAdapter.FillByOP(this.opsDataSet.OPO, PK); // Orders
this.oprhSelDisTableAdapter.Fill(this.opsDataSet.OPRH_SEL_DIS, 0, PK); //GidenEvrak
if (Program.MF.EntryCheck("Ops.opHouseEditXF.afdoDP", isSilent: true))
{
this.afdoTableAdapter.Fill(this.opsDataSet.AFDO_SEL, string.Format("OPid = {0}", PK), Program.USR); // FaturaDetay
}
afdoGridView.OptionsBehavior.Editable = Program.MF.ModifyCheck("Ops.opHouseEditXF.afdoDP", isSilent: true);
this.oposTableAdapter.ClearBeforeFill = false;
foreach (OpsDataSet.OPORow opoRow in this.opsDataSet.OPO.Rows)
{
this.oposTableAdapter.FillByOPO(this.opsDataSet.OPOS, opoRow.OPOID); // Order SKU's
}
OpsDataSet.OPHRow ophRow = (OpsDataSet.OPHRow) this.opsDataSet.OPH.Rows[0];
if (ophRow != null && !ophRow.IsOPMIDNull())
{
this.opmpTableAdapter.Fill(this.opsDataSet.OPM_PACKAGES, ophRow.OPMID); // Master Packages
this.opcLupMTableAdapter.Fill(this.opsDataSet.OPC_LUP_M, ophRow.OPMID);
}
////this.oph2TableAdapter.FillByPK(this.opsDataSet.OPH2, PK); // OPH+
//OpsDataSet.OPH2Row oph2Row = opsDataSet.OPH2.NewOPH2Row();
//oph2Row.OPHID = PK;
//opsDataSet.OPH2.AddOPH2Row(oph2Row);
foreach (DataColumn dataCol in this.opsDataSet.OPH.Columns)
{
OzlDrm.Add(dataCol.ColumnName, "");
}
OzelDrmAddDict("LOC", ophRow, this.opsDataSet.OPH.ORGColumn);
OzelDrmAddDict("LOC", ophRow, this.opsDataSet.OPH.DSTColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.SHPIDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.MNFIDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.CNEIDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.CRRIDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.DCNIDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.NFYIDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.NF2IDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.ACCIDColumn);
OzelDrmAddDict("FRT", ophRow, this.opsDataSet.OPH.HSRFIDColumn);
OzelDrmAddDict("PRT", ophRow, this.opsDataSet.OPH.PRJIDColumn);
//string islYtkCur, accYtkCur;
//Program.MF.IslAccCurYtk("H", PK, out islYtkCur, out accYtkCur);
//bool ytkOK = Program.MF.YetkiCheck(islYtkCur, true);
//bool accYtkOK = Program.MF.YetkiCheck(accYtkCur, true);
ophLayoutView.OptionsBehavior.Editable = editable && iE; // ytkOK;
oph2LayoutView.OptionsBehavior.Editable = Program.MF.ModifyCheck("Ops.opHouseEditXF.bioDP", isSilent: true) && iE;
oppGridView.OptionsBehavior.Editable = editable && iE;
opoGridView.OptionsBehavior.Editable = editable && iE;
oposGridView.OptionsBehavior.Editable = editable && iE;
afdoGridView.OptionsBehavior.Editable = Program.MF.ModifyCheck("Ops.opHouseEditXF.afdoDP", isSilent: true) && aE; // accYtkOK;
godInfMemoEdit.Enabled = editable && iE;
hndInfMemoEdit.Enabled = editable && iE;
othInfMemoEdit.Enabled = editable && iE;
accInfMemoEdit.Enabled = editable && iE;
}
