/// <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();
}
