/// <summary>
/// 창고 등록, 수정관리
/// </summary>
/// <param ID="storage_id"></param>
/// <returns></returns>
public bool SaveStorage(StorageVO vo)
{
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
string sql = "SP_SAVE_STORAGE";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_storage_id", vo.Storage_Id);
cmd.Parameters.AddWithValue("@P_storage_name", vo.Storage_Name);
cmd.Parameters.AddWithValue("@P_factory_id", vo.Factory_id);
cmd.Parameters.AddWithValue("@P_storage_seq", vo.Storage_Seq);
cmd.Parameters.AddWithValue("@P_storage_use", vo.Storage_Use);
cmd.Parameters.AddWithValue("@P_first_regist_employee", vo.First_regist_employee);
cmd.Parameters.AddWithValue("@P_final_regist_employee", vo.Final_regist_employee);
cmd.ExecuteNonQuery();
}
return(true);
}
}
catch (Exception err)
{
return(false);
throw err;
}
}
public GameVO()
{
instance = this;
if (PlayerPrefs.HasKey("isFirstGame"))
{
isFirstGame = false;
}
else
{
isFirstGame = true;
PlayerPrefs.SetInt("isFirstGame", 1);
}
storage = new StorageVO();
GameObject obj = new GameObject();
daily = obj.AddComponent <Daily>();
musicVolumn.value = 0;
soundVolumn.value = 0;
//播放背景音乐
bgm = ResourceManager.PlaySound("music/" + bgmId.value, true, musicVolumn.value / 100.0f);
bgmId.AddListener(lib.Event.CHANGE, OnBgmChange);
soundVolumn.AddListener(lib.Event.CHANGE, OnSoundVolumnChange);
musicVolumn.AddListener(lib.Event.CHANGE, OnMusicVolumnChange);
language.AddListener(lib.Event.CHANGE, OnLanguageChange);
}
public StoragePopupForm(string employeeName, bool IsUpdate, StorageVO vo)
{
InitializeComponent();
this.IsUpdate = IsUpdate;
this.employeeName = employeeName;
if (IsUpdate == true)
{
this.vo = vo;
}
}
private void OpenPopup(bool IsUpdate, StorageVO vo = null)
{
if (((MainForm)this.MdiParent).ActiveMdiChild == this)
{
StoragePopupForm frm = new StoragePopupForm(emp.Employee_name, IsUpdate, vo);
if (frm.ShowDialog() == DialogResult.OK)
{
ReviewDGV();
}
}
}
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
StorageVO updatevo = new StorageVO
{
Storage_Id = dgv[1, e.RowIndex].Value.ToInt(),
Corporation_Name = dgv[2, e.RowIndex].Value.ToString(),
Factory_Name = dgv[3, e.RowIndex].Value.ToString(),
Storage_Name = dgv[4, e.RowIndex].Value.ToString(),
Storage_Use = dgv[5, e.RowIndex].Value.ToString(),
Storage_Seq = dgv[6, e.RowIndex].Value.ToInt()
//Final_regist_time = DateTime.Now,
//Final_regist_employee = employee.Employee_name
};
OpenPopup(true, updatevo);
}
private void StorageSave(string UseCheck, string Status, int storage_id)
{
if (MessageBox.Show($"창고를 {Status}하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
StorageVO storage = new StorageVO
{
Storage_Id = storage_id,
Factory_id = cboFactory.SelectedValue.ToInt(),
Storage_Name = txtStorage.Text,
Storage_Seq = Convert.ToInt32((nudStorage_seq.Value.ToString().Length > 0) ? nudStorage_seq.Value.ToString() : "0"),
Storage_Use = UseCheck,
First_regist_employee = employeeName,
Final_regist_employee = employeeName,
};
if (service.SaveStorage(storage))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
public bool SaveStorage(StorageVO vo)
{
return(dac.SaveStorage(vo));
}