public static List <m_staff> GetlistAllTable()
{
NpgsqlDataReader dataReader = null;
var res = new List <m_staff>();
using (var dbc = new DBConnect())
{
dbc.npg.Open();
StringBuilder sb = new StringBuilder();
sb.Append(@"select store_code, staff_code, staff_name, staff_name_kana, login_id, password, permission_class, work_class, status,sex ");
sb.Append(@"from m_staff ");
sb.Append(@"where m_staff.delete_flag = '0' ");
sb.Append(@"order by m_staff.store_code asc, m_staff.staff_code asc ,m_staff.registration_date asc;");
var command = new NpgsqlCommand(sb.ToString(), dbc.npg);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
m_staff staff = new m_staff();
staff.store_code = dataReader["store_code"].ToString();
staff.staff_code = dataReader["staff_code"].ToString();
staff.staff_name = dataReader["staff_name"].ToString();
staff.staff_name_kana = dataReader["staff_name_kana"].ToString();
staff.login_id = dataReader["login_id"].ToString();
staff.password = dataReader["password"].ToString();
staff.permission_class = dataReader["permission_class"].ToString();
staff.work_class = dataReader["work_class"].ToString();
staff.status = dataReader["status"].ToString();
staff.sex = dataReader["sex"].ToString();
res.Add(staff);
}
}
return(res);
}
public static m_staff getFirstStaff(string staffCode)
{
m_staff s = null;
using (var dbc = new DBConnect())
{
s = dbc.m_staff.Single(x => x.staff_code == staffCode);
}
return(s);
}
public static m_staff getSingle2(string storeCode, string staffCode)
{
m_staff s = null;
using (var dbc = new DBConnect())
{
s = dbc.m_staff.Single(x => x.store_code == storeCode & x.staff_code == staffCode);
}
return(s);
}
//登録
private void b_regist_Click(object sender, EventArgs e)
{
//入力チェック
chk.clear();
chk.addControl(d_tenpo);
chk.addControl(t_staff_code);
chk.addControl(t_staff);
chk.addControl(t_staff_kana);
chk.addControl(t_login_id);
chk.addControl(t_password);
chk.addControl(d_kengen);
chk.addControl(d_employment);
chk.addControl(d_seibetsu);
chk.addControl(d_status);
if (chk.check("W00000", chk.checkControlImportant))
{
return;
}
//桁数チェック
chk.clear();
chk.addControl(t_staff_code);
if (chk.check("W00001", chk.checkTextboxLength, 8))
{
return;
}
chk.clear();
chk.addControl(t_login_id);
chk.addControl(t_staff);
if (chk.check("W00001", chk.checkTextboxLength, 20))
{
return;
}
chk.clear();
chk.addControl(t_staff_kana);
if (chk.check("W00001", chk.checkTextboxLength, 40))
{
return;
}
chk.clear();
chk.addControl(t_password);
if (chk.check("W00001", chk.checkTextboxLength, 256))
{
return;
}
//データベース更新処理
//データの取得
StaffListStore();
if (update_flag == false || newData_flag == true)
{
// 接続インスタンスを作成。
var dbc = new DB.DBConnect();
// 登録する新規データの入れ物を作成(スタッフマスターに対して実行する)。
DB.m_staff data = dbc.m_staff.Create();
//データの投入
data.store_code = staff_store_code;
data.staff_code = staff_code;
data.staff_name = staff_name;
data.staff_name_kana = staff_name_kana;
data.login_id = staff_login_id;
data.password = staff_Hash_password;
data.permission_class = staff_kengen;
data.work_class = staff_employment;
data.status = staff_status;
data.sex = staff_seibetu;
data.registration_date = staff_registration_date;
data.registration_staff = staff_registration_staff;
data.update_date = staff_update_date;
data.update_staff = staff_update_staff;
data.delete_flag = staff_delete_flag;
// レコードををテーブルに登録。
dbc.m_staff.Add(data);
try
{
dbc.SaveChanges();
}
catch (Exception)
{
Utile.Message.showMessageOK("E14000");
return;
}
finally
{
dbc.npg.Close();
}
}
else if (update_flag == true || newData_flag == false)
{
// 接続インスタンスを作成。
var dbc2 = new DB.DBConnect();
//更新用スタッフコードの取得
index = currentPage - 1;
updateStaffCode = StaffDBList[index].staff_code;
//更新前データの取り込み
var filterData = StaffDBList[index];
storeIndex = this.d_tenpo.SelectedIndex;
//更新前データの取り込み
m_StaffStaff_store_code = filterData.staff_store_code;
m_StaffStaff_code = filterData.staff_code;
m_StaffStaff_name = filterData.staff_name;
m_StaffStaff_name_kana = filterData.staff_name_kana;
m_StaffStaff_login_id = filterData.login_id;
m_StaffStaff_password = filterData.password;
m_StaffStaff_kengen = filterData.kengen;
m_StaffStaff_status = filterData.status;
m_StaffStaff_employment = filterData.employment;
m_StaffStaff_seibetu = filterData.seibetu;
m_StaffStaff_registration_date = filterData.registration_date;
m_StaffStaff_registration_staff = filterData.registration_staff;
m_StaffStaff_update_date = filterData.update_date;
m_StaffStaff_update_staff = filterData.update_staff;
m_StaffStaff_delete_flag = filterData.delete_flag;
//更新用スタッフコードの取得
index = currentPage - 1;
updateStaffCode = StaffDBList[index].staff_code;
storeIndex = this.d_tenpo.SelectedIndex;
updateStoreCode = storeCodeList[storeIndex].store_code;
// 接続インスタンスを作成。
var dbc = new DB.DBConnect();
dbc.npg.Open();
StringBuilder sb = new StringBuilder();
using (var transaction = dbc.npg.BeginTransaction())
{
sb.Append("update m_staff set ");
if (staff_store_code != m_StaffStaff_store_code)
{
sb.Append("store_code = '" + staff_store_code + "', ");
}
if (staff_code != m_StaffStaff_code)
{
sb.Append("staff_code = '" + staff_code + "', ");
}
if (staff_name != m_StaffStaff_name)
{
sb.Append("staff_name = '" + staff_name + "', ");
}
if (staff_name_kana != m_StaffStaff_name_kana)
{
sb.Append("staff_name_kana = '" + staff_name_kana + "', ");
}
if (staff_login_id != m_StaffStaff_login_id)
{
sb.Append("login_id = '" + staff_login_id + "', ");
}
if (staff_Hash_password != m_StaffStaff_password)
{
sb.Append("password = '******', ");
}
if (staff_kengen != m_StaffStaff_kengen)
{
sb.Append("permission_class = '" + staff_kengen + "', ");
}
if (staff_employment != m_StaffStaff_employment)
{
sb.Append("work_class = '" + staff_employment + "', ");
}
if (staff_status != m_StaffStaff_status)
{
sb.Append("status = '" + staff_status + "', ");
}
if (staff_seibetu != m_StaffStaff_seibetu)
{
sb.Append("sex = '" + staff_seibetu + "', ");
}
sb.Append("update_date = '" + nowToday + "', ");
sb.Append("update_staff = '" + MainForm.session_m_staff.staff_name + "', ");
sb.Append("delete_flag = '" + staff_delete_flag + "' ");
sb.Append("where store_code = '" + staff_store_code + "' AND ");
sb.Append("staff_code = '" + staff_code + "';");
string strsql = sb.ToString();
var command = new NpgsqlCommand(strsql, dbc.npg);
try
{
command.ExecuteNonQuery();
transaction.Commit();
}
catch (NpgsqlException)
{
transaction.Rollback();
Utile.Message.showMessageOK("E14001");
return;
}
finally
{
dbc.npg.Close();
}
}
}
//登録後画面初期化し次の登録を始める
MainForm.Staff_master.PageRefresh();
//MainForm.backPage(this);
if (data_flag == false && update_flag == false)
{
currentPage++;
totalPage++;
}
else if (data_flag == true && update_flag == false)
{
currentPage = StaffDBList.Count + 1;
totalPage = StaffDBList.Count + 1;
}
else if (data_flag == true && update_flag == true)
{
currentPage = StaffDBList.Count;
totalPage = StaffDBList.Count;
}
//新規データフラグを立てる
newData_flag = true;
//データ取得
ListArrayStaff();
init_flag = false;
update_flag = false;
Set_initialDisplay();
t_current_page.Text = (string)currentPage.ToString("0");
t_total_page.Text = (string)totalPage.ToString("0");
pageParent.PageRefresh();
MainForm.backPage(this);
}
