public List <CInventory> GetMaterialList()
{
CInventory ci = new CInventory();
return(ci.ReadList());
//return null;
}
public override void Init(CUnit unit)
{
CPlayerUnit player = unit as CPlayerUnit;
if (player == null)
{
return;
}
base.Init(unit);
if (m_vowIcon != null && m_vowIcons.Length >= 2)
{
m_vowIcon.sprite = m_vowIcons[(int)player.Gender];
}
m_input = player.InputCtrl;
m_inventory = player.Inventory;
Cursor.lockState = CursorLockMode.Locked;
Cursor.visible = false;
if (m_menuGo != null)
{
m_menuGo.SetActive(false);
}
InventoryCheck();
}
private void DrawItemSelectPanel(CInventory inventory)
{
_inventory = inventory;
for (int i = 0; i < EQUIP_BUTTON_COUNT; i++)
{
if (i < inventory.EquipItems.Count)
{
_equipBtnObjectArr[i].gameObject.GetComponent <Image>().sprite = _inventory.EquipItems[i].ItemImage;
_equipBtnObjectArr[i].GetComponent <Button>().interactable = true;
}
else
{
_equipBtnObjectArr[i].gameObject.GetComponent <Image>().sprite = null;
_equipBtnObjectArr[i].GetComponent <Button>().interactable = false;
}
}
for (int i = 0; i < CONSUMABLE_BUTTON_COUNT; i++)
{
if (i < inventory.ConsumableItems.Count)
{
_consumableBtnObjectArr[i].gameObject.GetComponent <Image>().sprite = _inventory.ConsumableItems[i].consumable.ItemImage;
_consumableBtnObjectArr[i].GetComponent <Button>().interactable = true;
}
else
{
_consumableBtnObjectArr[i].gameObject.GetComponent <Image>().sprite = null;
_consumableBtnObjectArr[i].GetComponent <Button>().interactable = false;
}
}
}
public void OpenInventory(CInventory inventory)
{
_activedWindow = _inventoryWindow.gameObject;
_activedWindow.SetActive(true);
SetControlLockCallback(true);
_inventoryWindow.OpenInventory(inventory);
}
public void OpenInventory(CInventory inventory)
{
_inventory = inventory;
UpdateInventoryWindow();
OpenPlayerInventory();
}
public CInventorySystem()
{
m_Notes = 0;
m_Gems = 0;
m_Items = new Dictionary <string, CItemSlot>();
m_HotBar = null;
m_Inventory = null;
}
public CInventorySystem(CInventorySlots _HotbarScript, CInventory _InventoryScript)
{
m_Notes = 0;
m_Gems = 0;
m_Items = new Dictionary <string, CItemSlot>();
m_HotBar = _HotbarScript;
m_Inventory = _InventoryScript;
}
protected override void Start()
{
m_unitTag = "Player";
gameObject.tag = m_unitTag;
CDataManager dataMgr = CDataManager.Inst;
if (dataMgr == null)
{
return;
}
Data.PlayerInfo playerInfo = dataMgr.PlayerRecord.PlayerInfo;
GameObject genderPrefab = null;
if (playerInfo.gender == Gender.Female)
{
genderPrefab = Resources.Load <GameObject>("Prefabs/Character/Player/Female");
Gender = Gender.Female;
}
else
{
genderPrefab = Resources.Load <GameObject>("Prefabs/Character/Player/Male");
Gender = Gender.Male;
}
if (genderPrefab == null)
{
return;
}
GameObject genderGO = Instantiate(genderPrefab, transform);
genderGO.name = genderPrefab.name;
base.Start();
m_inputCtrl = GetComponent <CInputCtrl>();
CameraCtrl.SetCamera(m_inputCtrl, this);
m_inventory = GetComponent <CInventory>();
m_inventory.Initialized(this);
if (m_unitUIPrefab)
{
GameObject uiObj = Instantiate <GameObject>(m_unitUIPrefab, CStageUIManager.Inst.transform);
uiObj.name = m_unitUIPrefab.name;
m_unitUI = uiObj.GetComponent <CUnitUI>();
if (m_unitUI != null)
{
m_unitUI.Init(this);
}
}
}
//public CResult Update(CInventory oInventory)
//{
// oResult = new CResult();
// conn = oConnManager.GetConnection(out s_DBError);
// if (conn != null)
// {
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.Parameters.Clear();
// cmd.Transaction = oConnManager.BeginTransaction();
// try
// {
// cmd.CommandText = "sp_Inventory_Update";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Invt_OID", oInventory.Invt_OID);
// cmd.Parameters.AddWithValue("@Invt_Branch", oInventory.Invt_Branch);
// cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
// cmd.Parameters.AddWithValue("@Invt_QTY", oInventory.Invt_QTY);
// cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType);
// cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
// cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
// cmd.ExecuteNonQuery();
// oConnManager.Commit();
// oResult.IsSuccess = true;
// }
// catch (SqlException e)
// {
// oResult.ErrMsg = e.Message;
// oResult.IsSuccess = false;
// string sRollbackError = oConnManager.Rollback();
// }
// finally
// {
// oConnManager.Close();
// }
// }
// else
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = s_DBError;
// }
// return oResult;
//}
public CResult ReadQtyByCond(CInventory oInventory)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_Invt_ReadQtyByCond";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType);
SqlDataReader oReader = cmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
oInventory.Invt_QTY = float.Parse(oReader["Invt_QTY"].ToString());
}
oReader.Close();
}
oResult.IsSuccess = true;
oResult.Data = oInventory;
}
catch (SqlException e)
{
oResult.IsSuccess = false;
oResult.ErrMsg = e.Message;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Update(CInventory oInventory)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Inventory_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Invt_OID", oInventory.Invt_OID);
cmd.Parameters.AddWithValue("@Invt_Branch", oInventory.Invt_Branch);
cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
cmd.Parameters.AddWithValue("@Invt_QTY", oInventory.Invt_QTY);
cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType);
cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
oResult.ErrMsg = e.Message;
oResult.IsSuccess = false;
string sRollbackError = oConnManager.Rollback();
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public void Init(CInventory inventory)
{
if (inventory == null)
{
Debug.Log("Inventory is null");
return;
}
m_inventory = inventory;
//TODO: 인벤토리 및 아이템 박스에 맞춰서 내용 갱신
m_itemPageText.text = "1/1";
UpdateInventoryIcon();
UpdateBoxIcon();
}
private CInventory GetresultoInventory(DataRow dr)
{
CInventory oInventory = new CInventory();
oInventory.Invt_OID = dr[0].ToString();
oInventory.Invt_Branch = dr[1].ToString();
oInventory.Invt_ItemOID = dr[2].ToString();
oInventory.Invt_QTY = float.Parse(dr[3].ToString());
oInventory.Invt_InvType = int.Parse(dr[4].ToString());
oInventory.Invt_BranchOID = dr[5].ToString();
oInventory.Invt_LocOID = dr[6].ToString();
oInventory.Invt_ItemName = dr[7].ToString();
return(oInventory);
}
protected override void DetectedItemAction()
{
if (!CanMove || IsUseItem || !m_movement.IsOnGround || InAction)
{
return;
}
if (!m_input.InputData.btnInputs[(int)InputIndex.B])
{
return;
}
CPlayerUnit player = m_unit as CPlayerUnit;
if (player == null)
{
return;
}
CInventory inventory = player.Inventory;
if (inventory == null)
{
return;
}
IsUseItem = true;
m_anim.SetBool("IsUseItem", IsUseItem);
CUseItem item = inventory.ItemUse(inventory.CurItemSelect) as CUseItem;
int nIdx = (int)UseAnimType.MAX;
if (item == null)
{
m_anim.Play("Item" + nIdx);
return;
}
nIdx = (int)item.UseAnimType;
// 아이템 사용 번호에 따라 아이템 액션 변경 및 던지는 물체의 경우 발사체 소환
m_anim.Play("Item" + nIdx);
m_unit.CurUseItem = item;
}
//ZMap<unsigned short, ZXString<char>, unsigned short> mQuestRecord;
//ZMap<unsigned short, CSimpleStrMap, unsigned short> mQuestRecordEx;
//ZArray<Additional::SKILL> aSkill;
//int aMobCategoryDamage[9];
//int aElemBoost[8];
//Additional::CRITICAL critical;
//Additional::BOSS boss;
//ZMap<ZXString<char>, ZPair<long, long>, ZXString<char>> aUpgradeCountByDamageTheme;
//ZMap<long, long, long> m_mVisitorQuestLog;
public CharacterData()
{
Look = new AvatarLook();
Position = new MapPos();
Stats = new GW_CharacterStat();
aInvEquippedNormal = new CInventory <short, GW_ItemSlotEquip>();
aInvEquippedCash = new CInventory <short, GW_ItemSlotEquip>();
aInvEquip = new CInventory <short, GW_ItemSlotEquip>();
aInvEquippedExt = new CInventory <short, GW_ItemSlotEquip>();
aInvEquippedUnk = new CInventory <short, GW_ItemSlotEquip>();
aInvConsume = new CInventory <byte, GW_ItemSlotBundle>();
aInvInstall = new CInventory <byte, GW_ItemSlotBundle>();
aInvEtc = new CInventory <byte, GW_ItemSlotBundle>();
aInvCash = new CInventory <byte, GW_ItemSlotBundle>();
adwMapTransfer = new int[5];
adwMapTransferEx = new int[10];
}
private void AlertForItemShortage()
{
CReorderLevelBO oReorderLevelBO = new CReorderLevelBO();
CResult oResultReorderLevel = new CResult();
CReorderLevel oReorderLevel = new CReorderLevel();
String ItemName = null;
oResultReorderLevel = oReorderLevelBO.ReadAllReorderLevelData(oReorderLevel);
if (oResultReorderLevel.IsSuccess)
{
foreach (CReorderLevel obj in oResultReorderLevel.Data as ArrayList)
{
oReorderLevel.Quantity = obj.Quantity;
CInventoryBO oInventoryBO = new CInventoryBO();
CResult oResultInventory = new CResult();
CInventory oInventory = new CInventory();
oInventory.Invt_BranchOID = obj.Branch_ID;
oInventory.Invt_LocOID = obj.Location_ID;
oInventory.Invt_ItemOID = obj.Item_ID;
oResultInventory = oInventoryBO.ReadForROL(oInventory);
if (oResultInventory.IsSuccess)
{
foreach (CInventory oInv in oResultInventory.Data as ArrayList)
{
if (int.Parse(oInv.Invt_QTY.ToString()) < int.Parse(oReorderLevel.Quantity.ToString()))
{
ItemName = ItemName + oInv.Invt_ItemName.ToString() + "\n";
// MessageBox.Show("Item", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
//MessageBox.Show("Shortage Of Following Items "+ItemName+"", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (ItemName != null)
{
frmPopup ofrmPopUp = new frmPopup(PopupSkins.AlertSkin);
ofrmPopUp.ShowPopup("Item Shortage!!", "Shortage Of Following Items-" + ItemName + "", 500, 2000, 500);
}
}
}
protected override void Start()
{
m_unitTag = "Player";
gameObject.tag = m_unitTag;
CDataManager dataMgr = CDataManager.Inst;
if (dataMgr == null)
{
return;
}
Data.PlayerInfo playerInfo = dataMgr.PlayerRecord.PlayerInfo;
GameObject genderPrefab = null;
if (playerInfo.gender == Gender.Female)
{
genderPrefab = Resources.Load <GameObject>("Prefabs/Character/Player/Female");
}
else
{
genderPrefab = Resources.Load <GameObject>("Prefabs/Character/Player/Male");
}
if (genderPrefab == null)
{
return;
}
GameObject genderGO = Instantiate(genderPrefab, transform);
genderGO.name = genderPrefab.name;
base.Start();
m_inventory = GetComponent <CInventory>();
m_inventory.Initialized(this);
}
///גל
public List <CInventory> getinventirychecklist()
{
List <CInventory> ci = new List <CInventory>();
SqlConnection con = null;
try
{
con = Connect("DBConnectionString"); // create a connection to the database using the connection String defined in the web config file
String selectSTR = "SELECT GLN_Inventory.NumMaterial, GLN_Material.MaterialName, GLN_Inventory.ProductionID FROM GLN_Inventory INNER JOIN GLN_Material ON(GLN_Inventory.NumMaterial = GLN_Material.NumMaterial)";
SqlCommand cmd = new SqlCommand(selectSTR, con);
// get a reader
SqlDataReader dr = cmd.ExecuteReader();//(CommandBehavior.CloseConnection); // CommandBehavior.CloseConnection: the connection will be closed after reading has reached the end
while (dr.Read())
{
CInventory c = new CInventory();
c.MaterialId = (string)(dr["NumMaterial"]);
c.MaterialName = (string)(dr["MaterialName"]);
c.ProductionId = (string)(dr["ProductionID"]);
ci.Add(c);
}
dr.Close();
}
catch (Exception ex)
{
// write to log
throw (ex);
}
finally
{
if (con != null)
{
con.Close();
}
}
return(ci);
}
private float InventoryItemData(int i)
{
CResult oResult = new CResult();
CInventoryBO oInventoryBO = new CInventoryBO();
CInventory oInventory = new CInventory();
if (dgItemList.Rows[i].Cells["colItem"].Value != null)
{
oInventory.Invt_ItemOID = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colItem"]).Value.ToString();
}
if (dgItemList.Rows[i].Cells["colSrcBranch"].Value != null)
{
oInventory.Invt_BranchOID = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colSrcBranch"]).Value.ToString();
}
if (dgItemList.Rows[i].Cells["colSourceLoc"].Value != null)
{
oInventory.Invt_LocOID = ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colSourceLoc"]).Value.ToString();
}
if (dgItemList.Rows[i].Cells["colSrcInvType"].Value != null)
{
oInventory.Invt_InvType = Convert.ToInt32(Enum.Parse(typeof(EInvType), ((DataGridViewComboBoxCell)dgItemList.Rows[i].Cells["colSrcInvType"]).Value.ToString()));
}
oResult = oInventoryBO.ReadQtyByCond(oInventory);
if (oResult.IsSuccess)
{
return(((CInventory)oResult.Data).Invt_QTY);
}
else
{
MessageBox.Show("Loading error...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(0.00f);
}
public void OpenInventory(CInventory inventory)
{
//DrawItemSelectPanel(inventory);
// 처음 인벤토리를 열 때 아이템 정보 창 킬지 의논 필요
}
//public CResult ReadByBranchAndDate(string BranchCode, DateTime FromDate, DateTime ToDate)
//{
// List<CGRDetails> oItemList = new List<CGRDetails>();
// oResult = new CResult();
// conn = oConnManager.GetConnection(out s_DBError);
// if (conn != null)
// {
// try
// {
// DataSet ds = new DataSet();
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.CommandText = "sp_GRDetail_ReadByBrnIdAndDate";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Clear();
// cmd.Parameters.AddWithValue("@BranchID", BranchCode);
// cmd.Parameters.AddWithValue("@SOMstr_DateFrom", FromDate);
// cmd.Parameters.AddWithValue("@SOMstr_DateTo", ToDate);
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// da.Fill(ds);
// DataTable dtItem = ds.Tables[0];
// // oItemList.Add("");
// foreach (DataRow dr in dtItem.Rows)
// {
// CGRDetails oGRDetails = new CGRDetails();
// oGRDetails.GRDet_ItemOID = dr["GRDet_ItemOID"].ToString();
// oGRDetails.GRDet_QTY = float.Parse(dr["GRDet_QTY"].ToString());
// oGRDetails.GRDet_BranchOID = dr["GRDet_Branch"].ToString();
// oGRDetails.GRDet_Price = float.Parse(dr["GRDet_Price"].ToString());
// oGRDetails.GRDet_Amount = float.Parse(dr["GRDet_Amount"].ToString());
// oGRDetails.GRDet_ItemName = dr["GRDet_ItemName"].ToString();
// oItemList.Add(oGRDetails);
// }
// oResult.IsSuccess = true;
// oResult.Data = oItemList;
// }
// catch (SqlException e)
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = e.Message;
// }
// finally
// {
// oConnManager.Close();
// }
// }
// else
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = s_DBError;
// }
// return oResult;
//}
//public CResult ReduceByItemOID(List<CSODetails> oListSODetails)
//{
// oResult = new CResult();
// conn = oConnManager.GetConnection(out s_DBError);
// if (conn != null)
// {
// SqlCommand cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.Transaction = oConnManager.BeginTransaction();
// try
// {
// foreach (CSODetails oSODetails in oListSODetails)
// {
// cmd.CommandText = "sp_GRDetails_ReduceByItemOID";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Clear();
// cmd.Parameters.AddWithValue("@ItemOID", oSODetails.SODet_ItemOID);
// cmd.Parameters.AddWithValue("@ItemQTY", oSODetails.SODet_QTY);
// cmd.Parameters.AddWithValue("@BranchOID", oSODetails.SODet_BranchOID);
// cmd.ExecuteNonQuery();
// }
// oConnManager.Commit();
// oResult.IsSuccess = true;
// }
// catch (SqlException e)
// {
// string sRollbackError = oConnManager.Rollback();
// oResult.IsSuccess = false;
// oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
// }
// finally
// {
// oConnManager.Close();
// }
// }
// else
// {
// oResult.IsSuccess = false;
// oResult.ErrMsg = s_DBError;
// }
// return oResult;
//}
public CResult ExportAndUpdate(CGRMaster oMaster, string url)
{
CInventory oInventory = new CInventory();
CResult oResult = new CResult();
DataTable dt = new DataTable();
List <CInventory> oInvtList = new List <CInventory>();
List <CGRDetails> exportExcelList = new List <CGRDetails>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList)
{
oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.GRDet_Branch;
oInventory.Invt_BranchOID = oDetails.GRDet_BranchOID;
oInventory.Invt_InvType = oDetails.GRDet_InvType;
oInventory.Invt_ItemOID = oDetails.GRDet_ItemOID;
oInventory.Invt_LocOID = oDetails.GRDet_LocOID;
oInventory.Invt_QTY = oDetails.GRDet_QTY;
oInvtList.Add(oInventory);
exportExcelList.Add(oDetails);
}
CsvExport <CGRDetails> csv = new CsvExport <CGRDetails>(exportExcelList);
csv.Export();
csv.ExportToFile(url);
// InventoryDT = ConvertToDataTable<CGRDetails>(exportExcelList);
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtDec(oInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult ReduceByItemOID(List <CSODetails> oListSODetails)
{
List <CInventory> oInvtList = new List <CInventory>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
foreach (CSODetails oSODetails in oListSODetails)
{
StringBuilder sb = new StringBuilder();
sb.Append("DECLARE @GRDet_OID char(24); ");
sb.Append("DECLARE @GRDet_QTY float; ");
sb.Append("DECLARE @TempQTY float; ");
sb.Append("WHILE (@ItemQTY > 0) BEGIN ");
sb.Append("SELECT @GRDet_QTY = 0; ");
sb.Append("SELECT @TempQTY = 0; ");
sb.Append("SELECT TOP(1) @GRDet_OID = [GRDet_OID], @GRDet_QTY = [GRDet_QTY] ");
sb.Append("FROM t_GRDet ");
sb.Append("WHERE [GRDet_ItemOID] = @ItemOID AND [GRDet_BranchOID] = @BranchOID AND [GRDet_QTY] > 0 ");
sb.Append("IF (@GRDet_OID IS NOT NULL) BEGIN ");
sb.Append("IF(@ItemQTY > @GRDet_QTY) BEGIN ");
sb.Append("SELECT @TempQTY = 0; ");
sb.Append("SELECT @ItemQTY = @ItemQTY - @GRDet_QTY; ");
sb.Append("END ELSE BEGIN ");
sb.Append("SELECT @TempQTY = @GRDet_QTY - @ItemQTY; ");
sb.Append("SELECT @ItemQTY = 0; ");
sb.Append("END ");
sb.Append("UPDATE t_GRDet ");
sb.Append("SET ");
sb.Append("[GRDet_QTY] = @TempQTY ");
sb.Append("WHERE ");
sb.Append("[GRDet_OID] = @GRDet_OID; ");
sb.Append("END ");
sb.Append("SELECT @GRDet_OID = NULL; ");
sb.Append("END");
cmd.CommandType = CommandType.Text;
cmd.Parameters.Clear();
cmd.CommandText = sb.ToString();
cmd.Parameters.AddWithValue("@ItemOID", oSODetails.SODet_ItemOID);
cmd.Parameters.AddWithValue("@ItemQTY", oSODetails.SODet_QTY);
cmd.Parameters.AddWithValue("@BranchOID", oSODetails.SODet_BranchOID);
cmd.ExecuteNonQuery();
// populate inv list
CInventory oInventory = new CInventory();
oInventory.Invt_Branch = oSODetails.SODet_Branch;
oInventory.Invt_BranchOID = oSODetails.SODet_BranchOID;
oInventory.Invt_InvType = (int)EInvType.GOOD;
oInventory.Invt_ItemOID = oSODetails.SODet_ItemOID;
oInventory.Invt_LocOID = oSODetails.SODet_LocOID;
oInventory.Invt_QTY = oSODetails.SODet_QTY;
oInvtList.Add(oInventory);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtDec(oInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Update(CGRMaster oMaster, Dictionary <string, CGRDetails> oGRFinalQtyDic)
{
List <CInventory> oInvtList = new List <CInventory>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_GRMaster_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRMstr_OID", oMaster.GRMstr_OID);
cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch);
cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code);
cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date);
cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type);
cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By);
cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy);
cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID);
cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt);
cmd.Parameters.AddWithValue("@Creator", oMaster.Creator);
cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate);
cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy);
cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate);
cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0);
cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks);
cmd.ExecuteNonQuery();
cmd.CommandText = "Delete from t_GRDet where GRDet_MStrOID=@GRMstr_OID";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRMstr_OID", oMaster.GRMstr_OID);
cmd.ExecuteNonQuery();
foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList)
{
cmd.CommandText = "sp_GRDetails_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch);
cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID);
cmd.Parameters.AddWithValue("@GRDet_MStrOID", oMaster.GRMstr_OID);
cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID);
cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY);
cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM);
cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID);
cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID);
cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType);
cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price);
cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency);
cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount);
cmd.ExecuteNonQuery();
}
// update inventory
foreach (CGRDetails oGRDetails in oGRFinalQtyDic.Values)
{
// populate inv list
CInventory oInventory = new CInventory();
oInventory.Invt_Branch = oGRDetails.GRDet_Branch;
oInventory.Invt_BranchOID = oGRDetails.GRDet_BranchOID;
oInventory.Invt_InvType = oGRDetails.GRDet_InvType;
oInventory.Invt_ItemOID = oGRDetails.GRDet_ItemOID;
oInventory.Invt_LocOID = oGRDetails.GRDet_LocOID;
oInventory.Invt_QTY = oGRDetails.GRDet_QTY;
oInvtList.Add(oInventory);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtInc(oInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult Create(CGRMaster oMaster)
{
List <CInventory> oInvtList = new List <CInventory>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
//
cmd.CommandText = "sp_GRMaster_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@GRMstr_OID", SqlDbType.Char, 24);
cmd.Parameters["@GRMstr_OID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch);
cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code);
cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date);
cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type);
cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By);
cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy);
cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID);
cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt);
cmd.Parameters.AddWithValue("@Creator", oMaster.Creator);
cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate);
cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy);
cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate);
cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0);
cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks);
cmd.Parameters.AddWithValue("@IsImported", oMaster.GRMstr_IsImported);
cmd.ExecuteNonQuery();
string stGRMStr_OID = cmd.Parameters["@GRMstr_OID"].Value.ToString();
if (stGRMStr_OID.Trim() == "")
{
oResult.ErrMsg = "This delivered data is already exists.";
oResult.IsSuccess = false;
return(oResult);
}
foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList)
{
cmd.CommandText = "sp_GRDetails_Insert";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch);
cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID);
cmd.Parameters.AddWithValue("@GRDet_MStrOID", stGRMStr_OID);
cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID);
cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY);
cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM);
cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID);
cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID);
cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType);
cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price);
cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency);
cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount);
cmd.ExecuteNonQuery();
// populate inv list
CInventory oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.GRDet_Branch;
oInventory.Invt_BranchOID = oDetails.GRDet_BranchOID;
oInventory.Invt_InvType = oDetails.GRDet_InvType;
oInventory.Invt_ItemOID = oDetails.GRDet_ItemOID;
oInventory.Invt_LocOID = oDetails.GRDet_LocOID;
oInventory.Invt_QTY = oDetails.GRDet_QTY;
oInvtList.Add(oInventory);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtInc(oInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
protected override void Awake()
{
base.Awake();
Inventory = new CInventory(gameObject);
}
public CResult Create(CMTMaster oMTMaster)
{
List <CInventory> oSrcInvtList = new List <CInventory>();
List <CInventory> oDesInvtList = new List <CInventory>();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_MTMstr_Insert";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@MTMstr_OID", oMTMaster.MTMstr_OID);
SqlParameter sParam = new SqlParameter("@MTMstr_OID", SqlDbType.Char, 24);
sParam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(sParam).Value = "";
cmd.Parameters.AddWithValue("@MTMstr_Branch", oMTMaster.MTMstr_Branch);
cmd.Parameters.AddWithValue("@MTMstr_Code", oMTMaster.MTMstr_Code);
cmd.Parameters.AddWithValue("@MTMstr_Date", oMTMaster.MTMstr_Date);
cmd.Parameters.AddWithValue("@MTMstr_DOrder", oMTMaster.MTMstr_DOrder);
cmd.Parameters.AddWithValue("@MTMstr_Creator", oMTMaster.Creator);
cmd.Parameters.AddWithValue("@MTMstr_CreationDate", oMTMaster.CreationDate);
cmd.Parameters.AddWithValue("@MTMstr_UpdatedBy", oMTMaster.UpdateBy);
cmd.Parameters.AddWithValue("@MTMstr_UpdateDate", oMTMaster.UpdateDate);
cmd.Parameters.AddWithValue("@MTMstr_IsActive", (oMTMaster.IsActive == "Y")?1:0);
cmd.Parameters.AddWithValue("@MTMstr_Remarks", oMTMaster.Remarks);
cmd.ExecuteNonQuery();
string stMTMstr_OID = cmd.Parameters["@MTMstr_OID"].Value.ToString();
foreach (CMTDetails oDetails in oMTMaster.MTMstr_DetailsList)
{
cmd.CommandText = "sp_MTDtls_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@MTDtls_Branch", oDetails.MTDtls_Branch);
cmd.Parameters.AddWithValue("@MTDtls_OID", oDetails.MTDtls_OID);
cmd.Parameters.AddWithValue("@MTDtls_MstrOID", stMTMstr_OID);
cmd.Parameters.AddWithValue("@MTDtls_ItemOID", oDetails.MTDtls_ItemOID);
cmd.Parameters.AddWithValue("@MTDtls_IssQty", oDetails.MTDtls_IssQty);
cmd.Parameters.AddWithValue("@MTDtls_IssUOMOID", oDetails.MTDtls_IssUOMOID);
cmd.Parameters.AddWithValue("@MTDtls_SBranOID", oDetails.MTDtls_SBranOID);
cmd.Parameters.AddWithValue("@MTDtls_SrcLocOID", oDetails.MTDtls_SrcLocOID);
cmd.Parameters.AddWithValue("@MTDtls_SrcInvTyp", oDetails.MTDtls_SrcInvTyp);
cmd.Parameters.AddWithValue("@MTDtls_DBranOID", oDetails.MTDtls_DBranOID);
cmd.Parameters.AddWithValue("@MTDtls_DestLocOID", oDetails.MTDtls_DestLocOID);
cmd.Parameters.AddWithValue("@MTDtls_DesInvtyp", oDetails.MTDtls_DesInvtyp);
cmd.Parameters.AddWithValue("@MTDtls_RQty", oDetails.MTDtls_RQty);
cmd.Parameters.AddWithValue("@MTDtls_RUOMOID", oDetails.MTDtls_RUOMOID);
cmd.Parameters.AddWithValue("@MTDtls_Status", oDetails.MTDtls_Status);
cmd.ExecuteNonQuery();
// populate inv list(decrease)
CInventory oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.MTDtls_Branch;
oInventory.Invt_BranchOID = oDetails.MTDtls_SBranOID;
oInventory.Invt_InvType = oDetails.MTDtls_SrcInvTyp;
oInventory.Invt_ItemOID = oDetails.MTDtls_ItemOID;
oInventory.Invt_LocOID = oDetails.MTDtls_SrcLocOID;
oInventory.Invt_QTY = oDetails.MTDtls_IssQty;
oSrcInvtList.Add(oInventory);
// populate inv list(increase)
oInventory = new CInventory();
oInventory.Invt_Branch = oDetails.MTDtls_Branch;
oInventory.Invt_BranchOID = oDetails.MTDtls_DBranOID;
oInventory.Invt_InvType = oDetails.MTDtls_DesInvtyp;
oInventory.Invt_ItemOID = oDetails.MTDtls_ItemOID;
oInventory.Invt_LocOID = oDetails.MTDtls_DestLocOID;
oInventory.Invt_QTY = oDetails.MTDtls_IssQty;
oDesInvtList.Add(oInventory);
}
//Update inv
CInventoryBO oInventoryBO = new CInventoryBO();
oResult = oInventoryBO.InvtDecInc(oSrcInvtList, oDesInvtList);
if (oResult.IsSuccess)
{
oConnManager.Commit();
oResult.IsSuccess = true;
}
else
{
oResult.ErrMsg = oConnManager.Rollback();
oResult.IsSuccess = false;
}
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
private void Awake()
{
DontDestroyOnLoad(gameObject);
Inventory = new CInventory();
}
protected void Page_Load(object sender, EventArgs e)
{
Id = Convert.ToInt32(Request["id"]);
if (!IsPostBack)
{
FileDownloadList1.InitFileDownloadList((int)CConstValue.Upload.Inventory);
var buttonList = new List <string>();
// new
if (Request["createOrListType"] == "0")
{
buttonList.Add("Save");
buttonList.Add("Close");
}
// select
else
{
buttonList.Add("Save");
buttonList.Add("Print");
buttonList.Add("Close");
}
foreach (RadToolBarItem item in RadToolBar1.Items)
{
if (buttonList.Contains(item.Text))
{
item.Visible = true;
}
else
{
item.Visible = false;
}
}
LoadInventoryCategory();
if (!string.IsNullOrEmpty(RadComboBoxInventoryCategory.SelectedValue))
{
LoadInventoryCategoryItem(Convert.ToInt32(RadComboBoxInventoryCategory.SelectedValue));
}
LoadSite();
LoadSiteLocation(CurrentSiteId);
LoadAssignedUser(CurrentSiteLocationId);
LoadInUse();
LoadCondition();
var inventory = new CInventory().Get(Id);
if (inventory != null)
{
var inventoryCategoryItem = new CInventoryCategoryItem().Get(inventory.InventoryCategoryItemId);
RadComboBoxInventoryCategory.SelectedValue = inventoryCategoryItem.InventoryCategoryId.ToString();
RadComboBoxInventoryCategoryItem.SelectedValue = inventory.InventoryCategoryItemId.ToString();
var siteLocation = new CSiteLocation().Get(inventory.SiteLocationId);
RadComboBoxSite.SelectedValue = siteLocation.SiteId.ToString();
RadComboBoxSiteLocation.SelectedValue = inventory.SiteLocationId.ToString();
RadComboBoxAssignedUser.SelectedValue = inventory.AssignedUserId.ToString();
RadComboBoxInUse.SelectedValue = inventory.InUseType.ToString();
RadComboBoxCondition.SelectedValue = inventory.ConditionType.ToString();
RadTextBoxCompany.Text = inventory.Company;
RadNumericTextBoxPrice.Value = (double)inventory.Price;
RadDatePickerPurchased.SelectedDate = inventory.PurchasedDate?.Date;
RadDatePickerExpire.SelectedDate = inventory.ExpireDate?.Date;
RadTextBoxDepartment.Text = inventory.Company;
RadTextBoxModelNo.Text = inventory.ModelNo;
RadTextBoxSerialNo.Text = inventory.SerialNo;
FileDownloadList1.GetFileDownload(Convert.ToInt32(Id));
}
}
}
public CResult ReadForROL(CInventory oInventory)
{
ArrayList oInventoryList = new ArrayList();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_Invt_ReadForROL";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
oInventoryList.Add(GetresultoInventory(dr));
}
//SqlDataReader oReader = cmd.ExecuteReader();
//if (oReader.HasRows)
//{
// while (oReader.Read())
// {
// oInventory.Invt_QTY = float.Parse(oReader["Invt_QTY"].ToString());
// }
// oReader.Close();
//}
oResult.IsSuccess = true;
oResult.Data = oInventoryList;
}
catch (SqlException e)
{
oResult.IsSuccess = false;
oResult.ErrMsg = e.Message;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public void Register(CInventory inventory)
{
inventory.changeConsumableEvent.AddListener(SetView);
}
public void Deregister(CInventory inventory)
{
inventory.changeConsumableEvent.RemoveListener(SetView);
}
