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_OutboundRecordEntity et = new T_OutboundRecordEntity(); et.DataTable_Action_ = DataTable_Action.Delete; et.ID = IDX; BusinessFacadeShanlitech_Location.T_OutboundRecordInsertUpdateDelete(et); } } EventMessage.MessageBox(1, "批量删除成功", string.Format("批量删除({0})成功!", Checkbox_Value), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx")); }
/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_OutboundRecordEntity ut) { StockID_Hidden.Value = ut.CodeNO.ToString(); if (!string.IsNullOrEmpty(ut.CodeNO)) { StockName_Disp.Text = "器材名称:" + ut.EquipmentName + "; 型号:" + ut.Model + ";库存编码:" + BusinessFacadeShanlitech_Location.GetCodeByStockid(ut.CodeNO); } EquipmentName_Hidden.Value = ut.EquipmentName; Model_Hidden.Value = ut.Model; CodeNO_Hidden.Value = ut.CodeNO; //项目类别 if (!string.IsNullOrEmpty(ut.ProjectNO)) { ListItem projectitem = ProjectNO_Input.Items.FindByValue(ut.ProjectNO.ToString()); ProjectNO_Input.ClearSelection(); if (projectitem != null) projectitem.Selected = true; ProjectNO_Disp.Text = BusinessFacadeShanlitech_Location.GetProjectNameByID(Convert.ToInt32(ut.ProjectNO.ToString())); } //EquipmentName_Input.Text = EquipmentName_Disp.Text = ut.EquipmentName.ToString(); //Model_Input.Text = Model_Disp.Text = ut.Model.ToString(); OutboundNumber_Input.Text = OutboundNumber_Disp.Text = ut.OutboundNumber.ToString(); BalanceNumber_Input.Text = BalanceNumber_Disp.Text = ut.BalanceNumber.ToString(); OutboundTime_Disp.Text = ut.OutboundTime.ToString(); if (string.IsNullOrEmpty(ut.OutboundTime.ToString())) { OutboundTime_Disp.Text = DateTime.Now.ToString(); } //申请人 ListItem Applicantitem = Applicant_Input.Items.FindByValue(ut.Applicant.ToString()); Applicant_Input.ClearSelection(); if (Applicantitem != null) Applicantitem.Selected = true; Applicant_Disp.Text = BusinessFacadeShanlitech_Location.GetUserNameByID(Convert.ToInt32(ut.Applicant.ToString())); //批准人 //ListItem Approveritem = Approver_Input.Items.FindByValue(ut.Approver.ToString()); //Approver_Input.ClearSelection(); //if (Approveritem != null) // Approveritem.Selected = true; Approver_Disp.Text = BusinessFacadeShanlitech_Location.GetUserNameByID(ut.Approver); Remark_Input.Text = Remark_Disp.Text = ut.Remark.ToString(); CodeNO_Input.Text = CodeNO_Disp.Text = ut.CodeNO.ToString(); }
/// <summary> /// 根据ID返回 T_OutboundRecordEntity实体类 单笔资料 (出库表单) /// </summary> /// <param name="ID">ID ID</param> /// <returns>返回 T_OutboundRecordEntity实体类 ID为0则无记录</returns> public static T_OutboundRecordEntity T_OutboundRecordDisp(Int32 ID) { T_OutboundRecordEntity fam = new T_OutboundRecordEntity(); QueryParam qp = new QueryParam(); qp.PageIndex = 1; qp.PageSize = 1; qp.Where = string.Format(" Where {0}.{1} = {2}", "T_OutboundRecord", "ID", ID); int RecordCount = 0; List<T_OutboundRecordEntity> lst = T_OutboundRecordList(qp, out RecordCount); if (RecordCount > 0) { fam = lst[0]; } return fam; }
/// <summary> /// 新增/删除/修改 T_OutboundRecordEntity (出库表单) /// </summary> /// <param name="fam">T_OutboundRecordEntity实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public static Int32 T_OutboundRecordInsertUpdateDelete(T_OutboundRecordEntity fam) { return DataProvider.Instance().T_OutboundRecordInsertUpdateDelete(fam); }
/// <summary> /// 将记录集转为T_OutboundRecordEntity实体类 (出库表单) /// </summary> /// <param name="dr">记录集</param> /// <param name="Fileds">字段名列表</param> /// <returns>T_OutboundRecordEntity</returns> protected T_OutboundRecordEntity PopulateT_OutboundRecordEntity(IDataReader dr, Dictionary<string, string> Fileds) { T_OutboundRecordEntity nc = new T_OutboundRecordEntity(); if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // ID if (Fileds.ContainsKey("ProjectNO") && !Convert.IsDBNull(dr["ProjectNO"])) nc.ProjectNO = Convert.ToString(dr["ProjectNO"]).Trim(); // 项目名称 if (Fileds.ContainsKey("EquipmentName") && !Convert.IsDBNull(dr["EquipmentName"])) nc.EquipmentName = Convert.ToString(dr["EquipmentName"]).Trim(); // 器材名称 if (Fileds.ContainsKey("Model") && !Convert.IsDBNull(dr["Model"])) nc.Model = Convert.ToString(dr["Model"]).Trim(); // 型号 if (Fileds.ContainsKey("OutboundNumber") && !Convert.IsDBNull(dr["OutboundNumber"])) nc.OutboundNumber = Convert.ToInt32(dr["OutboundNumber"]); // 数量 if (Fileds.ContainsKey("BalanceNumber") && !Convert.IsDBNull(dr["BalanceNumber"])) nc.BalanceNumber = Convert.ToInt32(dr["BalanceNumber"]); // 结余 if (Fileds.ContainsKey("OutboundTime") && !Convert.IsDBNull(dr["OutboundTime"])) nc.OutboundTime = Convert.ToDateTime(dr["OutboundTime"]); // 领取时间 if (Fileds.ContainsKey("Applicant") && !Convert.IsDBNull(dr["Applicant"])) nc.Applicant = Convert.ToInt32(dr["Applicant"]); // 申请人 if (Fileds.ContainsKey("Approver") && !Convert.IsDBNull(dr["Approver"])) nc.Approver = Convert.ToInt32(dr["Approver"]); // 批准人 if (Fileds.ContainsKey("IntegrityCheckCode") && !Convert.IsDBNull(dr["IntegrityCheckCode"])) nc.IntegrityCheckCode = Convert.ToString(dr["IntegrityCheckCode"]).Trim(); // 信息完整性校验码 if (Fileds.ContainsKey("Remark") && !Convert.IsDBNull(dr["Remark"])) nc.Remark = Convert.ToString(dr["Remark"]).Trim(); // Remark if (Fileds.ContainsKey("CodeNO") && !Convert.IsDBNull(dr["CodeNO"])) nc.CodeNO = Convert.ToString(dr["CodeNO"]).Trim(); // 库存资产编码号 return nc; }
/// <summary> /// 新增/删除/修改 T_OutboundRecordEntity (出库表单) /// </summary> /// <param name="fam">T_OutboundRecord实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public abstract Int32 T_OutboundRecordInsertUpdateDelete(T_OutboundRecordEntity fam);
/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_OutboundRecordEntity ut) { ProjectNO_Input.Text = ProjectNO_Disp.Text = ut.ProjectNO.ToString(); EquipmentName_Input.Text = EquipmentName_Disp.Text = ut.EquipmentName.ToString(); Model_Input.Text = Model_Disp.Text = ut.Model.ToString(); OutboundNumber_Input.Text = OutboundNumber_Disp.Text = ut.OutboundNumber.ToString(); BalanceNumber_Input.Text = BalanceNumber_Disp.Text = ut.BalanceNumber.ToString(); OutboundTime_Input.Text = OutboundTime_Disp.Text = ut.OutboundTime.ToString(); Applicant_Input.Text = Applicant_Disp.Text = ut.Applicant.ToString(); Approver_Input.Text = Approver_Disp.Text = ut.Approver.ToString(); IntegrityCheckCode_Input.Text = IntegrityCheckCode_Disp.Text = ut.IntegrityCheckCode.ToString(); Remark_Input.Text = Remark_Disp.Text = ut.Remark.ToString(); CodeNO_Input.Text = CodeNO_Disp.Text = ut.CodeNO.ToString(); }