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 strRefOrg = row["RefGroupName"].ToString();
if (GroupBll.IsNameExist(strName))
{
continue;
}
GlareSysEfDbAndModels.OrgInfo org = new GlareSysEfDbAndModels.OrgInfo()
{
Address = strAddress,
CreateDt = DateTime.Now,
Id = 0,
IsDel = 0,
ManageName = strManager,
ManageTel = strManagerTel,
Name = strName,
UpdateDt = DateTime.Now
};
string strError;
OrgBll.AddAOrg(ref org, out strError);
}
MemCfgInfo.MemDbMgr.Get().Load();
}
private void InsertNewOrg(DataTable dtOrg)
{
foreach (DataRow row in dtOrg.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();
if (OrgBll.IsNameExist(strName))
{
continue;
}
GlareSysEfDbAndModels.OrgInfo org = new GlareSysEfDbAndModels.OrgInfo()
{
Address = strAddress,
CreateDt = DateTime.Now,
Id = 0,
IsDel = 0,
ManageName = strManager,
ManageTel = strManagerTel,
Name = strName,
UpdateDt = DateTime.Now
};
}
}
public void Load()
{
CfgVersion ver = CfgVersionBll.GetFirstCfg();
if (ver != null)
{
_verInDb = ver.Version.Value;
}
lstOrgsByDb = OrgBll.GetAllOrgInfo();
lstGroupsByDb = GroupBll.GetAllGroupInfo();
lstProjectsByDb = ProjectBll.GetAllProject();
lstCardsByDb = CardWithCommDevBll.GetAllDevList();
MakeMemCard(_loadFlag);
MakeMemProject(_loadFlag);
MakeMemGroup(_loadFlag);
MakeMemOrg(_loadFlag);
MakeMemCommByClientSn(_loadFlag);
MakeCardRef();
MakeProjectRef();
MakeGroupRef();
MakeOrgRef();
lstOrgsByDb.Clear();
lstGroupsByDb.Clear();
lstProjectsByDb.Clear();
lstCardsByDb.Clear();
}
public string AddNewOrg(string strParams)
{
string strError;
RequestModelString reqinfo = ServerHlper.GetRequestModelString(System.Reflection.MethodBase.GetCurrentMethod().Name,
strParams, out strError);
if (reqinfo == null)
{
return(strError);
}
OrgInfo mod = JsonStrObjConver.JsonStr2Obj(reqinfo.Info, typeof(OrgInfo))
as OrgInfo;
if (mod == null)
{
return(ServerHlper.MakeInfoByStatus(false, ConstDefineWs.HttpParamError));
}
bool bResult = OrgBll.AddAOrg(ref mod, out strError);
if (!bResult)
{
return(ServerHlper.MakeInfoByStatus(false, ConstDefineWs.LoginNameOrPassword));
}
// 成功返回成功标志及新增加的ID
JsonResutlModelString result = new JsonResutlModelString()
{
ErrorDesc = "success",
Info = mod.Id.ToString(),
Status = true,
StatusInt = 1
};
return(JsonStrObjConver.Obj2JsonStr(result, typeof(JsonResutlModelString)));
}
public ActionResult Delete(string OrgIds)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
string[] Id = OrgIds.Split(',');
string strMsg = string.Empty;
for (int i = 0; i < Id.Length; i++)
{
OrgBll.DeleteAOrg(int.Parse(Id[i]), out strMsg);
}
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = OrgIds,
Msg = strMsg,
Desc = strMsg
};
//StringBuilder strSql = new StringBuilder();
//strSql.AppendFormat(@"UPDATE OrgInfo SET IsDel = 1 WHERE Id IN ({0})", OrgIds);
//if (db.Database.ExecuteSqlCommand(strSql.ToString()) > 0)
//{
// objResult = new ResultHelper()
// {
// Status = true,
// Ret = 0,
// Obj = OrgIds,
// Msg = "Delete Success!",
// Desc = "Delete Success!"
// };
//}
//else
//{
// objResult = new ResultHelper()
// {
// Desc = "Delete Faile,please try again.",
// Msg = "Delete 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 Modify(GlareSysEfDbAndModels.OrgInfo subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
OrgInfo aSubject = db.OrgInfo.Where(p => p.Id == subject.Id).FirstOrDefault();
aSubject.Name = subject.Name;
aSubject.ManageName = subject.ManageName;
aSubject.Address = subject.Address;
aSubject.ManageTel = subject.ManageTel;
aSubject.UpdateDt = DateTime.Now;
string strMsg = string.Empty;
bool b = OrgBll.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.OrgInfo subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
subject.UpdateDt = DateTime.Now;
subject.CreateDt = DateTime.Now;
subject.IsDel = 0;
string strMsg = string.Empty;
bool b = OrgBll.AddAOrg(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.OrgInfo.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));
}
