/// <summary>
///
/// </summary>
/// <param name="httpContext"></param>
/// <param name="pkId"></param>
/// <param name="customerCode"></param>
public void OnBegin(HttpContext httpContext, string pkId, string customerCode, Dictionary <string, object> dicParams = null)
{
/*
* 1.需要验证联系方式数据的唯一性，并返回个性的提示
*/
var phone = httpContext.Request["TB_Customer_Contact"].SafeConvert().ToStr();
if (!phone.StrValidatorHelper().StrIsNullOrEmpty())
{
var ado = new QWF.CRM.ADO.CRMDatabase();
var db = ado.GetDatabase();
string sql = string.Format(@"
select a.CustomerName,b.Realname,a.Contact
from TB_Customer a
inner join t_qwf_user b on a.CreateUser = b.UserCode
where a.Contact = @Contact and a.Deleted = 0 and a.CustomerCode != @CustomerCode
", phone);
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "@Contact", DbType.String, phone);
db.AddInParameter(cmd, "@CustomerCode", DbType.String, customerCode);
var dt = db.ExecuteDataSet(cmd).Tables[0];
if (dt.Rows.Count > 0)
{
throw new UIValidateException("联系方式【{0}】已经存在，客户名称为【{1}】，数据的拥有者为【{2}】",
dt.Rows[0]["Contact"],
dt.Rows[0]["CustomerName"],
dt.Rows[0]["Realname"]);
}
}
}
public ADO_Helper()
{
this.ado = new CRMDatabase();
}
