private bool UpdateMultiPurpose()
{
Thread.Sleep(5 * 1000);//to stop stage6 with yellow color for 5 sec
string dateTime = System.DateTime.Now.ToString();
mme = new M_MultiPorpose_Entity();
mme.Num1 = mme.Key = "1";
mme.InsertOperator = loginInfo.OperatorCode;
mme.InsertDateTime = dateTime;
mme.ID = "108";
if (psks0108ibl.M_MultiPorpose_Num1_Update(mme))
{
mme.ID = "109";
if (psks0108ibl.M_MultiPorpose_Num1_Update(mme))
{
lblStage6.BackColor = Color.FromArgb(255, 242, 204);
lblStage7.BackColor = Color.Yellow;
return(true);
}
return(false);
}
return(false);
}
public static void Main(string[] args)
{
Console.Title = "PSKS0107B_入出庫情報取得";
Base_Entity baseEntity = new Base_Entity();
PSKS0107B_BL psks0107b_bl = new PSKS0107B_BL();
M_MultiPorpose_Entity mmultiporpose_data = new M_MultiPorpose_Entity();
DataTable dt = new DataTable();
mmultiporpose_data.ID = "103";
mmultiporpose_data.Key = "1";
dt = psks0107b_bl.M_MultiPorpose_SelectID(mmultiporpose_data);
while (dt.Rows[0]["Num1"].ToString().Equals("0"))
{
Thread.Sleep(Convert.ToInt32(dt.Rows[0]["Num2"]) * 1000);
dt = psks0107b_bl.M_MultiPorpose_SelectID(mmultiporpose_data); // select columns from M_Multiporpose table
}
//DataTable dtpostgre = new DataTable();
//dtpostgre = psks0107b_bl.t_hanbai_shohin_Select();
//DataTable dtsukoraku = new DataTable();
//dtsukoraku = psks0107b_bl.Sukoraku_Select();
//DataTable dtukeharai = new DataTable();
//dtukeharai = psks0107b_bl.UKeHaRai_Select();
bool result = false;
string datetime = DateTime.Now.ToString();
baseEntity = new Base_Entity();
baseEntity.InsertDateTime = datetime;
result = psks0107b_bl.Data_Insert(baseEntity);
}
protected override void ExecSec()
{
try
{
bool ret = CheckDetail(0);
if (!ret)
{
return;
}
//テーブル転送仕様Ａに従って、汎用マスタ情報を更新（データが存在しなければInsert、データが存在する場合はUpdate）
M_MultiPorpose_Entity mme = new M_MultiPorpose_Entity();
mme.ID = MultiPorpose_BL.ID_ShukkaUriageUpdate;
mme.Key = "1";
mme.Num1 = ckM_TextBox1.Text.Replace(":", "");
mme.UpdateOperator = InOperatorCD;
mme.PC = InPcID;
sbl.M_MultiPorpose_Update(mme);
//更新後画面そのまま
detailControls[0].Focus();
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
private void btnStartType2_Click(object sender, EventArgs e)
{
try
{
mmpe = new M_MultiPorpose_Entity();
mmpe.ID = "324";
mmpe.Key = "1";
mmpe.UpdateOperator = InOperatorCD;
mmpe.PC = InPcID;
//現状、「処理実行中」の場合、何もしない
if (lblFTPMode2.Text != "処理実行中")
{
//現用、「処理停止中」(黄色)の場合、「処理実行中」(青色)とする
lblFTPMode2.Text = "処理実行中";
mmpe.Num1 = "1";
lblFTPMode2.BackColor = Color.DeepSkyBlue;
}
ftpsbl.M_MultiPorpose_Update(mmpe);
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
/// <summary>
/// EDI回答納期登録にて使用
/// </summary>
public bool M_MultiPorpose_Update(M_MultiPorpose_Entity mme)
{
string sp = "M_MultiPorpose_Update";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mme.ID
} },
{ "@Key", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.Key
} },
{ "@Num1", new ValuePair {
value1 = SqlDbType.Int, value2 = mme.Num1
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.UpdateOperator
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.PC
} },
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, sp));
}
private void BtnStop_Click(object sender, EventArgs e)
{
try
{
mmpe = new M_MultiPorpose_Entity();
mmpe.ID = "322";
mmpe.Key = "1";
mmpe.UpdateOperator = InOperatorCD;
mmpe.PC = InPcID;
//現状、「処理停止中」の場合、何もしない
if (lblEdiMode.Text != "処理停止中")
{
//現用、「処理実行中」(青色)の場合、「処理停止中」(黄色)とする
lblEdiMode.Text = "処理停止中";
mmpe.Num1 = "0";
lblEdiMode.BackColor = Color.Yellow;
}
ediNHJ_bl.M_MultiPorpose_Update(mmpe);
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
/// <summary>
/// Button Click For Flag Change
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnChange_Click(object sender, EventArgs e)
{
var btn = (Button)sender;
mme = new M_MultiPorpose_Entity();
lle = new L_Log_Entity();
mme.ID = "108";
mme.InsertOperator = lle.InsertOperator = loginInfo.OperatorCode;
mme.InsertDateTime = lle.OperateDate = DateTime.Now.ToString();
lle.Program = "PSKS0114C";
lle.PC = loginInfo.PcName;
//lle.OperateMode = "処理開始";
if (btn.Text == "開始")
{
if (lblSKSMode.Text != "処理実行中")
{
lblSKSMode.Text = "処理実行中";
lblSKSMode.BackColor = Color.FromArgb(0, 176, 240);
mme.Num1 = "1";
psks0114cbl.M_MultiPorposeNum1_Update(mme, lle);
}
}
else
{
if (lblSKSMode.Text != "処理停止中")
{
lblSKSMode.Text = "処理停止中";
lblSKSMode.BackColor = Color.Yellow;
mme.Num1 = "0";
psks0114cbl.M_MultiPorposeNum1_Update(mme, lle);
}
}
}
private void btnWebSave_Click(object sender, EventArgs e)
{
if (DateTimeNullCheck(txtStartTime))
{
tsie = new T_SugorakuInport_Entity();
tsie.InportStartTime = System.DateTime.Now.Date.ToShortDateString() + " " + txtStartTime.Text.ToString();
tsie.InportStartKBN = "2";
psks0108ibl.T_SugorakuInport_Update(tsie);
string dateTime = System.DateTime.Now.ToString();
mme = new M_MultiPorpose_Entity();
mme.Num1 = "0";
mme.Key = "1";
mme.InsertOperator = loginInfo.OperatorCode;
mme.InsertDateTime = dateTime;
mme.ID = "108";
if (psks0108ibl.M_MultiPorpose_Num1_Update(mme))
{
mme.ID = "109";
if (psks0108ibl.M_MultiPorpose_Num1_Update(mme))
{
lblStage2.BackColor = Color.Yellow;
buttonEnable_Check();
}
}
}
}
public String M_Multipurpose_Num1_Select(M_MultiPorpose_Entity mme)
{
DataTable dt = mmpdl.M_MultiPorpose_Select(mme);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0]["Num1"].ToString());
}
return(string.Empty);
}
public DataTable M_MultiPorpose_SupplierSelect(M_MultiPorpose_Entity mme)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mme.ID
} }
};
return(SelectData(dic, "M_MultiPorpose_SupplierSelect"));
}
public bool M_MultiPorpose_Num1_Update(M_MultiPorpose_Entity MmultiporposeData)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@ID", MmultiporposeData.ID);
dic.Add("@Num1", MmultiporposeData.Num1);
dic.Add("@UpdateOperator", MmultiporposeData.InsertOperator);
dic.Add("@UpdateDateTime", MmultiporposeData.InsertDateTime);
return(InsertUpdateDeleteData(dic, "M_MultiPorpose_Num1_Update"));
}
protected override void ExecDisp()
{
try
{
//【取込履歴】
M_MultiPorpose_Entity me = new M_MultiPorpose_Entity
{
ID = MultiPorpose_BL.ID_ShukkaUriageUpdate,
Key = "1"
};
MultiPorpose_BL mbl = new MultiPorpose_BL();
DataTable dt = mbl.M_MultiPorpose_Select(me);
if (dt.Rows.Count > 0)
{
string time = Convert.ToInt16(dt.Rows[0]["Num1"]).ToString("D4");
ckM_TextBox1.Text = time.Substring(0, 2) + ":" + time.Substring(2, 2);
}
else
{
////Ｅ１０１
//bbl.ShowMessage("E101");
//EndSec();
ckM_TextBox1.Text = "";
}
Scr_Clr(0);
//更新履歴情報データ取得処理
dt = sbl.D_Shipping_SelectAllForShoukai();
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
//bbl.ShowMessage("E128");
}
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
public DataTable M_MultiPorpose_SaleModeSelect(M_MultiPorpose_Entity mme)
{
string sp = "M_MultiPorpose_SaleModeSelect";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mme.ID
} },
};
return(SelectData(dic, sp));
}
public M_MultiPorpose_Entity M_MultiPurpose_Select()
{
DataTable dt = DynamicSelectData("Num1,Num2", "M_MultiPorpose", "where ID= 107 AND [Key]='1'");
M_MultiPorpose_Entity mme = new M_MultiPorpose_Entity();
if (dt.Rows.Count > 0)
{
mme.Num1 = dt.Rows[0]["Num1"].ToString();
mme.Num2 = dt.Rows[0]["Num2"].ToString();
}
return(mme);
}
public M_MultiPorpose_Entity M_MultiPorpose_Num_Select()
{
mme = new M_MultiPorpose_Entity();
DataTable dt = mmdl.DynamicSelectData("Num1", "M_MultiPorpose", "Where ID=108 And [Key]='1'");
if (dt.Rows.Count > 0)
{
mme.Num1 = dt.Rows[0]["Num1"].ToString();
return(mme);
}
return(mme);
}
private bool BindGrid()
{
mme = GetEntity();
DataTable dt = mbl.M_MultiPorpose_SelectAll(mme);
if (dt.Rows.Count == 0)
{
return(false);
}
dgvDetail.DataSource = dt;
return(true);
}
/// <summary>
/// Control Flag at Form Load
/// </summary>
private void StatusControl()
{
mme = psks0114cbl.M_MultiPorpose_Num_Select();
if (mme.Num1 == "1")
{
lblMode.Text = "処理実行中";
lblMode.BackColor = Color.CornflowerBlue;
}
else
{
lblMode.Text = "処理停止中";
lblMode.BackColor = Color.Yellow;
}
}
public bool M_MultiPorpose_SaleModeSelect(M_MultiPorpose_Entity mme)
{
mme.ID = MultiPorpose_BL.ID_HaspoSaleDate;
DataTable dt = mmdl.M_MultiPorpose_SaleModeSelect(mme);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool M_MultiPorpose_Num1_Update(M_MultiPorpose_Entity mme, L_Log_Entity lle)
{
mmdl.StartTransaction();
if (mmdl.M_MultiPorpose_Num1_Update(mme))
{
lldl.Transaction = mmdl.Transaction;
if (lldl.L_Log_Insert(lle))
{
mmdl.CommitTransaction();
return(true);
}
}
return(false);
}
public DataTable M_MultiPorpose_SelectByChar1(M_MultiPorpose_Entity mme)
{
string sp = "M_MultiPorpose_SelectByChar1";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mme.ID
} },
{ "@Char1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.Char1
} }
};
return(SelectData(dic, sp));
}
/// <summary>
/// Control Flag at Form Load
/// </summary>
private void StatusControl()
{
mme = new M_MultiPorpose_Entity();
mme = psks0114cbl.M_MultiPorpose_Num_Select();
if (mme.Num1 == "1")
{
lblSKSMode.Text = "処理実行中";
lblSKSMode.BackColor = Color.FromArgb(0, 176, 240);
}
else
{
lblSKSMode.Text = "処理停止中";
lblSKSMode.BackColor = Color.Yellow;
}
}
private void frmPSKS0103I_Load(object sender, EventArgs e)
{
FunctionButtonDisabled(2);
FunctionButtonDisabled(3);
FunctionButtonDisabled(4);
FunctionButtonDisabled(5);
FunctionButtonDisabled(7);
FunctionButtonDisabled(8);
FunctionButtonDisabled(10);
FunctionButtonDisabled(11);
pskso116ibl = new PSKS0116I_BL();
psks0103ibl = new PSKS0103I_BL();
ucSupplier.GotFocus += new System.EventHandler(ucSupplier_GotFocus);
FormName = "メーカー在庫取込";
lblMode.Visible = true;
lblMode.Text = "先に通常取込を実施してください";
lblMode.BackColor = Color.FromArgb(255, 102, 255);
lblMode.Width = 250;
lblMode.TextAlign = ContentAlignment.MiddleCenter;
btnImport.Enabled = false;
FunctionButtonDisabled(12);
mme = new M_MultiPorpose_Entity();
mme.fields = "Char1,Num1";
mme.tableName = "M_MultiPorpose";
mme.condition = "Where ID=101 And [Key]='1'";
DataTable dt = psks0103ibl.M_MultiPorpose_DynamicSelect(mme);
if (dt.Rows.Count > 0)
{
lblServerPath.Text = "サーバーの" + dt.Rows[0]["Char1"].ToString() + "フォルダーに保存されているファイルを取込します。";
lblHistory.Text = dt.Rows[0]["Num1"] + "日間の履歴を保持しています";
folderPath = dt.Rows[0]["Char1"].ToString();
}
dgvImportRireki.DisabledColumn("colNo1,colInportDateTime,colDataMoto,colInportFile,colInportOperator,colInportSu,colErrorSu");
dgvFileDetail.DisabledColumn("*");
tmire = new T_MakerInportRireki_Entity();
DataTable dtInport = psks0103ibl.T_MakerInportRireki_SELECT(tmire);
dgvImportRireki.DataSource = dtInport;
}
/// <summary>
/// Select Key + '：' + Char1
/// </summary>
/// <param name="mme"></param>
/// <returns></returns>
public DataTable M_MultiPorpose_SelectForCombo(M_MultiPorpose_Entity mme, string DisplayMember = "")
{
DataTable dt = mmdl.M_MultiPorpose_SelectAll(mme);
int count = dt.Columns.Count;
if (mme.ID == MultiPorpose_BL.ID_ArrivalPlanCD)
{
DataRow[] rows = dt.Select("Num2 NOT IN (1,2,4,6)");
for (int i = 0; i < rows.Length; i++)
{
if (rows[i].RowState != DataRowState.Deleted)
{
rows[i].Delete();
}
}
}
ArrayList arrlst = new ArrayList();
arrlst.Add("Key");
if (DisplayMember.Equals("") || DisplayMember.Equals("KeyAndChar1"))
{
arrlst.Add("KeyAndChar1");
}
else if (DisplayMember.Equals("Char1"))
{
arrlst.Add("Char1");
}
else if (DisplayMember.Equals("Key2"))
{
arrlst.Add("Key2");
}
for (int i = 0; i < count; i++)
{
if (!arrlst.Contains(dt.Columns[i].ColumnName))
{
dt.Columns.RemoveAt(i);
i--;
count--;
dt.AcceptChanges();
}
}
return(dt);
}
//string OperatorCD = string.Empty;
//public async void Import(M_MultiPorpose_Entity mmpe)
public void Import(M_MultiPorpose_Entity mmpe)
{
folderPath = mmpe.Char1;
ArrayList FilePath = getFilePath();
//int i = 0;
foreach (string s in FilePath)
{
dee.UpdateOperator = "Batch";
dee.ImportFile = System.IO.Path.GetFileName(s);
dee.VendorCD = System.IO.Path.GetFileName(System.IO.Path.GetDirectoryName(s));
//await Insert(s);
InsertData(s);
//i++;
}
}
public DataTable M_MultiPorpose_AuxiliarySelect(M_MultiPorpose_Entity mme)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mme.ID
} },
{ "@Key", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.Key
} },
{ "@Char1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.Char1
} }
};
return(SelectData(dic, "M_MultiPorpose_AuxiliarySelect"));
}
public DataTable M_MultiPorpose_SelectAll(M_MultiPorpose_Entity mme)
{
string sp = "M_MultiPorpose_SelectAll";
//KTP 2019-0529 全部のFunctionでをしなくてもいいように共通のFunctionでやり方を更新しました。
//command = new SqlCommand(sp, GetConnection());
//command.CommandType = CommandType.StoredProcedure;
//command.CommandTimeout = 0;
//command.Parameters.Add("@ID", SqlDbType.Int).Value = mme.ID;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ID", new ValuePair {
value1 = SqlDbType.Int, value2 = mme.ID
} }
};
return(SelectData(dic, sp));
}
private void Control()
{
DataTable dt_Num = new DataTable();
mme = psks0111cbl.M_MultiPorpose_Num_Select();
lblNum3.Text = mme.Num3 + "日間の履歴を保持しています";
if (mme.Num1 == "1")
{
lblSKSMode.Text = "処理実行中";
lblSKSMode.BackColor = Color.FromArgb(0, 176, 240);
}
else
{
lblSKSMode.Text = "処理停止中";
lblSKSMode.BackColor = Color.Yellow;
}
}
static void Main(string[] args)
{
Console.Title = "PSKS0113B_店舗在庫情報取得";
String sourcePath = @"\\192.168.0.14\ablesoft\CONPHAS-GENERAL\DATA";
String targetPath = @"F:\Development\ShopData";
M_MultiPorpose_Entity mme = new M_MultiPorpose_Entity();
PSKS0113B_BL PSKS0113Bbl = new PSKS0113B_BL();
mme = PSKS0113Bbl.M_MultiPurpose_Select();
while (mme.Num1 == "0")
{
Console.WriteLine("Stop");
Thread.Sleep(Convert.ToInt32(mme.Num2) * 1000);
mme = PSKS0113Bbl.M_MultiPurpose_Select();
}
#region copy file
string fileName = "FreeDAT.mdb";
string s = System.IO.Path.Combine(sourcePath, fileName);
string destFile = System.IO.Path.Combine(targetPath, fileName);
string shopFlag = "0";
if (File.Exists(s))
{
System.IO.File.Copy(s, destFile, true);
shopFlag = "1";
}
#endregion
Console.WriteLine("Import Start!");
if (PSKS0113Bbl.ImportShopData(shopFlag))
{
if (shopFlag.Equals("1"))
{
System.IO.File.Delete(destFile); // delete file after import data
}
}
else
{
}
}
public bool DynamicUpdateData(M_MultiPorpose_Entity mme)
{
string query = "Update " + mme.tableName + " Set Char1= '" + mme.fields.Split(',').First() + "' , Char2= '" + mme.fields.Split(',').Last() + "'" + mme.condition;
SqlConnection conn = GetConnection();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandTimeout = 0;
try
{
conn.Open();
cmd.ExecuteNonQuery();
if (!useTransaction)
{
cmd.Connection.Close();
}
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// Control to run or not console
/// </summary>
private void UpdateM_MultiPorpose()
{
mmpe = new M_MultiPorpose_Entity();
mmpe.ID = "322";
mmpe.Key = "1";
mmpe.UpdateOperator = InOperatorCD;
mmpe.PC = InPcID;
if (mEdiMode == "1")
{
// 記憶していた初期表示値が１
//＆画面・在庫SKS連携処理の処理モードが「処理停止中」の場合
if (lblEdiMode.Text == "処理停止中")
{
mmpe.Num1 = "0";
}
else
{
return;
}
}
else
{
// 記憶していた初期表示値が０
//＆画面・在庫SKS連携処理の処理モードが「処理実行中」の場合
if (lblEdiMode.Text == "処理実行中")
{
mmpe.Num1 = "1";
}
else
{
return;
}
}
ediNHJ_bl.M_MultiPorpose_Update(mmpe);
}
