private MasterTourokuStaff GetInsertStaff()
{
MasterTourokuStaff obj = new MasterTourokuStaff();
obj.StaffCD = txt_Staff.Text.ToString();
obj.ChangeDate = txtStaff_CDate.Text.ToString();
obj.StaffName = txtStaff_Name.Text.ToString();
obj.KanaName = txtStaff_KanaName.Text.ToString();
int int_val = 0;
int.TryParse(txtStaff_Search.Text, NumberStyles.Any, CultureInfo.CurrentCulture, out int_val);
obj.KensakuHyouziJun = int_val.ToString();
obj.MenuCD = cboStaff_Menu.SelectedValue.ToString();
obj.AuthorizationsCD = cboStaff_authority.SelectedValue.ToString();
obj.PositionCD = string.IsNullOrEmpty(cboStaff_Position.Text.ToString()) ? "" : cboStaff_Position.SelectedValue.ToString();
obj.JoinDate = txtStaff_JDate.Text.ToString();
obj.LeaveDate = txtStaff_LDate.Text.ToString();
obj.Passward = txtStaff_Passward.Text;
obj.Remarks = txtStaff_Remark.Text;
obj.UsedFlg = 0;
obj.InsertOperator = base_Entity.OperatorCD;
obj.UpdateOperator = base_Entity.OperatorCD;
//for log table
obj.ProgramID = base_Entity.ProgramID;
obj.KeyItem = txt_Staff.Text.ToString() + " " + txtStaff_CDate.Text;
obj.PC = base_Entity.PC;
return(obj);
}
public DataTable Staff_Search(MasterTourokuStaff obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[6];
parameters[0] = new SqlParameter("@StaffCD1", SqlDbType.VarChar)
{
Value = obj.StaffCD
};
parameters[1] = new SqlParameter("@StaffCD2", SqlDbType.VarChar)
{
Value = obj.Passward
};
parameters[2] = new SqlParameter("@StaffName", SqlDbType.VarChar)
{
Value = obj.StaffName
};
parameters[3] = new SqlParameter("@KanaName", SqlDbType.VarChar)
{
Value = obj.KanaName
};
parameters[4] = new SqlParameter("@RadioCheck", SqlDbType.VarChar)
{
Value = obj.Remarks
};
parameters[5] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = obj.ChangeDate
};
DataTable dt = ckmdl.SelectDatatable("Staff_Search", GetConnectionString(), parameters);
return(dt);
}
private void DoDelete(MasterTourokuStaff obj)
{
StaffBL objMethod = new StaffBL();
string return_Bl = objMethod.M_Staff_CUD(obj);
if (return_Bl == "true")
{
bbl.ShowMessage("I102");
}
}
public DataTable MH_Staff_LoginSelect(MasterTourokuStaff mts)
{
CKMDL ckmdl = new CKMDL();
mts.Sqlprms = new SqlParameter[2];
mts.Sqlprms[0] = new SqlParameter("@StaffCD", SqlDbType.VarChar)
{
Value = mts.StaffCD
};
mts.Sqlprms[1] = new SqlParameter("@Password", SqlDbType.VarChar)
{
Value = mts.Passward
};
return(ckmdl.SelectDatatable("M_StaffAccess", GetConnectionString(), mts.Sqlprms));
}
public DataTable D_MenuMessageSelect(string SCD)
{
MasterTourokuStaff mts = new MasterTourokuStaff()
{
StaffCD = SCD
};
// return mdl.D_MenuMessageSelect(SCD);
CKMDL ckmdl = new CKMDL();
mts.Sqlprms = new SqlParameter[1];
mts.Sqlprms[0] = new SqlParameter("@StaffCD", SqlDbType.VarChar)
{
Value = mts.StaffCD
};
return(ckmdl.SelectDatatable("SMENU", GetConnectionString(), mts.Sqlprms));
}
private void DataGridviewBind()
{
MasterTourokuStaff obj = new MasterTourokuStaff();
obj.ChangeDate = changeDate_Access;
obj.StaffCD = txtStaff1.Text;
obj.Passward = txtStaff2.Text;//using tempory for assign data
obj.StaffName = txtStaffName.Text;
obj.KanaName = txtKanaName.Text;
obj.Remarks = string.Empty;
if (rdo_Date.Checked)
{
obj.Remarks = "RevisionDate";
}
if (rdo_All.Checked)
{
obj.Remarks = "All";
}
StaffBL objMethod = new StaffBL();
DataTable dt = objMethod.Staff_Search(obj);
if (dt.Columns.Contains("CurrentDay"))
{
if (dt.Rows.Count > 0)
{
lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]);
//dt.Columns.Remove("CurrentDay");
}
else
{
ClearSession(); //HET
}
}
else
{
if (dt.Rows.Count == 0) //HET
{
ClearSession();
}
}
// dt.Columns.Remove("CurrentDay");
gvStaff.DataSource = dt;
}
private void DBProcess()
{
MasterTourokuStaff entity = GetInsertStaff();
if (cboMode.SelectedValue.Equals("1"))
{
entity.Mode = "New";
DoInsert(entity);
}
else if (cboMode.SelectedValue.Equals("2"))
{
entity.Mode = "Update";
DoUpdate(entity);
}
else if (cboMode.SelectedValue.Equals("3"))
{
entity.Mode = "Delete";
DoDelete(entity);
}
}
private void Login_Click()
{
StartProg();
if (ErrorCheck())
{
MasterTourokuStaff mts = new MasterTourokuStaff()
{
StaffCD = OperatorCD,
Passward = txtPassword.Text
};
var mse = loginbl.MH_Staff_LoginSelect(mts);
if (mse.Rows.Count > 0)
{
if (mse.Rows[0]["MessageID"].ToString() == "Allow")
{
if (loginbl.D_MenuMessageSelect(OperatorCD).Rows.Count == 0)
{
loginbl.ShowMessage("S013");
txtOperatorCD.Select();
return;
}
ShinyohMenu menuForm = new ShinyohMenu(OperatorCD, BaseBL.IEntity.Version);
this.Hide();
menuForm.ShowDialog();
this.Close();
}
else
{
loginbl.ShowMessage(mse.Rows[0]["MessageID"].ToString());
txtOperatorCD.Select();
}
}
else
{
loginbl.ShowMessage("E101");
txtOperatorCD.Select();
}
}
}
public string M_Staff_CUD(MasterTourokuStaff obj)
{
CKMDL ckmdl = new CKMDL();
ckmdl.UseTran = true;
obj.Sqlprms = new SqlParameter[18];
obj.Sqlprms[0] = new SqlParameter("@StaffCD", SqlDbType.VarChar)
{
Value = obj.StaffCD
};
obj.Sqlprms[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = obj.ChangeDate
};
obj.Sqlprms[2] = new SqlParameter("@StaffName", SqlDbType.VarChar)
{
Value = obj.StaffName
};
obj.Sqlprms[3] = new SqlParameter("@KanaName", SqlDbType.VarChar)
{
Value = obj.KanaName
};
obj.Sqlprms[4] = new SqlParameter("@KensakuHyouziJun", SqlDbType.VarChar)
{
Value = obj.KensakuHyouziJun
};
obj.Sqlprms[5] = new SqlParameter("@MenuCD", SqlDbType.VarChar)
{
Value = obj.MenuCD
};
obj.Sqlprms[6] = new SqlParameter("@AuthorizationsCD", SqlDbType.VarChar)
{
Value = obj.AuthorizationsCD
};
obj.Sqlprms[7] = new SqlParameter("@PositionCD", SqlDbType.VarChar)
{
Value = obj.PositionCD
};
obj.Sqlprms[8] = new SqlParameter("@JoinDate", SqlDbType.VarChar)
{
Value = obj.JoinDate
};
obj.Sqlprms[9] = new SqlParameter("@LeaveDate", SqlDbType.VarChar)
{
Value = obj.LeaveDate
};
obj.Sqlprms[10] = new SqlParameter("@Passward", SqlDbType.VarChar)
{
Value = obj.Passward
};
obj.Sqlprms[11] = new SqlParameter("@Remarks", SqlDbType.VarChar)
{
Value = obj.Remarks
};
//obj.Sqlprms[12] = new SqlParameter("@UsedFlg", SqlDbType.VarChar) { Value = obj.UsedFlg };
obj.Sqlprms[12] = new SqlParameter("@InsertOperator", SqlDbType.VarChar)
{
Value = obj.InsertOperator
};
obj.Sqlprms[13] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar)
{
Value = obj.UpdateOperator
};
obj.Sqlprms[14] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = obj.Mode
};
obj.Sqlprms[15] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = obj.ProgramID
};
obj.Sqlprms[16] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = obj.PC
};
obj.Sqlprms[17] = new SqlParameter("@KeyItem", SqlDbType.VarChar)
{
Value = obj.KeyItem
};
//obj.Sqlprms[19] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar) { Value = obj.YuubinNO1 };
//obj.Sqlprms[20] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar) { Value = obj.YuubinNO2};
return(ckmdl.InsertUpdateDeleteData("M_Staff_CUD", GetConnectionString(), obj.Sqlprms));
}
