public bool M_Gaisya_Delete(M_Shipping_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ShippingCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ChangeDate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingCD + "" + mse.ChangeDate
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Carrier_Delete"));
}
public DataTable M_Carrier_Search(M_Shipping_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@DisplayKBN", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.DisplayKBN
} },
{ "@ShippingCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingCDFrom
} },
{ "@ShippingCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingCDTo
} },
{ "@ShippingName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingName
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.DeleteFlg
} },
};
UseTransaction = true;
return(SelectData(dic, "M_Carrier_Search"));
}
private void F11()
{
if (ErrorCheck())
{
mse = GetData();
DataTable dt = new DataTable();
dt = scbl.M_Carrier_Search(mse);
gvShipping.DataSource = dt;
}
}
private M_Shipping_Entity GetData()
{
mse = new M_Shipping_Entity
{
ChangeDate = lblChangeDate.Text,
DisplayKBN = radioButton1.Checked ? "0" : "1",
ShippingCDFrom = txtShippingFrom.Text,
ShippingCDTo = txtShippingTo.Text,
ShippingName = txtShippingName.Text,
DeleteFlg = "0",
};
return(mse);
}
private bool DisplayData(CKM_SearchControl sc)
{
mtugsbl = new MasterTouroku_UnsouGaisya_BL();
mse = new M_Shipping_Entity
{
ShippingCD = sc.Code,
ChangeDate = sc.ChangeDate
};
mse = mtugsbl.M_Carrier_Select(mse);
if (mse != null)
{
txtShippingName.Text = mse.ShippingName;
cboIdentity.SelectedValue = mse.CarrierFlg;
cboNormalType.SelectedValue = mse.NormalFlg;
txtYahooCD.Text = mse.YahooCD;
txtRakutenCD.Text = mse.RakutenCD;
txtAmazonCD.Text = mse.AmazonCD;
txtWowmaCD.Text = mse.WowmaCD;
txtPonpareCD.Text = mse.PonpareCD;
txtOtherCD.Text = mse.OtherCD;
txtremark.Text = mse.Remarks;
chkDeleteFlg.Checked = mse.DeleteFlg.Equals("1") ? true : false;
txtShippingName.Focus();
return(true);
}
else
{
mtugsbl.ShowMessage("E133");
return(false);
}
//DataTable dtCarrier = mtugsbl.M_Carrier_Select(mse);
//if (dtCarrier.Rows.Count > 0)
//{
// txtShippingName.Text = dtCarrier.Rows[0]["CarrierName"].ToString();
// cboIdentity.SelectedValue = dtCarrier.Rows[0]["CarrierFlg"].ToString();
// txtYahooCD.Text = dtCarrier.Rows[0]["YahooCarrierCD"].ToString();
// txtRakutenCD.Text = dtCarrier.Rows[0]["RakutenCarrierCD"].ToString();
// txtAmazonCD.Text = dtCarrier.Rows[0]["AmazonCarrierCD"].ToString();
// txtWowmaCD.Text = dtCarrier.Rows[0]["WowmaCarrierCD"].ToString();
// txtPonpareCD.Text = dtCarrier.Rows[0]["PonpareCarrierCD"].ToString();
// txtOtherCD.Text = dtCarrier.Rows[0]["OtherCD"].ToString();
// txtremark.Text = dtCarrier.Rows[0]["Remarks"].ToString();
// if (dtCarrier.Rows[0]["DeleteFlg"].ToString() == "1")
// chkDeleteFlg.Checked = true;
// else chkDeleteFlg.Checked = false;
//}
}
public DataTable M_CarrierSelect(M_Shipping_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ShippingCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
};
UseTransaction = true;
return(SelectData(dic, "M_Carrier_Select"));
}
//public DataTable CarrierSelect(M_Shipping_Entity mse)
//{
// return mudl.M_CarrierSelect(mse);
//}
public M_Shipping_Entity M_Carrier_Select(M_Shipping_Entity mse)
{
DataTable dtCarrier = mudl.M_CarrierSelect(mse);
if (dtCarrier.Rows.Count > 0)
{
mse.ShippingName = dtCarrier.Rows[0]["CarrierName"].ToString();
mse.CarrierFlg = dtCarrier.Rows[0]["CarrierFlg"].ToString();
mse.NormalFlg = dtCarrier.Rows[0]["NormalFLG"].ToString();
mse.YahooCD = dtCarrier.Rows[0]["YahooCarrierCD"].ToString();
mse.RakutenCD = dtCarrier.Rows[0]["RakutenCarrierCD"].ToString();
mse.AmazonCD = dtCarrier.Rows[0]["AmazonCarrierCD"].ToString();
mse.WowmaCD = dtCarrier.Rows[0]["WowmaCarrierCD"].ToString();
mse.PonpareCD = dtCarrier.Rows[0]["PonpareCarrierCD"].ToString();
mse.OtherCD = dtCarrier.Rows[0]["OtherCD"].ToString();
mse.Remarks = dtCarrier.Rows[0]["Remarks"].ToString();
mse.DeleteFlg = dtCarrier.Rows[0]["DeleteFlg"].ToString();
return(mse);
}
return(null);
}
/// <summary>
/// To Get Data from Form Entity
/// </summary>
/// <returns></returns>
private M_Shipping_Entity GetShippingEntity()
{
mse = new M_Shipping_Entity
{
ShippingCD = ScShippingCD.Code,
ChangeDate = ScShippingCD.ChangeDate,
ShippingName = txtShippingName.Text,
CarrierFlg = cboIdentity.SelectedValue.ToString(),
NormalFlg = cboNormalType.SelectedValue.ToString(),
YahooCD = txtYahooCD.Text,
RakutenCD = txtRakutenCD.Text,
AmazonCD = txtAmazonCD.Text,
WowmaCD = txtWowmaCD.Text,
PonpareCD = txtPonpareCD.Text,
OtherCD = txtOtherCD.Text,
Remarks = txtremark.Text,
DeleteFlg = chkDeleteFlg.Checked ? "1" : "0",
ProcessMode = ModeText,
InsertOperator = InOperatorCD,
ProgramID = InProgramID,
PC = InPcID
};
return(mse);
}
private void F12()
{
if (ErrorCheck(12))
{
if (mtugsbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
mse = GetShippingEntity();
switch (OperationMode)
{
case EOperationMode.INSERT:
InsertUpdate(1);
break;
case EOperationMode.UPDATE:
InsertUpdate(2);
break;
case EOperationMode.DELETE:
if (mse.UsedFlg == "1")
{
mtugsbl.ShowMessage("E154");
}
else
{
Delete();
}
break;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
public bool M_Gaisya_InsertUpdate(M_Shipping_Entity mse, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ShippingCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingCD
} },
{ "@ChangeDate", new ValuePair {
value1 = System.Data.SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@ShippingName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingName
} },
{ "@Identify", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.CarrierFlg
} },
{ "@Normal", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.NormalFlg
} },
{ "@YahooCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.YahooCD
} },
{ "@RakutenCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.RakutenCD
} },
{ "@AmazonCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.AmazonCD
} },
{ "@WowmaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.WowmaCD
} },
{ "@PonpareCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.PonpareCD
} },
{ "@OtherCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.OtherCD
} },
{ "@Remarks", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.Remarks
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ShippingCD + " " + mse.ChangeDate
} },
{ "@Mode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mode.ToString()
} }
};
return(InsertUpdateDeleteData(dic, "M_Carrier_Insert_Update"));
}
public bool M_Gaisya_Delect(M_Shipping_Entity mse)
{
return(mudl.M_Gaisya_Delete(mse));
}
//public DataTable M_Carrier_Select(M_Shipping_Entity mse)
//{
// return mudl.M_CarrierSelect(mse);
//}
public bool M_Gaisya_InsertUpdate(M_Shipping_Entity mse, int mode)
{
return(mudl.M_Gaisya_InsertUpdate(mse, mode));
}
public DataTable M_Carrier_Search(M_Shipping_Entity mse)
{
return(mugdl.M_Carrier_Search(mse));
}
