private void CheckFormula(Context ctx, ValidateContext validateContext, ExtendedDataEntity entity, BudgetFormulaService service)
{
string formula = Convert.ToString(entity["Express"]);
if (!service.ValidityFormula(formula))
{
string title = ResManager.LoadKDString("合法性校验", "003286000011212", SubSystemType.FIN, new object[0]);
string msg = ResManager.LoadKDString("公式设置不正确，请重新设置！", "003286000011305", SubSystemType.FIN, new object[0]);
CommonValidate.AddMsg(validateContext, entity, title, msg, "", ErrorLevel.Error);
}
}
public JsonResult updateCusField()
{
Message msg = new Message();
string DtoName = Request.Params["DtoName"];
string table = Request.Params["table"];
string strWhere = Request.Params["strWhere"];
string columnname = Request.Params["columnname"];
string columnvalue = Request.Params["columnvalue"];
if (columnname != "CustomerTelephone" && columnname != "CustomerEmail" && columnname != "CustomerLianxirenTel")
{
msg = CMSService.UpdateFieldOneByOne(DtoName, table, strWhere, columnname, columnvalue);
msg.MessageStatus = "true";
}
else
{
if (columnname == "CustomerTelephone" || columnname == "CustomerLianxirenTel")
{
if (CommonValidate.IsTelephone(columnvalue))
{
msg = CMSService.UpdateFieldOneByOne(DtoName, table, strWhere, columnname, columnvalue);
msg.MessageStatus = "true";
}
else
{
msg.MessageStatus = "false";
msg.MessageInfo = "手机格式不正确";
}
}
if (columnname == "CustomerEmail")
{
if (CommonValidate.IsEmail(columnvalue))
{
msg = CMSService.UpdateFieldOneByOne(DtoName, table, strWhere, columnname, columnvalue);
msg.MessageStatus = "true";
}
else
{
msg.MessageStatus = "false";
msg.MessageInfo = "邮箱格式不正确";
}
}
}
var result = msg;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult updateUserField()
{
Message msg = new Message();
string DtoName = Request.Params["DtoName"];
string table = Request.Params["table"];
string strWhere = Request.Params["strWhere"];
string columnname = Request.Params["columnname"];
string columnvalue = Request.Params["columnvalue"];
if (columnname != "UserTelephone" && columnname != "UserEmail")
{
msg = CMSService.UpdateFieldOneByOne(DtoName, table, strWhere, columnname, columnvalue);
msg.MessageStatus = "true";
}
else
{
if (columnname == "UserTelephone")
{
if (CommonValidate.IsTelephone(columnvalue))
{
DataTable dt = CMSService.SelectOne("User", "CMSUser", strWhere + " and UserTelephone='" + columnvalue + "'");
if (dt.Rows.Count > 0)
{
msg.MessageStatus = "false";
msg.MessageInfo = "此手机号已经被其他用户占用";
}
else
{
msg = CMSService.UpdateFieldOneByOne(DtoName, table, strWhere, columnname, columnvalue);
msg.MessageStatus = "true";
}
}
else
{
msg.MessageStatus = "false";
msg.MessageInfo = "手机格式不正确";
}
}
if (columnname == "UserEmail")
{
if (CommonValidate.IsEmail(columnvalue))
{
DataTable dt = CMSService.SelectOne("User", "CMSUser", strWhere + " and UserEmail='" + columnvalue + "'");
if (dt.Rows.Count > 0)
{
msg.MessageStatus = "false";
msg.MessageInfo = "此邮箱已经被其他用户占用";
}
else
{
msg = CMSService.UpdateFieldOneByOne(DtoName, table, strWhere, columnname, columnvalue);
msg.MessageStatus = "true";
}
}
else
{
msg.MessageStatus = "false";
msg.MessageInfo = "邮箱格式不正确";
}
}
}
var result = msg;
return(Json(result, JsonRequestBehavior.AllowGet));
}
