/// <summary>
 /// 根据ID返回 T_StockLogEntity实体类 单笔资料 (出入库日志)
 /// </summary>
 /// <param name="ID">ID 自增ID</param>
 /// <returns>返回 T_StockLogEntity实体类 ID为0则无记录</returns>
 public static T_StockLogEntity T_StockLogDisp(Int32 ID)
 {
     T_StockLogEntity fam = new T_StockLogEntity();
     QueryParam qp = new QueryParam();
     qp.PageIndex = 1;
     qp.PageSize = 1;
     qp.Where = string.Format(" Where {0}.{1} = {2}", "T_StockLog", "ID", ID);
     int RecordCount = 0;
     List<T_StockLogEntity> lst = T_StockLogList(qp, out RecordCount);
     if (RecordCount > 0)
     {
         fam = lst[0];
     }
     return fam;
 }
예제 #2
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            string Checkbox_Value = (string)Common.sink("Checkbox", MethodType.Post, 2000, 1, DataType.Str);
            string[] Checkbox_Value_Array = Checkbox_Value.Split(',');
            Int32 IDX = 0;
            for (int i = 0; i < Checkbox_Value_Array.Length; i++)
            {
                if (Int32.TryParse(Checkbox_Value_Array[i], out IDX))
                {
                    T_StockLogEntity et = new T_StockLogEntity();
                    et.DataTable_Action_ = DataTable_Action.Delete;
                    et.ID = IDX;
                    BusinessFacadeShanlitech_Location.T_StockLogInsertUpdateDelete(et);
                }
            }

            EventMessage.MessageBox(1, "批量删除成功", string.Format("批量删除({0})成功!", Checkbox_Value), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
        }
예제 #3
0
 /// <summary>
 /// 初始化数据
 /// </summary>
 /// <param name="ut"></param>
 private void OnStartData(T_StockLogEntity ut)
 {
 CodeNO_Input.Text = CodeNO_Disp.Text = ut.CodeNO.ToString();
         DealType_Input.Text = DealType_Disp.Text = ut.DealType.ToString();
         Number_Input.Text = Number_Disp.Text = ut.Number.ToString();
         Handler_Input.Text = Handler_Disp.Text = ut.Handler.ToString();
         StorID_Input.Text = StorID_Disp.Text = ut.StorID.ToString();
         OutbID_Input.Text = OutbID_Disp.Text = ut.OutbID.ToString();
         LogTime_Input.Text = LogTime_Disp.Text = ut.LogTime.ToString();
         
 }
 /// <summary>
 /// 新增/删除/修改 T_StockLogEntity (出入库日志)
 /// </summary>
 /// <param name="fam">T_StockLogEntity实体类</param>
 /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
 public static Int32 T_StockLogInsertUpdateDelete(T_StockLogEntity fam)
 {
     return DataProvider.Instance().T_StockLogInsertUpdateDelete(fam);
 }
예제 #5
0
        /// <summary>
        /// 增加/修改事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button1_Click(object sender, EventArgs e)
        {
            int Approver_Value = UserData.GetUserDate.UserID;
            T_OutboundRecordEntity ut = BusinessFacadeShanlitech_Location.T_OutboundRecordDisp(IDX);
            
         
            ut.Approver = Approver_Value;
        
            ut.DataTable_Action_ = DataTable_Action.Update;
           
            Int32 rInt = BusinessFacadeShanlitech_Location.T_OutboundRecordInsertUpdateDelete(ut);
            if ( rInt> 0)
            {
                #region 插入出库日志
               
                    QueryParam qp = new QueryParam();
                    qp.Orderfld = "ID";
                    qp.OrderType = 1;
                    int srecord = 0;
                    List<T_OutboundRecordEntity> sentity = BusinessFacadeShanlitech_Location.T_OutboundRecordList(qp, out srecord);

                    T_StockLogEntity logentity = new T_StockLogEntity();
                    logentity.DataTable_Action_ = DataTable_Action.Insert;
                    logentity.CodeNO = ut.CodeNO;
                    logentity.DealType = (int)DealType.SLCK;
                    logentity.Handler = UserData.GetUserDate.UserID;
                    logentity.LogTime = (DateTime?)DateTime.Now;
                    logentity.Number = ut.OutboundNumber;
                    logentity.StorID = sentity[0].ID;
                    BusinessFacadeShanlitech_Location.T_StockLogInsertUpdateDelete(logentity);
             
                #endregion

                    #region 更新库存
                    qp = new QueryParam();
                    qp.Where = string.Format("where id={0}", Convert.ToInt32(sentity[0].CodeNO));
                    srecord = 0;
                    List<T_StockEntity> stocklist = BusinessFacadeShanlitech_Location.T_StockList(qp, out srecord);
                    stocklist[0].DataTable_Action_ = DataTable_Action.Update;
                    stocklist[0].StockNumber -= sentity[0].OutboundNumber;
                    BusinessFacadeShanlitech_Location.T_StockInsertUpdateDelete(stocklist[0]);


                    #endregion

                    string OpTxt = string.Format("增加出库批准单成功!(ID:{0})", rInt);
                if (ut.DataTable_Action_ == DataTable_Action.Update)
                    OpTxt = string.Format("修改出库批准单成功!(ID:{0})",IDX);
                EventMessage.MessageBox(1, "操作成功", OpTxt, Icon_Type.OK, Common.GetHomeBaseUrl("Default.aspx"));
            }
            else if (rInt == -2)
            {
                EventMessage.MessageBox(1, "操作失败", "操作失败,存在相同的键值(用户名/数据)!", Icon_Type.Alert, Common.GetHomeBaseUrl("Default.aspx"));
            }
            else
            {
                EventMessage.MessageBox(1, "操作失败", string.Format("操作失败,返回值:{0}!", rInt), Icon_Type.Error, Common.GetHomeBaseUrl("Default.aspx"));
            }
        }
예제 #6
0
        /// <summary>
        /// 将记录集转为T_StockLogEntity实体类 (出入库日志)
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <param name="Fileds">字段名列表</param>
        /// <returns>T_StockLogEntity</returns>
        protected T_StockLogEntity PopulateT_StockLogEntity(IDataReader dr, Dictionary<string, string> Fileds)
        {
            T_StockLogEntity nc = new T_StockLogEntity();

            if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // 自增ID
            if (Fileds.ContainsKey("CodeNO") && !Convert.IsDBNull(dr["CodeNO"])) nc.CodeNO = Convert.ToString(dr["CodeNO"]).Trim(); // 库存资产编码号
            if (Fileds.ContainsKey("DealType") && !Convert.IsDBNull(dr["DealType"])) nc.DealType = Convert.ToInt32(dr["DealType"]); // 处理类型(0为平衡入库,1为核销入库,2为受赠入库,10为平衡出库,11为申领出库,12为折旧出库)
            if (Fileds.ContainsKey("Number") && !Convert.IsDBNull(dr["Number"])) nc.Number = Convert.ToInt32(dr["Number"]); // 数量
            if (Fileds.ContainsKey("Handler") && !Convert.IsDBNull(dr["Handler"])) nc.Handler = Convert.ToInt32(dr["Handler"]); // 操作者
            if (Fileds.ContainsKey("StorID") && !Convert.IsDBNull(dr["StorID"])) nc.StorID = Convert.ToInt32(dr["StorID"]); // 入库单ID
            if (Fileds.ContainsKey("OutbID") && !Convert.IsDBNull(dr["OutbID"])) nc.OutbID = Convert.ToInt32(dr["OutbID"]); // 出库单ID
            if (Fileds.ContainsKey("LogTime") && !Convert.IsDBNull(dr["LogTime"])) nc.LogTime = Convert.ToDateTime(dr["LogTime"]); // 记录时间
            return nc;
        }
예제 #7
0
 /// <summary>
 /// 新增/删除/修改 T_StockLogEntity (出入库日志)
 /// </summary>
 /// <param name="fam">T_StockLog实体类</param>
 /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
 public abstract Int32 T_StockLogInsertUpdateDelete(T_StockLogEntity fam);
예제 #8
0
 /// <summary>
 /// 初始化数据
 /// </summary>
 /// <param name="ut"></param>
 private void OnStartData(T_StockLogEntity ut)
 {
 CodeNO_Input.Text = CodeNO_Disp.Text = ut.CodeNO.ToString();
 DealType_Input.Text = DealType_Disp.Text = Innit(ut.DealType);
         Number_Input.Text = Number_Disp.Text = ut.Number.ToString();
         Handler_Input.Text = Handler_Disp.Text = BusinessFacade.sys_UserDisp(ut.Handler).U_LoginName;
         StorID_Input.Text = StorID_Disp.Text = ut.StorID.ToString();
         OutbID_Input.Text = OutbID_Disp.Text = ut.OutbID.ToString();
         LogTime_Input.Text = LogTime_Disp.Text = ut.LogTime.ToString();
         
 }
예제 #9
0
        /// <summary>
        /// 增加/修改事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button1_Click(object sender, EventArgs e)
        {

            //int VeriID_Value = Convert.ToInt32(VeriID_Hidden.Value);
            //int VeritypeID_Value = Convert.ToInt32(BusinessFacadeShanlitech_Location.T_VerificationRecordDisp(VeriID_Value).ProjID);
            //string EquipmentName_Value = (string)Common.sink(EquipmentName_Input.UniqueID, MethodType.Post, 50, 0, DataType.Str);
            //string Model_Value = (string)Common.sink(Model_Input.UniqueID, MethodType.Post, 50, 0, DataType.Str);
            //int StorageNumber_Value = (int)Common.sink(StorageNumber_Input.UniqueID, MethodType.Post, 10, 0, DataType.Int);
            //double UnitPrice_Value = (double)Common.sink(UnitPrice_Input.UniqueID, MethodType.Post, 53, 0, DataType.Double);

            //DateTime? StorageTime_Value = (DateTime?)DateTime.Now;
            //int Applicant_Value = Convert.ToInt32(Applicant_Hidden.Value);
            int Approver_Value = UserData.GetUserDate.UserID;
            //double PayAmount_Value = (double)Convert.ToInt32(PayAmount_Hidden.Value);
            //string Remark_Value = (string)Common.sink(Remark_Input.UniqueID, MethodType.Post, 50, 0, DataType.Str);
            //string CodeNO_Value = (string)Common.sink(CodeNO_Input.UniqueID, MethodType.Post, 50, 0, DataType.Str);
            T_StorageRecordEntity ut = BusinessFacadeShanlitech_Location.T_StorageRecordDisp(IDX);
            
            //ut.VeriID = VeriID_Value;
            //ut.ProjectNO = VeritypeID_Value.ToString();
            //ut.EquipmentName = EquipmentName_Value;
            //ut.Model = Model_Value;
            //ut.StorageNumber = StorageNumber_Value;
            //ut.UnitPrice = UnitPrice_Value;
            //ut.StorageTime = StorageTime_Value;
            //ut.Applicant = Applicant_Value;
            ut.Approver = Approver_Value;
            //ut.PayAmount = PayAmount_Value;
            //ut.Remark = Remark_Value;
            //ut.CodeNO = CodeNO_Value;
            
            //if (CMD == "New")
            //{
            //    ut.DataTable_Action_ = DataTable_Action.Insert;
            //}
            //else if (CMD == "Edit")
            //{
                ut.DataTable_Action_ = DataTable_Action.Update;
            //}
            //else
            //{
            //    EventMessage.MessageBox(2, "不存在操作字符串!", "不存在操作字符串!", Icon_Type.Error, Common.GetHomeBaseUrl("Default.aspx"));
            //}
         
            Int32 rInt = BusinessFacadeShanlitech_Location.T_StorageRecordInsertUpdateDelete(ut);

            if ( rInt> 0)
            {
                #region 插入入库日志

                    QueryParam qp=new QueryParam();
                    qp.Orderfld="ID";
                    qp.OrderType=1;
                    int srecord=0;
                   List<T_StorageRecordEntity> sentity = BusinessFacadeShanlitech_Location.T_StorageRecordList(qp, out srecord);

                    T_StockLogEntity logentity = new T_StockLogEntity();
                    logentity.DataTable_Action_ = DataTable_Action.Insert;
                    logentity.CodeNO = ut.CodeNO;
                    logentity.DealType =(int)DealType.PHRK;
                    logentity.Handler = UserData.GetUserDate.UserID;
                    logentity.LogTime = (DateTime?)DateTime.Now;
                    logentity.Number = ut.StorageNumber;
                    logentity.StorID = sentity[0].ID;
                    BusinessFacadeShanlitech_Location.T_StockLogInsertUpdateDelete(logentity);
                #endregion
                #region 更新库存
                    qp = new QueryParam();
                    qp.Where = string.Format("where id={0}",Convert.ToInt32(sentity[0].CodeNO));
                    srecord = 0;
                    List<T_StockEntity> stocklist = BusinessFacadeShanlitech_Location.T_StockList(qp, out srecord);
                    stocklist[0].DataTable_Action_ = DataTable_Action.Update;
                    stocklist[0].StockNumber += sentity[0].StorageNumber;
                    BusinessFacadeShanlitech_Location.T_StockInsertUpdateDelete(stocklist[0]);

                #endregion
                string OpTxt = string.Format("增加待批准入库单成功!(ID:{0})", rInt);
                if (ut.DataTable_Action_ == DataTable_Action.Update)
                    OpTxt = string.Format("修改待批准入库单成功!(ID:{0})",IDX);
                EventMessage.MessageBox(1, "操作成功", OpTxt, Icon_Type.OK, Common.GetHomeBaseUrl("Default.aspx"));
            }
            else if (rInt == -2)
            {
                EventMessage.MessageBox(1, "操作失败", "操作失败,存在相同的键值(用户名/数据)!", Icon_Type.Alert, Common.GetHomeBaseUrl("Default.aspx"));
            }
            else
            {
                EventMessage.MessageBox(1, "操作失败", string.Format("操作失败,返回值:{0}!", rInt), Icon_Type.Error, Common.GetHomeBaseUrl("Default.aspx"));
            }
        }