public bool M_Location_InsertUpdate(D_Stock_Entity dse, M_Location_Entity mle)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@xml", new ValuePair {
value1 = SqlDbType.Xml, value2 = dse.xml1
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.Operator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.Key
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Location_InsertUpdate"));
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
mle = GetSearchInfo();
DataTable dt = zibl.M_Location_SelectAll(mle);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
zibl.ShowMessage("E128");
}
}
private M_Location_Entity GetSearchInfo()
{
mle = new M_Location_Entity
{
ChangeDate = ckM_Label1.Text,
SoukoCD = CboFromSoukoCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboFromSoukoCD.SelectedValue.ToString(),
};
return(mle);
}
public bool M_Location_SelectData(M_Location_Entity me)
{
M_Location_DL mldl = new M_Location_DL();
DataTable dt = mldl.M_Location_SelectData(me);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
private M_Location_Entity GetSearchInfo()
{
string ymd = bbl.GetDate();
mle = new M_Location_Entity
{
ChangeDate = ymd,
SoukoCD = cboWarehouse.SelectedValue.ToString().Equals("-1") ? string.Empty : cboWarehouse.SelectedValue.ToString(),
};
return(mle);
}
public DataTable M_Location_Search(M_Location_Entity mle)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.SoukoCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mle.ChangeDate
} }
};
return(SelectData(dic, "M_Location_Search"));
}
public DataTable M_LocationTana_Select(M_Location_Entity mle)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.SoukoCD
} },
{ "@TanaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mle.TanaCD
} }
};
return(SelectData(dic, "M_LocationTana_Select"));
}
public DataTable M_Location_SelectAll(M_Location_Entity me)
{
string sp = "M_Location_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.SoukoCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = me.ChangeDate
} }
};
return(SelectData(dic, sp));
}
private void ScStorage_CodeKeyDownEvent(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (!string.IsNullOrWhiteSpace(ScStorage.TxtCode.Text))
{
mle = new M_Location_Entity();
zibl = new ZaikoIdouNyuuryoku_BL();
mle = GetSearchInfo();
DataTable dt = zibl.M_Location_SelectAll(mle);
if (dt.Rows.Count <= 0)
{
bbl.ShowMessage("E101");
ScStorage.SetFocus(1);
}
}
}
}
private void InsertUpdate(D_Stock_Entity dse, M_Location_Entity mle)
{
//*** Insert Update Function
if (tnbnBL.M_Location_InsertUpdate(dse, mle))
{
//Clear(PanelHeader);
////Clear(panelDetail);
//BindCombo();
//chkNotRegister.Checked = true;
//ScStorage.Value1 = cboWarehouse.SelectedValue.ToString();
//dgvTanaban.ClearSelection();
//txtArrivalDateFrom.Focus();
Clear();
tnbnBL.ShowMessage("I101");
}
else
{
tnbnBL.ShowMessage("S001");
}
}
private void F12()
{
if (ErrorCheck(12))
{
if (tnbnBL.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
mle = new M_Location_Entity();
dse = new D_Stock_Entity();
DataTable dtUpdate = new DataTable();
dtUpdate.Columns.Add("RackNo");
dtUpdate.Columns.Add("StockNo");
foreach (DataGridViewRow row in dgvTanaban.Rows)
{
//bool chk =(bool)row.Cells["colChk"].Value;
//if(chk)
//{
DataRow dtrow = dtUpdate.NewRow();
dtrow["RackNo"] = row.Cells["colRackNo1"].Value.ToString();
dtrow["StockNo"] = row.Cells["colStockNo"].Value.ToString();
dtUpdate.Rows.Add(dtrow);
//}
}
dse = new D_Stock_Entity
{
dt1 = dtUpdate,
};
mle = GetEntity();
InsertUpdate(dse, mle);
}
else
{
PreviousCtrl.Focus();
}
}
}
public bool M_Location_InsertUpdate(D_Stock_Entity dse, M_Location_Entity mle)
{
dse.xml1 = DataTableToXml(dse.dt1);
return(mldl.M_Location_InsertUpdate(dse, mle));
}
public DataTable M_LocationTana_Select(M_Location_Entity mle)
{
return(mldl.M_LocationTana_Select(mle));
}
public DataTable M_Location_Search(M_Location_Entity mle)
{
return(mldl.M_Location_Search(mle));
}
/// <summary>
/// 棚検索にて使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public DataTable M_Location_SelectAll(M_Location_Entity de)
{
M_Location_DL mdl = new M_Location_DL();
return(mdl.M_Location_SelectAll(de));
}