private void InsertProject(DataTable dtProject)
{
foreach (DataRow row in dtProject.Rows)
{
string strId = row["Index"].ToString();
string strName = row["Name"].ToString();
string strManager = row["ManagerName"].ToString();
string strManagerTel = row["ManagerTel"].ToString();
string strAddress = row["Address"].ToString();
string strRefGroupName = row["RefGroupName"].ToString();
if (GroupBll.IsNameExist(strName))
{
continue;
}
GlareSysEfDbAndModels.ProjectInfo project = new GlareSysEfDbAndModels.ProjectInfo()
{
Address = strAddress,
CreateDt = DateTime.Now,
Id = 0,
IsDel = 0,
UpdateDt = DateTime.Now,
GroupId = userInfo.UserInfo.MgrGroupId,
ManagerName = strManager,
ManagerTel = strManagerTel,
OrgId = DataLoader.GetOrgIDByOrgName(strName),
ProjectName = strName
};
string strError;
ProjectBll.AddAProject(ref project, out strError);
}
}
public ActionResult Modify(GlareSysEfDbAndModels.ProjectInfo subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
ProjectInfo aSubject = db.ProjectInfo.Where(p => p.Id == subject.Id).FirstOrDefault();
aSubject.ProjectName = subject.ProjectName;
aSubject.ManagerName = subject.ManagerName;
aSubject.Address = subject.Address;
aSubject.ManagerTel = subject.ManagerTel;
aSubject.OrgId = subject.OrgId;
aSubject.GroupId = subject.GroupId;
aSubject.UpdateDt = DateTime.Now;
string strMsg = string.Empty;
bool b = ProjectBll.UpdateProejct(ref subject, out strMsg);
if (b)
{
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = subject,
Msg = strMsg,
Desc = strMsg
};
}
else
{
objResult = new ResultHelper()
{
Desc = strMsg,
Msg = strMsg,
Obj = null,
Ret = -1,
Status = false
};
}
//if (db.SaveChanges() > 0)
//{
// objResult = new ResultHelper()
// {
// Status = true,
// Ret = 0,
// Obj = subject,
// Msg = "Edit Success!",
// Desc = "Edit Success!"
// };
//}
//else
//{
// objResult = new ResultHelper()
// {
// Desc = "Edit Faile,please try again.",
// Msg = "Edit Faile,please try again.",
// Obj = null,
// Ret = -1,
// Status = false
// };
//}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}
public ActionResult Add(GlareSysEfDbAndModels.ProjectInfo subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
subject.UpdateDt = DateTime.Now;
subject.CreateDt = DateTime.Now;
subject.IsDel = 0;
subject.UpdateDt = DateTime.Now;
subject.CreateDt = DateTime.Now;
subject.IsDel = 0;
string strMsg = string.Empty;
bool b = ProjectBll.AddAProject(ref subject, out strMsg);
if (b)
{
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = subject,
Msg = strMsg,
Desc = strMsg
};
}
else
{
objResult = new ResultHelper()
{
Desc = strMsg,
Msg = strMsg,
Obj = null,
Ret = -1,
Status = false
};
}
//db.ProjectInfo.Add(subject);
//if (db.SaveChanges() > 0)
//{
// objResult = new ResultHelper()
// {
// Status = true,
// Ret = 0,
// Obj = subject,
// Msg = "Add Success!",
// Desc = "Add Success!"
// };
//}
//else
//{
// objResult = new ResultHelper()
// {
// Desc = "Add Faile,please try again.",
// Msg = "Add Faile,please try again.",
// Obj = null,
// Ret = -1,
// Status = false
// };
//}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}