/// <summary>
/// 申报路径申请新增
/// </summary>
/// <param name="DeclareSeriesID"></param>
/// <param name="DeclareGradeID"></param>
/// <param name="CommittedStateID"></param>
/// <param name="ControlUnit"></param>
/// <returns></returns>
public ActionResult InsertDeclarePath(int DeclareSeriesID, int DeclareGradeID, int CommittedStateID, string ControlUnit)
{
string strMsg = "fail";
try
{
int oldDeclarePath = (from tbDeclarePath in myModels.B_DeclarePath
where
tbDeclarePath.DeclareSeriesID == DeclareSeriesID &&
tbDeclarePath.DeclareGradeID == DeclareGradeID &&
tbDeclarePath.CommittedStateID == CommittedStateID &&
tbDeclarePath.ControlUnit == ControlUnit
select tbDeclarePath).Count();
if (oldDeclarePath == 0)
{
B_DeclarePath myDeclarePath = new B_DeclarePath();
myDeclarePath.DeclareSeriesID = DeclareSeriesID;
myDeclarePath.DeclareGradeID = DeclareGradeID;
myDeclarePath.CommittedStateID = CommittedStateID;
myDeclarePath.ControlUnit = ControlUnit;
myModels.B_DeclarePath.Add(myDeclarePath);
if (myModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 申报申请路径删除
/// </summary>
/// <returns></returns>
public ActionResult DeleteDeclarePath(int DeclarePathID)
{
string strMsg = "fail";
try
{
B_DeclarePath dbDeclarePath = (from tbDeclarePath in myModels.B_DeclarePath
where tbDeclarePath.DeclarePathID == DeclarePathID
select tbDeclarePath).Single();
myModels.B_DeclarePath.Remove(dbDeclarePath);
myModels.SaveChanges();
strMsg = "success";
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 申报路径申请修改
/// </summary>
/// <param name="BDeclarePath"></param>
/// <returns></returns>
public ActionResult UpdataDeclarePath(B_DeclarePath BDeclarePath)
{
string strMsg = "fali";
var pdDeclarePath = (from tbDeclarePath in myModels.B_DeclarePath
where
tbDeclarePath.DeclarePathID == BDeclarePath.DeclarePathID
select tbDeclarePath).Single();
if (pdDeclarePath != null)
{
pdDeclarePath.DeclareSeriesID = BDeclarePath.DeclareSeriesID;
pdDeclarePath.DeclareGradeID = BDeclarePath.DeclareGradeID;
pdDeclarePath.ControlUnit = BDeclarePath.ControlUnit;
pdDeclarePath.CommittedStateID = BDeclarePath.CommittedStateID;
myModels.Entry(pdDeclarePath).State = System.Data.Entity.EntityState.Modified;
if (myModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
