/// <summary> /// LogicDeleteInfo /// </summary> /// <param name="id">int</param> /// <param name="loginUser">string</param> /// <returns>bool</returns> public bool LogicDeleteInfo(long id, string loginUser) { ///校验对应是否已经维护了车间TM_BAS_WORKSHOP,已逻辑删除的车间不在校验范围内 int workshopCnt = new WorkshopDAL().GetCounts("[PLANT] in (select [PLANT] from [LES].[TM_BAS_PLANT] with(nolock) where [ID] = " + id + " and [VALID_FLAG] = 1)"); if (workshopCnt > 0) { throw new Exception("MC:0x00000095");///该工厂下还有车间,无法删除 } return(dal.LogicDelete(id, loginUser) > 0 ? true : false); }
protected void btnCreateWorkshop_Click(object sender, EventArgs e) { int RequestedByid = 0; int itemid = 0; String SessionDate = String.Empty; int WorkshopStatusid = 0; RequestedByid = Convert.ToInt32(ddlRequesters.SelectedValue.ToString()); itemid = Convert.ToInt32(ddlCRPRTDR.SelectedValue.ToString()); WorkshopStatusid = Convert.ToInt32(ddlWorkshopStatuses.SelectedValue.ToString()); SessionDate = txtSessionDate.Text; ErrorMessage = WorkshopDAL.WorkshopInsert(RequestedByid, itemid, SessionDate, WorkshopStatusid); LoadWorkshops(); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { lblWorkshopID.Text = GridView1.SelectedDataKey.Value.ToString(); Workshop w = WorkshopDAL.GetWorkshopByID(Convert.ToInt32(lblWorkshopID.Text)); txtSessionDate.Text = w.SdtDate.ToString(); //Reset selected items ddlRequesters.Items.FindByValue(ddlRequesters.SelectedItem.Value).Selected = false; ddlWorkshopStatuses.Items.FindByValue(ddlWorkshopStatuses.SelectedItem.Value).Selected = false; ddlCRPRTDR.Items.FindByValue(ddlCRPRTDR.SelectedItem.Value).Selected = false; ddlRequesters.Items.FindByValue(w.IRequesterID.ToString()).Selected = true; ddlWorkshopStatuses.Items.FindByValue(w.SiWorkshopStatusID.ToString()).Selected = true; ddlCRPRTDR.Items.FindByValue(w.IITemID.ToString()).Selected = true; btnCreateWorkshop.Enabled = false; }
private void LoadWorkshopStatuses() { WorkshopStatuses = WorkshopDAL.GetWorkshopStatusList(); ddlWorkshopStatuses.DataSource = WorkshopStatuses; ddlWorkshopStatuses.DataBind(); }
private void LoadWorkshops() { GridView1.DataSource = WorkshopDAL.GetWorkshops(); GridView1.DataBind(); }