public M_Souko_Entity M_Souko_Select(M_Souko_Entity mse)
{
DataTable dtSouko = msdl.M_Souko_Select(mse);
if (dtSouko.Rows.Count > 0)
{
mse.SoukoName = dtSouko.Rows[0]["SoukoName"].ToString();
mse.StoreCD = dtSouko.Rows[0]["StoreCD"].ToString();
mse.ZipCD1 = dtSouko.Rows[0]["ZipCD1"].ToString();
mse.ZipCD2 = dtSouko.Rows[0]["ZipCD2"].ToString();
mse.Address1 = dtSouko.Rows[0]["Address1"].ToString();
mse.Address2 = dtSouko.Rows[0]["Address2"].ToString();
mse.TelephoneNO = dtSouko.Rows[0]["TelephoneNo"].ToString();
mse.FaxNO = dtSouko.Rows[0]["FaxNO"].ToString();
mse.SoukoType = dtSouko.Rows[0]["SoukoType"].ToString();
mse.MakerCD = dtSouko.Rows[0]["MakerCD"].ToString();
mse.MakerName = dtSouko.Rows[0]["MakerName"].ToString();
mse.HikiateOrder = dtSouko.Rows[0]["HikiateOrder"].ToString();
mse.UnitPriceCalcKBN = dtSouko.Rows[0]["UnitPriceCalcKBN"].ToString();
mse.IdouCount = dtSouko.Rows[0]["IdouCount"].ToString();
mse.Remarks = dtSouko.Rows[0]["Remarks"].ToString();
mse.DeleteFlg = dtSouko.Rows[0]["DeleteFlg"].ToString();
return(mse);
}
return(null);
}
public bool M_Souko_Delete(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.Operator
} },
{ "@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.Key
} }
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Souko_Delete"));
}
private void F12()
{
if (ErrorCheck(12))
{
//*** Create Entity Object
mse = GetSoukoEntity();
if (bbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
switch (OperationMode)
{
case EOperationMode.INSERT:
InsertUpdate(1);
break;
case EOperationMode.UPDATE:
InsertUpdate(2);
break;
case EOperationMode.DELETE:
Delete();
break;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
private M_Souko_Entity GetSoukoEntity()
{
mse = new M_Souko_Entity()
{
SoukoCD = ScSoukoCD.Code,
ChangeDate = ScSoukoCD.ChangeDate,
SoukoName = TxtSoukoName.Text,
StoreCD = CboStoreCD.SelectedValue.ToString(),
HikiateOrder = TxtHikiateOrder.Text,
ZipCD1 = txtZipCD1.Text,
ZipCD2 = txtZipCD2.Text,
Address1 = TxtAddress1.Text,
Address2 = TxtAddress2.Text,
TelephoneNO = TxtTelePhoneNo.Text,
FaxNO = TxtFaxNo.Text,
SoukoType = CboSoukoType.SelectedValue.ToString(),
MakerCD = ScSoukoMakerCD.Code,
UnitPriceCalcKBN = ChkUnitPriceCalcKBN.Checked ? "1" : "0",
IdouCount = TxtIdouCount.Text,
Remarks = TxtRemark.Text,
DeleteFlg = ChkDeleteFlg.Checked ? "1" : "0",
ProcessMode = ModeText,
Operator = InOperatorCD,
ProgramID = InProgramID,
Key = ScSoukoCD.Code + " " + ScSoukoCD.ChangeDate,
PC = InPcID,
dtTemp1 = dtLocation
};
return(mse);
}
private void F11()
{
if (ErrorCheck())
{
mse = GetSearchInfo();
DataTable dtSouko = ssbl.M_Souko_Search(mse);
GvSouko.DataSource = dtSouko;
}
}
private void Form_Load(object sender, EventArgs e)
{
try
{
Scr_Clr();
string ymd = snbl.GetDate();
snbl = new ShukkaShijiTouroku_BL();
CboSouko.Bind(ymd);
CboCarrier.Bind(ymd);
ScJuchuuNO.Value1 = OperatorCD;
ScJuchuuNO.Value2 = AllAvailableStores;
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = OperatorCD,
ChangeDate = snbl.GetDate()
};
Staff_BL bl = new Staff_BL();
bool ret = bl.M_Staff_Select(mse);
if (ret)
{
//[M_Souko_Search]
M_Souko_Entity me = new M_Souko_Entity
{
StoreCD = mse.StoreCD,
SoukoType = "3",
ChangeDate = ymd,
DeleteFlg = "0"
};
DataTable mdt = snbl.M_Souko_Search(me);
if (mdt.Rows.Count > 0)
{
CboSouko.SelectedValue = mdt.Rows[0]["SoukoCD"];
}
}
for (int i = (int)EIndex.DayStart; i <= (int)EIndex.PlanDateEnd; i++)
{
detailControls[i].Text = ymd;
}
detailControls[(int)EIndex.StaffCD].Text = OperatorCD;
ScStaff.LabelText = mse.StaffName;
detailControls[0].Focus();
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
public DataTable M_SoukoWarehouse_Select(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>();
dic.Add("@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
});
return(SelectData(dic, "M_SoukoWarehouse_Select"));
}
public DataTable M_Souko_BindForZaikoshoukai(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.StoreCD
} },
};
return(SelectData(dic, "M_Souko_BindForZaikoshoukai"));
}
public DataTable M_Souko_BindAll(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.StoreCD
} },
//{ "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } },
};
return(SelectData(dic, "M_Souko_BindAll"));
}
public DataTable M_SoukoName_Select(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>();
dic.Add("@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoCD
});
dic.Add("@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ChangeDate
});
return(SelectData(dic, "M_SoukoName_Select"));
}
public DataTable M_Location_Select(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} }
};
return(SelectData(dic, "M_Location_Select"));
}
public DataTable M_Souko_BindForShukka(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.DeleteFlg
} },
};
return(SelectData(dic, "M_Souko_BindForShukka"));
}
public bool M_Souko_Search(M_Souko_Entity mse)
{
M_Souko_DL msdl = new M_Souko_DL();
DataTable dt = msdl.M_Souko_Search(mse);
if (dt.Rows.Count > 0)
{
mse.SoukoCD = dt.Rows[0]["SoukoCD"].ToString();
return(true);
}
else
{
return(false);
}
}
private M_Souko_Entity GetSearchInfo()
{
mse = new M_Souko_Entity
{
SoukoCDFrom = TxtSoukoCDFrom.Text,
SoukoCDTo = TxtSoukoCDTo.Text,
ChangeDate = lblChangeDate.Text,
SoukoName = TxtSoukoName.Text,
StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
SoukoType = CboSoukoType.SelectedValue.Equals("-1") ? string.Empty : CboSoukoType.SelectedValue.ToString(),
DeleteFlg = "0",
searchType = RdoKijunBi.Checked ? "1" : "2",
};
return(mse);
}
public DataTable M_Souko_IsExists(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>();
dic.Add("@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoCD
});
dic.Add("@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
});
dic.Add("@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
});
return(SelectData(dic, "M_Souko_IsExists"));
}
private void Form_Load(object sender, EventArgs e)
{
try
{
Scr_Clr();
detailControls[(int)EIndex.DayStart].Text = snbl.GetDate();
detailControls[(int)EIndex.DayEnd].Text = snbl.GetDate();
string ymd = snbl.GetDate();
CboSoukoCD.Bind(ymd);
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = OperatorCD,
ChangeDate = snbl.GetDate()
};
Staff_BL bl = new Staff_BL();
bool ret = bl.M_Staff_Select(mse);
if (ret)
{
//[M_Souko_Select]
M_Souko_Entity me = new M_Souko_Entity
{
StoreCD = mse.StoreCD,
SoukoType = "3",
ChangeDate = ymd,
DeleteFlg = "0"
};
DataTable mdt = snbl.M_Souko_SelectForNyuuka(me);
if (mdt.Rows.Count > 0)
{
CboSoukoCD.SelectedValue = mdt.Rows[0]["SoukoCD"];
}
}
F9Visible = false;
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
/// <summary>
/// Select Souko's info
/// SoukoType 3,4のSouko情報をSelect
/// </summary>
/// <param name="mse">Souko info</param>
/// <returns></returns>
public DataTable M_Souko_SelectForMitsumori(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.StoreCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
} }
};
return(SelectData(dic, "M_Souko_SelectForMitsumori"));
}
private bool DisplayData(CKM_SearchControl sc)
{
mse = new M_Souko_Entity
{
SoukoCD = sc.Code,
ChangeDate = sc.ChangeDate
};
dtLocation = mtsbl.M_Location_Select(mse);
if (dtLocation != null)
{
GvTana.DataSource = dtLocation;
}
mse = mtsbl.M_Souko_Select(mse);
if (mse != null)
{
TxtSoukoName.Text = mse.SoukoName;
CboStoreCD.SelectedValue = mse.StoreCD;
txtZipCD1.Text = mse.ZipCD1;
txtZipCD2.Text = mse.ZipCD2;
TxtAddress1.Text = mse.Address1;
TxtAddress2.Text = mse.Address2;
TxtTelePhoneNo.Text = mse.TelephoneNO;
TxtFaxNo.Text = mse.FaxNO;
CboSoukoType.SelectedValue = mse.SoukoType;
ScSoukoMakerCD.Code = mse.MakerCD;
ScSoukoMakerCD.LabelText = mse.MakerName;
TxtHikiateOrder.Text = mse.HikiateOrder;
ChkUnitPriceCalcKBN.Checked = mse.UnitPriceCalcKBN.Equals("1") ? true : false;
TxtIdouCount.Text = mse.IdouCount;
TxtRemark.Text = mse.Remarks;
ChkDeleteFlg.Checked = mse.DeleteFlg.Equals("1") ? true : false;
TxtSoukoName.Focus();
return(true);
}
else
{
mtsbl.ShowMessage("E133");
return(false);
}
}
public DataTable M_Souko_ZipcodeAddressSelect(M_Souko_Entity mse)
{
string sp = "M_Souko_ZipcodeAddressSelect";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoCD
} },
{ "@ZipCD1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ZipCD1
} },
{ "@ZipCD2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ZipCD2
} }
};
return(SelectData(dic, sp));
}
public DataTable M_Souko_Search(M_Souko_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Fields", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.FieldsName
} },
{ "@SoukoCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoCDFrom
} },
{ "@SoukoCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoCDTo
} },
{ "@SoukoName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SoukoName
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.StoreCD
} },
{ "@SoukoType", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.SoukoType
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.DeleteFlg
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
// { "@OrderBy", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.OrderBy } },
{ "@SearchType", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.searchType
} },
};
return(SelectData(dic, "M_Souko_Search"));
}
public DataTable M_Location_Select(M_Souko_Entity mse)
{
return(mldl.M_Location_Select(mse));
}
public bool M_Souko_Delete(M_Souko_Entity mse)
{
return(msdl.M_Souko_Delete(mse));
}
public bool M_Souko_Insert_Update(M_Souko_Entity mse, int mode)
{
mse.LocationXml = DataTableToXml(mse.dtTemp1);
return(msdl.M_Souko_Insert_Update(mse, mode));
}
public DataTable M_Souko_ZipcodeAddressSelect(M_Souko_Entity mse)
{
return(msdl.M_Souko_ZipcodeAddressSelect(mse));
}
public DataTable M_Souko_SelectData(M_Souko_Entity mse)
{
M_Souko_DL sdl = new M_Souko_DL();
return(sdl.M_Souko_SelectData(mse));
}
public DataTable M_Souko_Search(M_Souko_Entity mse)
{
M_Souko_DL msdl = new M_Souko_DL();
return(msdl.M_Souko_Search(mse));
}
public DataTable M_Souko_BindForShukka(M_Souko_Entity mse)
{
M_Souko_DL msdl = new M_Souko_DL();
return(msdl.M_Souko_BindForShukka(mse));
}
public DataTable M_Souko_AllBind(M_Souko_Entity mse)
{
return(msoukodl.M_Souko_AllBind(mse));
}
public DataTable M_Souko_BindAll(M_Souko_Entity mse)
{
return(msoukodl.M_Souko_BindAll(mse));
}
public DataTable M_Souko_Search(M_Souko_Entity mse)
{
return(msoukodl.M_Souko_Search(mse));
}
