public JsonResult SetCAPUser()
{ //c5d80f0e-1fb3-424c-bc92-313101af25c4 135 6b06027b-bbf5-4a26-8949-f3ed6721faf3 77PRD
string OUId = "6b06027b-bbf5-4a26-8949-f3ed6721faf3";
var msg = "";
SyncResult syn = new SyncResult();
//SyncResult syn = new SyncResult();
string sql = @"select t.dealer_code DEALERCODE,
t.dealer_name DEALERNAME,
t.user_code USERCODE
,t.STATUS
from IN_WFS.V_DEALER_INFO t";
DataTable dt = new DataTable();
DistributorController dc = new DistributorController();
dt = dc.ExecuteDataTableSql("Wholesale", sql);
//dt = OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
var dealerCode = dt.Rows[i]["DEALERCODE"].ToString().Trim();
var dealerName = dt.Rows[i]["DEALERNAME"].ToString().Trim();
var userCode = dt.Rows[i]["USERCODE"].ToString().Trim();
var status = dt.Rows[i]["STATUS"].ToString().Trim();
var unitUser = new User();
unitUser.ParentID = OUId;
unitUser.Appellation = dealerCode;
unitUser.Code = userCode;
unitUser.Name = dealerName;
unitUser.ServiceState = UserServiceState.InService;
if (status == "Y")
{
unitUser.State = OThinker.Organization.State.Active;
}
else if (status == "N")
{
unitUser.State = OThinker.Organization.State.Inactive;
}
var aa = userCode.Substring(0, 2);
var bb = userCode.Substring(2, 2);
const string pattern = "^[0-9]*$";
Regex rx = new Regex(pattern);
bool isnum = rx.IsMatch(aa);
if (isnum)
{
if (aa.ToString() == "98")
{
unitUser.PostalCode = "内网";
}
else if (aa.ToString() == "80" || aa.ToString() == "61")
{
unitUser.PostalCode = "外网";
}
else
{
unitUser.PostalCode = "";
}
}
else
{
if (bb.ToString() == "98")
{
unitUser.PostalCode = "内网";
}
else if (bb.ToString() == "80" || bb.ToString() == "61")
{
unitUser.PostalCode = "外网";
}
else
{
unitUser.PostalCode = "";
}
}
string userObj = GetUserObjectID(userCode);
Unit u = OThinker.H3.Controllers.AppUtility.Engine.Organization.GetUnit(userObj);
User olduser = u == null ? null : (User)u;
if (olduser == null)
{
if (!AddUnit(unitUser, "CAP新增"))
{
syn.ErrMsg = "更新失败!请联系管理员查看日志";
syn.Success = false;
break;
}
}
else
{
olduser.Appellation = unitUser.Appellation;
olduser.Code = unitUser.Code;
olduser.Name = unitUser.Name;
olduser.State = unitUser.State;
olduser.PostalCode = unitUser.PostalCode;
if (!UpdateUnit(olduser, "CAP更新"))
{
syn.ErrMsg = "更新失败!请联系管理员查看日志";
syn.Success = false;
break;
}
}
}
OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write(DateTime.Now.ToString() + " 导入共计：" + AddCount + "人。\n" + " 更新共计：" + UpdCount + "人");
//OThinker.H3.Controllers.AppUtility.Engine.LogWriter.Write(DateTime.Now.ToString() + " 更新共计：" + UpdCount + "人");
OThinker.H3.Controllers.AppUtility.Engine.Organization.Reload();
syn.ErrMsg = "更新成功";
syn.Success = true;
return(Json(new { Success = syn.Success, Message = syn.ErrMsg }, JsonRequestBehavior.AllowGet));
}
