private void ValidateKamokuCode(models.db.KaikeiDatabase db, models.db.Row row, models.constants.Taisyaku taisyaku)
{
if (models.Validator.IsHurikaeTaisyouKamokuCode(db, row, taisyaku))
{
gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgHurikaeTaisyouKamoku, "warn", null);
}
}
private void PrintYosanJissekiTaihi3Column(models.db.KaikeiDatabase db, int currentYear, int lastYear, int hoseiKaisuu, int kaikeiKubun, DateTime?printDate)
{
string houjinMei = "";
houjinMei = db.MTKaikeiKubun.GetRowFromCache(db.MTKaikeiKubun.RootNodeId).GetStr("name") as string;
var yosanUchiwake = new models.query.YosanUchiwake();
yosanUchiwake.Calc(db, currentYear, lastYear, hoseiKaisuu, kaikeiKubun, withJisseki: true, withSyoukubun: false, withHojoKamoku: false);
var report = new views.reports.SyuushiYosanJissekiReport();
report.OmitZeroRow = form.OmitZeroRow;
report.SetDB(db);
report.SetHeader(houjinMei, new DateTime(currentYear, 4, 1), new DateTime(currentYear + 1, 3, 31));
for (int i = 0; i < yosanUchiwake.ChildKaikeiKubunNameList.Count; i++)
{
report.SetKaikeiKubunCaption(i, yosanUchiwake.ChildKaikeiKubunNameList[i]);
}
var popup = new views.popup.ReportPreviewPopup();
report.DataSource = yosanUchiwake.YosanUchiwakeRowList;
report.Run();
popup.Document = report.Document;
popup.ShowDialog();
}
public GoukeiZandakaShisanhyou(models.db.KaikeiDatabase aDB)
{
RowList = new List <ShisanRow>();
kanjouKamokuHash = new Dictionary <int, bool>();
db = aDB;
}
/// <summary>
/// 経理区分に対応した補助整理かどうか
/// 補助整理がNullなら0を設定
/// 経理区分に対応した補助整理でなければ補助IDをnullに設定
/// </summary>
public static bool CheckHojoSeiriIsFitInKaikeiKubun(models.db.KaikeiDatabase db, models.db.Row row, constants.Taisyaku taisyaku)
{
int kamokuId = (int)row.GetLong(GetTaisyakuStr(taisyaku, "_kamoku_id"), -1);
int hojoSeiri = (int)row.GetLong(GetTaisyakuStr(taisyaku, "_hojo_seiri"), 0);
if (hojoSeiri == 0)
{
row.Table.SetColumnValue(row, GetTaisyakuStr(taisyaku, "_hojo_seiri"), 0);
return(true);
}
var seiriRow = db.MTKanjouKamoku.GetRowFromCodeCacheByTopParent(kamokuId, hojoSeiri.ToString());
if (seiriRow == null)
{
row.Table.SetColumnValue(row, GetTaisyakuStr(taisyaku, "_hojo_id"), null);
return(false);
}
int kamokuKaikeiKubunId = (int)seiriRow.GetLong("kaikei_kubun_id", -1);
int denpyouKaikeiKubunId = (int)row.GetLong("kaikei_kubun", -1);
if (kamokuKaikeiKubunId == -1 || denpyouKaikeiKubunId == -1)
{
return(true);
}
if (!db.MTKaikeiKubun.IsChildOf(childId: denpyouKaikeiKubunId, parentId: kamokuKaikeiKubunId))
{
return(false);
}
return(true);
}
public void SetDatabase(KaikeiSystemBody.models.db.KaikeiDatabase aDB) {
if (db != aDB) {
db = aDB;
cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, false);
cmbKaikeiKubun.SelectedIndex = -1;
}
}
// マスタ情報の設定
override public void SetMasterTables(models.db.AbstractDatabase aDB)
{
db = aDB as models.db.KaikeiDatabase;
cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true);
cmbTorihikiKubun.InitRowsWithMTTorihikiKubun(db.MTTorihikiKubun);
}
private void ValidateKamokuCode(models.db.KaikeiDatabase db, models.db.Row row, models.constants.Taisyaku taisyaku)
{
if (models.Validator.IsHurikaeTaisyouKamokuCode(db, row, taisyaku))
{
ShowMsgDelay(KaikeiSystemBody.Properties.Resources.MsgHurikaeTaisyouKamoku, "warn");
}
}
override public void CopyMasterTableContoller(AbstractDBGridRow originalRow)
{
db = (originalRow as IkkatsuSyoriMasterRow).db;
cmbKaikeiKubun.CopyRows((originalRow as IkkatsuSyoriMasterRow).cmbKaikeiKubun);
cmbTorihikiKubun.CopyRows((originalRow as IkkatsuSyoriMasterRow).cmbTorihikiKubun);
}
public ShiwakeDenpyou(models.db.KaikeiDatabase aDB)
{
db = aDB;
RowList = new List <ShiwakeDenpyouRow>();
denpyouIdHash = new Dictionary <int, bool>();
}
public void SetDB(models.db.KaikeiDatabase db_)
{
db = db_;
cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, false);
cmbKaikeiKubun.SelectedIndex = 0;
}
public void SetDatabase(models.db.KaikeiDatabase aDB)
{
db = aDB;
rowDetailMain.SetMasterTables(db);
rowDetailSub.SetMasterTables(db);
}
// マスタ情報の設定
override public void SetMasterTables(models.db.AbstractDatabase aDB)
{
db = aDB as models.db.KaikeiDatabase;
cmbKeiriKubun.InitRowsWithMTHoujinShisetsu(db.MTHoujinShisetsu, false);
cmbHojoKamoku.InitRowsWithMTHojoKamokuWhereKeyIsId(db.MTHojoKamoku, ParentKamokuId);
}
public long GetTaisyaku(models.db.KaikeiDatabase db)
{
models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetFirstRow("where id=" + KamokuKubunId);
if (kamokuKubunRow == null)
{
return(0);
}
int kanjouKamokuId = (int)kamokuKubunRow.GetLong("kanjou_kamoku_id", -1);
models.db.Row kanjouKamokuRow = db.MTKanjouKamoku.GetFirstRow("where id=" + kanjouKamokuId);
if (kanjouKamokuRow == null)
{
return(0);
}
int taisyakuKubunId = (int)kanjouKamokuRow.GetLong("taisyaku_kubun_id", -1);
if (taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KariPlus || taisyakuKubunId == (int)models.constants.MTTaisyakuKubun.KariMinus)
{
return(KarikataAmount - KashikataAmount);
}
else
{
return(KashikataAmount - KarikataAmount);
}
}
public void SetDatabase(models.db.KaikeiDatabase aDB)
{
db = aDB;
cmbKaikeiKubunForKamoku.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true);
cmbYosanKubunForKamoku.InitRowsWithMTYosanKubun(db.MTYosanKubun);
cmbKaikeiKubunForHojo.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true);
cmbYosanKubunForHojo.InitRowsWithMTYosanKubun(db.MTYosanKubun);
}
public void SetAddedShiwake(models.db.KaikeiDatabase db, models.db.Row row)
{
int torihikiKubunId = (int)row.GetLong("torihiki_kubun", -1);
KarikataKamoku2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_kamoku_id", -1), torihikiKubunId);
KashikataKamoku2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_kamoku_id", -1), torihikiKubunId);
KarikataHojo2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("karikata_hojo_id", -1), torihikiKubunId);
KashikataHojo2 = db.MTKanjouKamoku.GetKamokuStr((int)row.GetLong("kashikata_hojo_id", -1), torihikiKubunId);
}
public YosanListRow()
{
InitializeComponent();
btnShow.Click += (s, e) => ShowButtonClicked(this);
SetDefaultIndicator();
db = null;
}
public YosanDaikubunRow()
{
InitializeComponent();
SetDefaultHandlersToControls();
SetDefaultIndicator();
db = null;
}
public void SetDatabase(models.db.KaikeiDatabase aDB)
{
if (db != aDB)
{
db = aDB;
cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true);
cmbKaikeiKubun.SelectedIndex = 0;
}
}
public static bool IsKoteiShisanKanjouKamoku(models.db.KaikeiDatabase db, int kanjouKamokuId)
{
models.db.Row kamokuKubunRow = db.MTKanjouKamoku.GetKamokuKubunRow(kanjouKamokuId, models.constants.MTTorihikiKubun.Shikin);
if (kamokuKubunRow == null)
{
return(false);
}
return(IsKoteiShisanKamokuKubun(db, kamokuKubunRow.GetId()));
}
public ZenkiKurikoshiKamokuKubunRow()
{
InitializeComponent();
SetDefaultHandlersToControls();
SetDefaultIndicator();
db = null;
}
public SyuushiKakuninRow()
{
InitializeComponent();
db = null;
SetDefaultHandlersToControls();
SetDefaultIndicator();
}
public KaikeiDenpyouRow()
{
InitializeComponent();
db = null;
btnRemoveRow.Click += base.DefaultHandlerRemoveRowButtonClicked;
SetDefaultHandlersToControls();
SetDefaultIndicator();
}
public KanjouMototyou(models.db.KaikeiDatabase aDB)
{
db = aDB;
calced = false;
rowList = new List <MototyouRow>();
MeisaiTable = db.KaikeiDenpyouMeisai;
KurikoshiKamokuTable = db.ZenkiKurikoshiKamokuKubun;
}
public IkkatsuSyoriMasterRow()
{
InitializeComponent();
db = null;
btnDelete.Click += base.DefaultHandlerRemoveRowButtonClicked;
SetDefaultHandlersToControls();
SetDefaultIndicator();
}
private void ValidateKashikataHojoSeiri(models.db.KaikeiDatabase db, models.db.Row row)
{
if (!models.Validator.CheckHojoSeiriIsFitInKaikeiKubun(db, row, models.constants.Taisyaku.Kashikata))
{
delayTimerController.SetDelayedProc(delegate() {
helper.MsgBox.ShowMsg(KaikeiSystemBody.Properties.Resources.MsgInvaidHojoSeiri, "warn");
popup.FocusKashikataHojoCmbBox();
});
}
}
// マスタ情報の設定
public void SetMasterTables(models.db.KaikeiDatabase db)
{
cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, true);
if (cmbKaikeiKubun.Items.Count > 0)
{
cmbKaikeiKubun.SelectedIndex = 0;
}
cmbTorihikiKubun.InitRowsWithMTTorihikiKubun(db.MTTorihikiKubun);
cmbKamoku.InitRowsWithMTKanjouKamoku(db.MTKanjouKamoku, -1);
}
public KoteiShisanRow()
{
InitializeComponent();
SetDefaultHandlersToControls();
SetDefaultIndicator();
btnDetail.Click += DetailButtonClickedHandler;
db = null;
}
public YosanYobihiKakuninRow()
{
InitializeComponent();
btnDelete.Click += base.DefaultHandlerRemoveRowButtonClicked;
SetDefaultHandlersToControls();
SetDefaultIndicator();
db = null;
}
private void ValidateKashikataHojoSeiri(models.db.KaikeiDatabase db, models.db.Row row, bool kamokuCheck = true)
{
if (kamokuCheck && !models.Validator.CheckHojoSeiriIsFitInKamokuCode(db, row, models.constants.Taisyaku.Kashikata))
{
gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgHojoSeiriNotFound, "warn", "kashikata_hojo_seiri");
}
else if (!models.Validator.CheckHojoSeiriIsFitInKaikeiKubun(db, row, models.constants.Taisyaku.Kashikata))
{
gridController.ShowMsgAndChangeFocus(KaikeiSystemBody.Properties.Resources.MsgInvaidHojoSeiri, "warn", "kashikata_hojo_seiri");
}
}
public void SetDatabase(models.db.KaikeiDatabase aDB)
{
db = aDB;
cmbKaikeiKubun.InitRowsWithMTKaikeiKubun(db.MTKaikeiKubun, onlyLeafNode: true);
cmbTorihikiKubun.InitRowsWithMTTorihikiKubun(db.MTTorihikiKubun);
cmbKarikataKamoku.InitRowsWithMTKanjouKamokuWithKamokuCodeCaption(db.MTKanjouKamoku, -1);
cmbKarikataHojo.BindToMTKanjouKamkouComboBoxWithKamokuCodeCaption(cmbKarikataKamoku, -1);
cmbKashikataKamoku.InitRowsWithMTKanjouKamokuWithKamokuCodeCaption(db.MTKanjouKamoku, -1);
cmbKashikataHojo.BindToMTKanjouKamkouComboBoxWithKamokuCodeCaption(cmbKashikataKamoku, -1);
}
