private void Edit_Click(object sender, EventArgs e)
{
if (this.bInitialized == false || this.bOpened == false)
{
MessageBox.Show("データベースをオープンしてから実行してください");
}
else
{
this.ResultLog.Items.Clear();
// インポートに使用するテキストファイル
YayoiHanbaiSdk.SetTextFileName(this.EditTextFileName.Text);
// テキストファイルの形式
switch (this.EditTextType.SelectedIndex)
{
case 0:
YayoiHanbaiSdk.SetTextType(Convert.ToInt32(enumTexType.CVS));
break;
case 1:
YayoiHanbaiSdk.SetTextType(Convert.ToInt32(enumTexType.SPACE));
break;
case 2:
YayoiHanbaiSdk.SetTextType(Convert.ToInt32(enumTexType.TAB));
break;
}
// テキストファイルの読み込み開始行
YayoiHanbaiSdk.SetStartLine(Convert.ToInt32(this.EditStartLine.Text));
// 伝票修正対象データ
enumImportObject ImportSelectObject = default(enumImportObject);
switch (this.EditObejct.SelectedIndex)
{
case 0:
ImportSelectObject = enumImportObject.JuchuDempyo;
break;
case 1:
ImportSelectObject = enumImportObject.HattchuDempyo;
break;
case 2:
ImportSelectObject = enumImportObject.UriageDempyo;
break;
case 3:
ImportSelectObject = enumImportObject.ShiireDempyo;
break;
case 4:
ImportSelectObject = enumImportObject.NyukinDempyo;
break;
case 5:
ImportSelectObject = enumImportObject.ShukkoDempyo;
break;
case 6:
ImportSelectObject = enumImportObject.Mitsumorisho;
break;
case 7:
ImportSelectObject = enumImportObject.SokoDempyo;
break;
case 8:
ImportSelectObject = enumImportObject.SeisanDempyo;
break;
}
YayoiHanbaiSdk.SetObjectType(Convert.ToInt32(ImportSelectObject));
// シリアルID
int lSerialID = 0;
if (!string.IsNullOrEmpty(this.EditSerialID.Text))
{
lSerialID = Convert.ToInt32(this.EditSerialID.Text);
}
// 伝票編集可能かどうかの確認
if (YayoiHanbaiSdk.CanEditDempyo(Convert.ToInt32(ImportSelectObject), lSerialID))
{
// 実行権限の確認
if (YayoiHanbaiSdk.IsExecute(Convert.ToInt32(ImportSelectObject)))
{
// 伝票編集実行
if (YayoiHanbaiSdk.EditDempyo(lSerialID))
{
MessageBox.Show("伝票編集成功");
}
else
{
MessageBox.Show("伝票編集失敗");
}
}
else
{
MessageBox.Show("実行権限が無い");
}
}
else
{
MessageBox.Show("伝票編集不可");
}
}
}
private void Delete_Click(object sender, EventArgs e)
{
if (this.bInitialized == false | this.bOpened == false)
{
MessageBox.Show("データベースをオープンしてから実行してください");
}
else
{
this.ResultLog.Items.Clear();
// 伝票削除対象データ
enumImportObject ImportSelectObject = default(enumImportObject);
switch (this.DeleteObejct.SelectedIndex)
{
case 0:
ImportSelectObject = enumImportObject.JuchuDempyo;
break;
case 1:
ImportSelectObject = enumImportObject.HattchuDempyo;
break;
case 2:
ImportSelectObject = enumImportObject.UriageDempyo;
break;
case 3:
ImportSelectObject = enumImportObject.ShiireDempyo;
break;
case 4:
ImportSelectObject = enumImportObject.NyukinDempyo;
break;
case 5:
ImportSelectObject = enumImportObject.ShukkoDempyo;
break;
case 6:
ImportSelectObject = enumImportObject.Mitsumorisho;
break;
case 7:
ImportSelectObject = enumImportObject.SokoDempyo;
break;
case 8:
ImportSelectObject = enumImportObject.SeisanDempyo;
break;
}
YayoiHanbaiSdk.SetObjectType(Convert.ToInt32(ImportSelectObject));
// シリアルID
//long lSerialID = 0;
//if (!string.IsNullOrEmpty(this.DeleteSerialID1.Text))
//{
// lSerialID = Convert.ToInt64(this.DeleteSerialID1.Text);
//}
DataTable dt;
if (!checkBox1.Checked)
{
if (DeleteSerialID1.Text.Equals(""))
{
DeleteSerialID1.Focus();
return;
}
else
{
try
{
Convert.ToInt64(DeleteSerialID1.Text);
}
catch (Exception)
{
DeleteSerialID1.Clear();
DeleteSerialID1.Focus();
return;
}
}
if (DeleteSerialID2.Text.Equals(""))
{
DeleteSerialID2.Focus();
return;
}
else
{
try
{
Convert.ToInt64(DeleteSerialID2.Text);
}
catch (Exception)
{
DeleteSerialID2.Clear();
DeleteSerialID2.Focus();
return;
}
}
if (ImportSelectObject.ToString() == "ShukkoDempyo" || ImportSelectObject.ToString() == "SeisanDempyo")
{
int type = ImportSelectObject.ToString() == "ShukkoDempyo" ? 5 : 6;
dt = getDempyo("ZAIKODEMPYO", Convert.ToInt32(DeleteSerialID1.Text), Convert.ToInt32(DeleteSerialID2.Text), "", "", type);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
deleteDempyo(Convert.ToInt32(ImportSelectObject), Convert.ToInt32(dt.Rows[i]["A"]), Convert.ToInt32(dt.Rows[i]["E"]), Convert.ToDateTime(dt.Rows[i]["D"]));
}
// MessageBox.Show("伝票削除成功");
}
else
{
MessageBox.Show("伝票がありません");
}
}
}
else
{
dt = getDempyo(ImportSelectObject.ToString(), Convert.ToInt32(DeleteSerialID1.Text), Convert.ToInt32(DeleteSerialID2.Text), "", "");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
deleteDempyo(Convert.ToInt32(ImportSelectObject), Convert.ToInt32(dt.Rows[i]["A"]), Convert.ToInt32(dt.Rows[i]["D"]), Convert.ToDateTime(dt.Rows[i]["C"]));
}
// MessageBox.Show("伝票削除成功");
}
else
{
MessageBox.Show("伝票がありません");
}
}
}
}
else
{
int id1 = 0;
int id2 = 0;
if (DeleteSerialID1.Text.Equals("") && !DeleteSerialID2.Text.Equals(""))
{
DeleteSerialID1.Focus();
return;
}
if (!DeleteSerialID1.Text.Equals("") && DeleteSerialID2.Text.Equals(""))
{
DeleteSerialID2.Focus();
return;
}
if (!DeleteSerialID1.Text.Equals("") && !DeleteSerialID2.Text.Equals(""))
{
id1 = Convert.ToInt32(DeleteSerialID1.Text);
id2 = Convert.ToInt32(DeleteSerialID2.Text);
}
if (ImportSelectObject.ToString() == "ShukkoDempyo" || ImportSelectObject.ToString() == "SeisanDempyo")
{
int type = ImportSelectObject.ToString() == "ShukkoDempyo" ? 5 : 6;
dt = getDempyo("ZAIKODEMPYO", id1, id2, dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString(), type);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
deleteDempyo(Convert.ToInt32(ImportSelectObject), Convert.ToInt32(dt.Rows[i]["A"]), Convert.ToInt32(dt.Rows[i]["E"]), Convert.ToDateTime(dt.Rows[i]["D"]));
}
// MessageBox.Show("伝票削除成功");
}
else
{
MessageBox.Show("伝票がありません");
}
}
}
else
{
dt = getDempyo(ImportSelectObject.ToString(), id1, id2, dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
deleteDempyo(Convert.ToInt32(ImportSelectObject), Convert.ToInt32(dt.Rows[i]["A"]), Convert.ToInt32(dt.Rows[i]["D"]), Convert.ToDateTime(dt.Rows[i]["C"]));
}
// MessageBox.Show("伝票削除成功");
}
else
{
MessageBox.Show("伝票がありません");
}
}
}
}
}
}
private void Import_Click(object sender, EventArgs e)
{
if (this.bInitialized == false | this.bOpened == false)
{
MessageBox.Show("データベースをオープンしてから実行してください");
}
else
{
this.ResultLog.Items.Clear();
// インポートに使用するテキストファイル
YayoiHanbaiSdk.SetTextFileName(this.ImportTextFileName.Text);
// テキストファイルの形式
switch (this.TextType.SelectedIndex)
{
case 0:
YayoiHanbaiSdk.SetTextType(Convert.ToInt32(enumTexType.CVS));
break;
case 1:
YayoiHanbaiSdk.SetTextType(Convert.ToInt32(enumTexType.SPACE));
break;
case 2:
YayoiHanbaiSdk.SetTextType(Convert.ToInt32(enumTexType.TAB));
break;
}
// テキストファイルの読み込み開始行
YayoiHanbaiSdk.SetStartLine(Convert.ToInt32(this.StartLine.Text));
// インポート対象データ
enumImportObject ImportSelectObject = default(enumImportObject);
switch (this.ImportObejct.SelectedIndex)
{
case 0:
ImportSelectObject = enumImportObject.Tokuisaki;
break;
case 1:
ImportSelectObject = enumImportObject.Shiiresaki;
break;
case 2:
ImportSelectObject = enumImportObject.Shohin;
break;
case 3:
ImportSelectObject = enumImportObject.Tantosha;
break;
case 4:
ImportSelectObject = enumImportObject.Nonyusaki;
break;
case 5:
ImportSelectObject = enumImportObject.TokuisakiKakakuhyo;
break;
case 6:
ImportSelectObject = enumImportObject.ShiiresakiKakakuhyo;
break;
case 7:
ImportSelectObject = enumImportObject.KoseiBuhinDaicho;
break;
case 8:
ImportSelectObject = enumImportObject.SokoDaicho;
break;
case 9:
ImportSelectObject = enumImportObject.JuchuDempyo;
break;
case 10:
ImportSelectObject = enumImportObject.HattchuDempyo;
break;
case 11:
ImportSelectObject = enumImportObject.UriageDempyo;
break;
case 12:
ImportSelectObject = enumImportObject.ShiireDempyo;
break;
case 13:
ImportSelectObject = enumImportObject.NyukinDempyo;
break;
case 14:
ImportSelectObject = enumImportObject.ShukkoDempyo;
break;
case 15:
ImportSelectObject = enumImportObject.Mitsumorisho;
break;
case 16:
ImportSelectObject = enumImportObject.SokoDempyo;
break;
case 17:
ImportSelectObject = enumImportObject.SeisanDempyo;
break;
}
YayoiHanbaiSdk.SetObjectType(Convert.ToInt32(ImportSelectObject));
// 伝票番号自動付番の設定
if (this.AutoDemban.Checked)
{
YayoiHanbaiSdk.SetAutoDemban(Convert.ToInt32(enumAutoDemban.Yes));
}
else
{
YayoiHanbaiSdk.SetAutoDemban(Convert.ToInt32(enumAutoDemban.No));
}
// 大量書き込みモードの設定
if (this.ManyWrite.Checked)
{
YayoiHanbaiSdk.SetWritingMode(Convert.ToInt32(enumManyWrite.Yes));
}
else
{
YayoiHanbaiSdk.SetWritingMode(Convert.ToInt32(enumManyWrite.No));
}
// 実行権限の確認
if (YayoiHanbaiSdk.IsExecute(Convert.ToInt32(ImportSelectObject)))
{
// インポート実行
if (YayoiHanbaiSdk.Import())
{
MessageBox.Show("インポート成功");
}
else
{
MessageBox.Show("インポート失敗");
}
}
else
{
MessageBox.Show("実行権限が無い");
}
}
}
