private void LoginOperation()
{
UserDomain userDomain = new UserDomain(1, Common.Enums.LanguagesEnum.Arabic);
User userEntity = new User();
userEntity = userDomain.CheckUserLogin(txt_Username.Text, txt_Password.Password);
if (userDomain.ActionState.Status != Common.Enums.ActionStatusEnum.NoError)
{
SetError(0, userDomain.ActionState.Result);
}
else
{
UISecurity.UserEntity = userEntity;
AppWindow appWindow = new AppWindow();
appWindow.Show();
((Window)((Grid)this.Parent).Parent).Close();
}
}
/// <summary>
/// Construtor referente ao controller do Módulo Usuário
/// </summary>
public UserController(SysQueirozContext context)
{
userDomain = new UserDomain(context);
profileDomain = new ProfileDomain(context);
menuDomain = new MenuDomain(context);
}
public PetController(PetDomain petDomain, UserDomain userDomain)
{
this.petDomain = petDomain;
this.userDomain = userDomain;
}
public void SignUp(UserDomain user)
{
_contexto.User.Add(user);
_contexto.SaveChanges();
}
public GameHub(MultiplayerGameService gameManager, UserDomain userDomain) : base(gameManager, userDomain)
{
}
internal void UpdateCommentBook(IEnumerable <string> comments)
{
UserDomain.Put(UserSetting.TxCommentBook, comments);
}
public void GetAlldeviceActions_Success()
{
UserDomain user = GetValidUserDomain();
_deviceActionManipulation.GetAllActions(user.TenantId);
}
public IHttpActionResult Get()
{
return(Ok(UserDomain.GetUser()));
}
public IHttpActionResult Get(int id)
{
var user = UserDomain.GetBy(id);
return(Ok(user));
}
public ICollection <RuleDomain> GetAllRules(UserDomain user, IList <FilterCriteria> filters, Paging paging)
{
return(_ruleRepository.GetAllRules(user, filters, paging));
}
public IHttpActionResult Delete(User user)
{
var newUser = Uow.Repository <User>().FirstOrDefault(c => c.UserId == user.UserId);
return(Ok(UserDomain.DeleteUser(newUser)));
}
public void GetAllInactiveDevices_Success()
{
UserDomain user = GetValidUserDomain();
_deviceManipulation.GetAllInactiveDevices(user.TenantId);
}
private void LoadData(UserDomain userModel)
{
AddOrUpdateBaseInfo(userModel);
ViewBag.RoleList = Smart.Instance.RoleBizService.GetUser_RoleList(userModel.Id).ToList();
}
public static ResponseLoginUsuario Login(RequestLogin request)
{
var response = new ResponseLoginUsuario();
try
{
if (string.IsNullOrEmpty(request.Clave) || string.IsNullOrEmpty(request.CodigoUsuario))
{
throw new InvalidOperationException("El usuario y clave son obligatorios.");
}
if (string.IsNullOrEmpty(request.AcronimoAplicacion))
{
throw new InvalidOperationException("El acrónimo es obligatorio.");
}
// Desencriptamos el mensaje recibido.
var cryptocon = new SimpleInteroperableEncryption();
request.Clave = cryptocon.Decrypt(request.Clave);
//Comprobamos que el Nombre de Usuario contiene un Dominio
var infoUser = new UserDomain {
Usuario = request.CodigoUsuario, Dominio = request.Dominio
};
//Guardamos en el GlobalContext el valor que se reciba del Acrónimo
Csla.ApplicationContext.GlobalContext["Acronimo"] = request.AcronimoAplicacion;
if (string.IsNullOrEmpty(request.Dominio))
{
throw new InvalidOperationException("El dominio es obligatorio.");
}
var result = false;
//Comprobamos primero el tipo de Usuario
if (GRPrincipal.Load(infoUser.Usuario, infoUser.Dominio))
{
InfoUsuario.Initialize();
if (InfoUsuario.Instancia.Tipo) // Si es interno
{
result = GRPrincipal.Login(infoUser.Usuario, request.Clave, request.Dominio);
}
else // Si es externo
{
result = GRPrincipal.Login(infoUser.Usuario, GRCrypto.Encriptar(request.Clave));
}
}
else
{
throw new InvalidOperationException("El usuario no está inscrito para este Sistema");
}
if (!result)
{
throw new SecurityException("El usuario o clave no son válidos!");
}
response.Resultado.Success = result;
response.IdPerfilUsuario = InfoUsuario.Instancia.IdPerfilUsuario;
}
catch (DataPortalException ex)
{
response.Resultado.Message = ex.BusinessException.Message;
}
catch (Exception ex)
{
var msg = ex.Message;
if (ex.InnerException != null)
{
msg = ex.InnerException.Message;
}
response.Resultado.Message = msg;
}
return(response);
}
internal void UpdateAccountBook(IEnumerable <string> accountBook)
{
UserDomain.Put(UserSetting.AccountBook, accountBook);
}
/// <summary>
/// Регистрирует нового пользователя.
/// </summary>
/// <param name="unit">Юнит регистрации.</param>
/// <returns>Результат регистрации.</returns>
public RegistrationResult Register(RegistrationUnit unit)
{
_logger.InfoFormat("Начало регистрации пользователя {0}: {1}", unit.Login, unit.ClientIdentifier);
var result = new RegistrationResult();
try
{
var domain = new UserDomain();
domain.IsActive = false;
domain.EventDate = DateTime.UtcNow;
domain.LegalName = unit.LegalName;
domain.PasswordHash = BcryptHash(unit.Password);
domain.RegistredEmail = unit.Email;
domain.Trademark = unit.Trademark;
domain.Address = unit.Address;
domain.UserLogin = unit.Login;
RemontinkaServer.Instance.DataStore.SaveUserDomain(domain);
_logger.InfoFormat("Завели новый домен с id {0} для пользователя {1}", domain.UserDomainID, unit.Login);
var user = new User();
user.Email = unit.Email;
user.FirstName = unit.FirstName;
user.LastName = unit.LastName;
user.LoginName = unit.Login;
user.PasswordHash = string.Empty;
user.MiddleName = string.Empty;
user.Phone = string.Empty;
user.ProjectRoleID = ProjectRoleSet.Admin.ProjectRoleID;
user.UserDomainID = domain.UserDomainID;
try
{
RemontinkaServer.Instance.DataStore.SaveUser(user);
result.Success = true;
var body = string.Format(RegistrationMessageBodyFormat, user.FirstName,
string.Format(RegistrationActivateUrlFormat, domain.UserDomainID));
RemontinkaServer.Instance.MailingService.Send(unit.Email, RegistrationMessageTitleFormat, body);
_logger.InfoFormat("Пользователь успешно зарегистрирован {0}", unit.Login);
}
catch (Exception ex)
{
result.Description = "Ошибка регистрации пользователя домена";
var innerException = string.Empty;
if (ex.InnerException != null)
{
innerException = ex.InnerException.Message;
}
_logger.ErrorFormat("Во время сохранения пользователя {0} для домена {1}, произошла ошибка, откатываем домен: {2}, {3} {4} {5}",
unit.Login, domain.UserDomainID, ex.Message, innerException, ex.GetType(), ex.StackTrace);
RemontinkaServer.Instance.DataStore.DeleteUserDomain(domain.UserDomainID);
}
}
catch (Exception ex)
{
result.Description = "Ошибка";
var innerException = string.Empty;
if (ex.InnerException != null)
{
innerException = ex.InnerException.Message;
}
_logger.ErrorFormat("Во время регистрации пользователя {0}, произошла ошибка {1}, {2} {3} {4}",
unit.Login, ex.Message, innerException, ex.GetType(), ex.StackTrace);
}
return(result);
}
internal IEnumerable <string> LoadCommentBook()
{
return(UserDomain.Get <IEnumerable <string> >(UserSetting.TxCommentBook) ?? new List <string>());
}
public void SignUp(UserDomain user)
{
throw new NotImplementedException();
}
public UserController()
{
this.UserDomain = new UserDomain();
}
public void UpdateToken(UserDomain user)
{
throw new NotImplementedException();
}
public UserController(UserDomain domain)
{
this.domain = domain;
}
//public string CREATE_TIME;
public WhereBuilder ParseSQL()
{
UserDomain userDomain = (UserDomain)WebCaching.CurrentUserDomain;
//var sql = new StringBuilder();
//sql.AppendLine($@" SELECT * from (
// SELECT t1.*,t2.STATUS as APPROVE_STATUS,t2.CONTRACT_APPROVER_ID
// FROM dbo.CAS_CONTRACT t1
// JOIN dbo.CAS_CONTRACT_APPROVER t2 ON t1.CONTRACT_ID = t2.CONTRACT_ID
// WHERE 1 = 1 AND t2.APPROVER_TYPE != 1 AND t2.STATUS IN (2,4) AND t1.STATUS IN (2,8)
// AND (t2.APPROVER_ID = '{userDomain.CasUserEntity.UserId}'
// OR t2.APPROVER_ID IN (SELECT t3.AUTHORIZED_USER_ID FROM dbo.CAS_PROXY_APPROVAL t3
// WHERE t3.AGENT_USER_ID = '{userDomain.CasUserEntity.UserId}'
// AND GETDATE() BETWEEN t3.BEGIN_TIME AND t3.END_TIME))
// UNION ALL
// SELECT t1.*,t2.STATUS as APPROVE_STATUS,t2.CONTRACT_APPROVER_ID
// FROM dbo.CAS_CONTRACT t1
// JOIN dbo.CAS_CONTRACT_APPROVER t2 ON t1.CONTRACT_ID = t2.CONTRACT_ID
// JOIN dbo.CAS_DEPARTMENT t4 ON t4.DEPT_ID = t2.APPROVER_ID
// JOIN dbo.CAS_DEPT_USER t5 ON t5.DEPT_ID = t4.DEPT_ID
// WHERE 1 = 1 AND t2.APPROVER_TYPE != 1 AND t2.STATUS IN (2,4) AND t1.STATUS IN (2,8)
// AND (t5.USER_ID = '{userDomain.CasUserEntity.UserId}'
// OR t5.USER_ID IN (SELECT t3.AUTHORIZED_USER_ID FROM dbo.CAS_PROXY_APPROVAL t3
// WHERE t3.AGENT_USER_ID = '{userDomain.CasUserEntity.UserId}'
// AND GETDATE() BETWEEN t3.BEGIN_TIME AND t3.END_TIME))) temp ");
string sql = $@"SELECT * from (
SELECT t1.*,t2.STATUS as APPROVE_STATUS,t2.APPROVER_TYPE,t2.CONTRACT_APPROVER_ID,t6.STEP
FROM dbo.CAS_CONTRACT t1
JOIN dbo.CAS_CONTRACT_APPROVER t2 ON t1.CONTRACT_ID = t2.CONTRACT_ID
LEFT JOIN dbo.CAS_CONTRACT_APPROVAL_STEP t6 ON t2.CONTRACT_APPROVAL_STEP_ID=t6.CONTRACT_APPROVAL_STEP_ID
WHERE 1 = 1 AND t2.APPROVER_TYPE != 1 AND t2.STATUS IN (2,4) AND t1.STATUS IN (2,8)
AND (t2.APPROVER_ID = '{userDomain.CasUserEntity.UserId}'
OR t2.APPROVER_ID IN (SELECT t3.AUTHORIZED_USER_ID FROM dbo.CAS_PROXY_APPROVAL t3
WHERE t3.AGENT_USER_ID = '{userDomain.CasUserEntity.UserId}'
AND GETDATE() BETWEEN t3.BEGIN_TIME AND t3.END_TIME AND t3.IS_DELETED=0))
UNION ALL
SELECT t1.*,t2.STATUS as APPROVE_STATUS,t2.APPROVER_TYPE,t2.CONTRACT_APPROVER_ID,t6.STEP
FROM dbo.CAS_CONTRACT t1
JOIN dbo.CAS_CONTRACT_APPROVER t2 ON t1.CONTRACT_ID = t2.CONTRACT_ID
JOIN dbo.CAS_DEPARTMENT t4 ON t4.DEPT_ID = t2.APPROVER_ID
JOIN dbo.CAS_DEPT_USER t5 ON t5.DEPT_ID = t4.DEPT_ID
LEFT JOIN dbo.CAS_CONTRACT_APPROVAL_STEP t6 ON t2.CONTRACT_APPROVAL_STEP_ID=t6.CONTRACT_APPROVAL_STEP_ID
WHERE 1 = 1 AND t2.APPROVER_TYPE != 1 AND t2.STATUS IN (2,4) AND t1.STATUS IN (2,8)
AND (t5.USER_ID = '{userDomain.CasUserEntity.UserId}'
OR t5.USER_ID IN (SELECT t3.AUTHORIZED_USER_ID FROM dbo.CAS_PROXY_APPROVAL t3
WHERE t3.AGENT_USER_ID = '{userDomain.CasUserEntity.UserId}'
AND GETDATE() BETWEEN t3.BEGIN_TIME AND t3.END_TIME AND t3.IS_DELETED=0))
UNION ALL
SELECT t1.*,t2.STATUS as APPROVE_STATUS,t2.APPROVER_TYPE,t2.CONTRACT_APPROVER_ID,t6.STEP FROM dbo.CAS_CONTRACT t1
JOIN dbo.CAS_CONTRACT_APPROVER t2 ON t1.CONTRACT_ID = t2.CONTRACT_ID
LEFT JOIN dbo.CAS_CONTRACT_APPROVAL_STEP t6 ON t2.CONTRACT_APPROVAL_STEP_ID=t6.CONTRACT_APPROVAL_STEP_ID
WHERE 1 = 1 AND t2.APPROVER_TYPE = 1 AND t2.STATUS = 2 AND t1.STATUS IN (2,8)
AND t2.APPROVER_ID = '{userDomain.CasUserEntity.UserId}') temp" ;
if (CONTRACT_NAME != "")
{
var para = $@" 1 = 1 AND t1.CONTRACT_NAME LIKE N'%{CONTRACT_NAME}%' ";
sql = sql.Replace("1 = 1", para);
}
if (CONTRACT_SERIAL_NO != "")
{
var para = $@" 1 = 1 AND t1.CONTRACT_SERIAL_NO LIKE N'%{CONTRACT_SERIAL_NO}%' ";
sql = sql.Replace("1 = 1", para);
}
if (CONTRACT_TYPE_NAME != "")
{
var para = $@" 1 = 1 AND t1.CONTRACT_TYPE_NAME = '{CONTRACT_TYPE_NAME}' ";
sql = sql.Replace("1 = 1", para);
}
if (FERRERO_ENTITY != "")
{
var para = $@" 1 = 1 AND t1.FERRERO_ENTITY = '{FERRERO_ENTITY}' ";
sql = sql.Replace("1 = 1", para);
}
if (CONTRACT_INITIATOR != "")
{
var para = $@" 1 = 1 AND t1.CONTRACT_INITIATOR LIKE N'%{CONTRACT_INITIATOR}%' ";
sql = sql.Replace("1 = 1", para);
}
//if (CREATE_TIME!="")
//{
// var star = CREATE_TIME + " 00:00:00";
// var end = CREATE_TIME + " 23:59:59";
// var para = $@" 1 = 1 AND t1.CREATE_TIME BETWEEN '{star}' AND '{end}' ";
// sql = sql.Replace("1 = 1", para);
//}
var wb = new WhereBuilder(sql.ToString());
return(wb);
}
public void UpdateToken(UserDomain user)
{
_contexto.User.Update(user);
_contexto.SaveChanges();
}
// **************************************
// URL: /Account/LogOn
// **************************************
public ActionResult Login(CasUserEntity userEntity, string UserAccount, string password, string currentLanguage, string returnUrl, string paras, string viewName = "LoginV3")
{
string strError = "";
string ssologin = ComixSDK.EDI.Utils.ConfigHelper.GetConfigString("SSOLogin");
string SSOUserId = "";
string AUTHUserId = "";
string SSOToken = "";
object bindModel = null;
if (!string.IsNullOrEmpty(paras))
{
//SortedDictionary<string, string> parasDic = new SortedDictionary<string, string>();
//parasDic.Add("SSOUserId", "");
//parasDic.Add("AUTHUserId", Guid.NewGuid().ToString().Replace("-", "").ToLower());
//parasDic.Add("SSOToken", "");
//string newparas = JSONHelper.ToJson(parasDic);
//newparas = ComixSDK.EDI.Utils.EncryptionService.EncryptDES(newparas, eContract.Common.ConfigHelper.GetSetString("EncryptionKey"));
//paras = newparas;
paras = ComixSDK.EDI.Utils.EncryptionService.DecryptDES(paras, eContract.Common.ConfigHelper.GetSetString("EncryptionKey"));
SortedDictionary <string, object> sd = ComixSDK.EDI.Utils.JSONHelper.FromJson <SortedDictionary <string, object> >(paras);
SSOUserId = sd["SSOUserId"] == null ? "" : sd["SSOUserId"].ToString();
bindModel = sd["BindModel"];
SSOToken = sd["SSOToken"] == null ? "" : sd["SSOToken"].ToString();
}
ViewBag.Paras = paras;
ViewBag.ReturnUrl = returnUrl;
if (IsPost)
{
//参数解密
//SSOUserId = ComixSDK.EDI.Utils.EncryptionService.DecryptDES(SSOUserId, eContract.Common.ConfigHelper.GetSetString("EncryptionKey"));
//AUTHUserId = ComixSDK.EDI.Utils.EncryptionService.DecryptDES(AUTHUserId, eContract.Common.ConfigHelper.GetSetString("EncryptionKey"));
if (IsPost || !string.IsNullOrEmpty(SSOUserId))
{
WebCaching.UserCaching = null;
UserDomain userDomain = null;
if (!string.IsNullOrEmpty(SSOUserId)) //获取第三方登录用户
{
userEntity = SystemService.UserService.GetUserEntity(SSOUserId);
if (userEntity == null)
{
return(View(viewName, userEntity));
}
userDomain = SystemService.UserService.GetUserDomainByUserAccount("MDM", userEntity.UserAccount);
}
else
{
userDomain = SystemService.UserService.GetUserDomainByUserAccount("MDM", userEntity.UserAccount);
}
if (userDomain == null || Encryption.Decrypt(userDomain.CasUserEntity.Password) != password)
{
ViewBag.strError = "您输入的账号或密码错误,请重新输入";
//strError = "您输入的账号或密码错误,请重新输入";
//return Json(AjaxResult.Error(strError));
return(View(viewName, userEntity));
}
//if (userDomain.CasUserEntity.IsDelete == 1)
//{
// strError = "该用户已被删除";
// return Json(AjaxResult.Error(strError));
//}
string CacheKey = "User_" + UserId;
CacheHelper.Instance.Remove(CacheKey);
WebCaching.UserId = userDomain.CasUserEntity.UserId;
WebCaching.UserAccount = userDomain.CasUserEntity.UserAccount;
WebCaching.IsAdmin = userDomain.CasUserEntity.IsAdmin.ToString();
WebCaching.SystemName = "MDM";
userDomain.MenuDataItems = SystemService.FunctionRoleService.GetMenuDataItemByUserId("MDM", WebCaching.UserId);
this.CurrentUser = userDomain;
ComixSDK.EDI.Utils.CookieHelper.AddCookie(LANG_COOKIE_ID, currentLanguage, DateTime.Now.AddYears(1));
WebCaching.CurrentLanguage = currentLanguage;
FormsAuthentication.SetAuthCookie(userDomain.CasUserEntity.UserAccount, false);
userEntity = userDomain.CasUserEntity;
BusinessRoleBLL userroleBll = new BusinessRoleBLL();
List <SecUserRoleEntity> listUserRoles = userroleBll.GetBusinessRoleUserDomainByUserid(userDomain.CasUserEntity.UserId);
//普通员工添加默认权限
if (listUserRoles == null || listUserRoles.Count <= 0)
{
listUserRoles = userroleBll.GetBusinessRoleUserDomainByRoleId("cd3c9135-4446-45c5-b768-550abac4368d");
//strError = "您输入的账号没有权限,请重新输入";
//if (!IsAjax)
//{
// return View(viewName, userEntity);
//}
}
if (!IsAjax)
{
return(Redirect("~/home"));
}
//strError = GetResource(strError);
ViewBag.strError = strError;
userEntity.Password = password;
if (IsAjax)
{
if (string.IsNullOrEmpty(strError))
{
return(Json(AjaxResult.Success()));
}
return(Json(AjaxResult.Error(strError)));
}
}
}
return(View(viewName, userEntity));
}
public BaseGameHub(MultiplayerGameService gameManager, UserDomain userDomain)
{
this.GameManager = gameManager;
this.UserDomain = userDomain;
}
public TransactionComment Get(string txHash, int vout)
{
var key = GetKey(UserTables.TxComment, $"{txHash}_{vout}");
return(UserDomain.Get <TransactionComment>(key));
}
public JqGrid ForGrid(JqGrid grid)
{
UserDomain userDomain = (UserDomain)WebCaching.CurrentUserDomain;
DataTable dataTable = new DataTable();
dataTable.Columns.Add("FieldExplain", typeof(String));
dataTable.Columns.Add("ViewShow", typeof(String));
dataTable.Columns.Add("Content", typeof(String));
dataTable.Columns.Add("IsTemplate", typeof(String));
dataTable.Columns.Add("Explain", typeof(String));
DataRow dr1 = dataTable.NewRow();
dr1["FieldExplain"] = "合同名称";
dr1["ViewShow"] = "Contract Name*";
dr1["Content"] = "字符，支持英文中文数字";
dr1["IsTemplate"] = "false";
dr1["Explain"] = "必填";
dataTable.Rows.Add(dr1);
DataRow dr2 = dataTable.NewRow();
dr2["FieldExplain"] = "本次合同附件";
dr2["ViewShow"] = "Contract to be reviewed*";
dr2["Content"] = "必填";
dr2["IsTemplate"] = "false";
dr2["Explain"] = "上传至少一个附件，支持多个附件，格式只能为PDF格式";
dataTable.Rows.Add(dr2);
DataRow dr3 = dataTable.NewRow();
dr3["FieldExplain"] = "甲方";
dr3["ViewShow"] = "Ferrero Entity*";
dr3["Content"] = "必填";
dr3["IsTemplate"] = "common";
dr3["Explain"] = "系统自动将FTS 或FFH作为合同一方[注1]下拉菜单";
dataTable.Rows.Add(dr3);
DataRow dr4 = dataTable.NewRow();
dr4["FieldExplain"] = "乙方（英文）";
dr4["ViewShow"] = "Counterparty (EN)*";
dr4["Content"] = "必填";
dr4["IsTemplate"] = "false";
dr4["Explain"] = "相对方，可填选多方，英文字符、数字";
dataTable.Rows.Add(dr4);
DataRow dr5 = dataTable.NewRow();
dr5["FieldExplain"] = "乙方（中文）";
dr5["ViewShow"] = "Counterparty (CH)";
dr5["Content"] = "非必填";
dr5["IsTemplate"] = "false";
dr5["Explain"] = "相对方的中文名称";
dataTable.Rows.Add(dr5);
DataRow dr6 = dataTable.NewRow();
dr6["FieldExplain"] = "合同经办部门";
dr6["ViewShow"] = "Contract Owner";
dr6["Content"] = "系统自动生成";
dr6["IsTemplate"] = "false";
dr6["Explain"] = "申请人所在部门";
dataTable.Rows.Add(dr6);
DataRow dr7 = dataTable.NewRow();
dr7["FieldExplain"] = "申请人";
dr7["ViewShow"] = "Contract Initiator";
dr7["Content"] = "字符，支持英文中文数字";
dr7["IsTemplate"] = "false";
dr7["Explain"] = "必填";
dataTable.Rows.Add(dr7);
DataRow dr8 = dataTable.NewRow();
dr8["FieldExplain"] = "合同名称";
dr8["ViewShow"] = "Contract Name*";
dr8["Content"] = "系统自动生成";
dr8["IsTemplate"] = "false";
dr8["Explain"] = "即申请人";
dataTable.Rows.Add(dr8);
DataRow dr9 = dataTable.NewRow();
dr9["FieldExplain"] = "申请日期";
dr9["ViewShow"] = "Date of Application";
dr9["Content"] = "系统自动生成";
dr9["IsTemplate"] = "common";
dr9["Explain"] = "提交当日";
dataTable.Rows.Add(dr9);
DataRow dr10 = dataTable.NewRow();
dr10["FieldExplain"] = "生效日期";
dr10["ViewShow"] = "Effective Date*";
dr10["Content"] = "必填";
dr10["IsTemplate"] = "false";
dr10["Explain"] = "日期格式";
dataTable.Rows.Add(dr10);
DataRow dr11 = dataTable.NewRow();
dr11["FieldExplain"] = "结束日期";
dr11["ViewShow"] = "Expiration Date*";
dr11["Content"] = "必填";
dr11["IsTemplate"] = "false";
dr11["Explain"] = "日期格式,若合同期限超过365天，自动弹出长期合同政策提醒，点击确定可关闭";
dataTable.Rows.Add(dr11);
DataRow dr12 = dataTable.NewRow();
dr12["FieldExplain"] = "框架合同";
dr12["ViewShow"] = "Master Agreement or not*";
dr12["Content"] = "Yes/No";
dr12["IsTemplate"] = "false";
dr12["Explain"] = "必填，二选一";
dataTable.Rows.Add(dr12);
DataRow dr14 = dataTable.NewRow();
dr14["FieldExplain"] = "币种";
dr14["ViewShow"] = "Currency*";
dr14["Content"] = "必填";
dr14["IsTemplate"] = "false";
dr14["Explain"] = "下拉菜单（所有币种+其他）";
dataTable.Rows.Add(dr14);
DataRow dr15 = dataTable.NewRow();
dr15["FieldExplain"] = "固定资产";
dr15["ViewShow"] = "CAPEX or not*";
dr15["Content"] = "Yes/No";
dr15["IsTemplate"] = "false";
dr15["Explain"] = "必填，二选一";
dataTable.Rows.Add(dr15);
DataRow dr16 = dataTable.NewRow();
dr16["FieldExplain"] = "补充合同";
dr16["ViewShow"] = "Supplementary or not*";
dr16["Content"] = "Yes/No";
dr16["IsTemplate"] = "false";
dr16["Explain"] = "必填，二选一，下拉菜单";
dataTable.Rows.Add(dr16);
DataRow dr17 = dataTable.NewRow();
dr17["FieldExplain"] = "补充合同附件";
dr17["ViewShow"] = "Reference Contract*";
dr17["Content"] = "";
dr17["IsTemplate"] = "false";
dr17["Explain"] = "若为补充协议，则必填，二选一，如合同已在系统内，可浏览添加附件；如合同不在系统中，则需要上传附件";
dataTable.Rows.Add(dr17);
DataRow dr18 = dataTable.NewRow();
dr18["FieldExplain"] = "预付金额";
dr18["ViewShow"] = "Prepayment amount";
dr18["Content"] = "非必填";
dr18["IsTemplate"] = "false";
dr18["Explain"] = "金额";
dataTable.Rows.Add(dr18);
DataRow dr19 = dataTable.NewRow();
dr19["FieldExplain"] = "合同说明";
dr19["ViewShow"] = "Contract key points*";
dr19["Content"] = "必填";
dr19["IsTemplate"] = "false";
dr19["Explain"] = "字符，只支持英文数字";
dataTable.Rows.Add(dr19);
DataRow dr20 = dataTable.NewRow();
dr20["FieldExplain"] = "预付百分比";
dr20["ViewShow"] = "Prepayment percentage";
dr20["Content"] = "非必填";
dr20["IsTemplate"] = "false";
dr20["Explain"] = "百分比";
dataTable.Rows.Add(dr20);
DataRow dr21 = dataTable.NewRow();
dr21["FieldExplain"] = "预算类型";
dr21["ViewShow"] = "Budget type*";
dr21["Content"] = "Overheads/Non-overheads/Industrial/Other";
dr21["IsTemplate"] = "false";
dr21["Explain"] = "下拉菜单";
dataTable.Rows.Add(dr21);
DataRow dr22 = dataTable.NewRow();
dr22["FieldExplain"] = "模板编号";
dr22["ViewShow"] = "Template No.*";
dr22["Content"] = "必填";
dr22["IsTemplate"] = "true";
dr22["Explain"] = "字符，支持英文数字";
dataTable.Rows.Add(dr22);
DataRow dr23 = dataTable.NewRow();
dr23["FieldExplain"] = "模板名称";
dr23["ViewShow"] = "Template Name*";
dr23["Content"] = "必填";
dr23["IsTemplate"] = "true";
dr23["Explain"] = "字符，支持英文数字";
dataTable.Rows.Add(dr23);
DataRow dr24 = dataTable.NewRow();
dr24["FieldExplain"] = "模板所属部门";
dr24["ViewShow"] = "Template Owner";
dr24["Content"] = "系统自动生成";
dr24["IsTemplate"] = "true";
dr24["Explain"] = "申请人所在的部门";
dataTable.Rows.Add(dr24);
DataRow dr25 = dataTable.NewRow();
dr25["FieldExplain"] = "模板申请人";
dr25["ViewShow"] = "Template Initiator";
dr25["Content"] = "系统自动生成";
dr25["IsTemplate"] = "true";
dr25["Explain"] = "即申请人";
dataTable.Rows.Add(dr25);
DataRow dr26 = dataTable.NewRow();
dr26["FieldExplain"] = "适用范围";
dr26["ViewShow"] = "Scope of Application*";
dr26["Content"] = "必填";
dr26["IsTemplate"] = "true";
dr26["Explain"] = "字符，支持英文数字";
dataTable.Rows.Add(dr26);
DataRow dr27 = dataTable.NewRow();
//dr27["FieldExplain"] = "审批完成时间";
//dr27["ViewShow"] = "Online review completion date";
//dr27["Content"] = "系统自动生成";
//dr27["IsTemplate"] = "common";
//dr27["Explain"] = "日期格式";
dr27["FieldExplain"] = "合同金额";
dr27["ViewShow"] = "Contract Price*";
dr27["Content"] = "必填";
dr27["IsTemplate"] = "false";
dr27["Explain"] = "Master Agreement 填预估金额，one-off agreement填固定金额，或自定义;For master agreement, please insert estimated price";
dataTable.Rows.Add(dr27);
var queryWord = grid.QueryField.ContainsKey("FieldExplain") ? grid.QueryField["FieldExplain"].ToString() : "";
var queryTep = grid.QueryField.ContainsKey("IsTemplate")? grid.QueryField["IsTemplate"].ToString() : "";
string query = $" 1=1 ";
if (!string.IsNullOrWhiteSpace(queryWord))
{
query = query + $" AND ( FieldExplain LIKE '%{queryWord}%' OR ViewShow LIKE '%{queryWord}%' )";//模糊查询
}
if (!string.IsNullOrWhiteSpace(queryTep))
{
var isTep = queryTep == "1" ? "true" : "false";
query = query + $" AND IsTemplate = '{isTep}' OR IsTemplate='common' ";
}
DataTable dtNew = new DataTable();
if (!string.IsNullOrWhiteSpace(queryWord) || !string.IsNullOrWhiteSpace(queryTep))
{
DataRow[] drArr = dataTable.Select(query);
dtNew = dataTable.Clone();
for (int i = 0; i < drArr.Length; i++)
{
dtNew.ImportRow(drArr[i]);
}
DataTable dt = dtNew;
grid.DataBind(dt, dt.Rows.Count);
}
else
{
DataTable dt = dataTable;
grid.DataBind(dt, dt.Rows.Count);
}
return(grid);
}
public IEnumerable <TransactionComment> SelectAll()
{
var keys = CommentBook.Select(x => GetKey(UserSetting.AccountBook, x));
return(UserDomain.Get <TransactionComment>(keys));
}
private void Update()
{
UserDomain.Put(UserSetting.PaymentRequestBook, paymentBook);
}
public IEnumerable <TransactionComment> SelectByTransactionHash(string txid)
{
var keys = CommentBook.Where(x => x.Contains(txid)).Select(x => GetKey(UserSetting.AccountBook, x));
return(UserDomain.Get <TransactionComment>(keys));
}
public UserController(UserDomain userDomain)
{
_userDomain = userDomain;
}
public void Update(UserDomain user)
{
_context.Users.Update(user);
}
