public string getSign(getCodeByPhoneEntity pEntity)
{
string sql = @"select unit_name from T_unit where TYPE_ID='2F35F85CF7FF4DF087188A7FB05DED1D' and Customer_ID='{0}';";
sql = string.Format(sql, pEntity.common.customerId);
return(this.SQLHelper.ExecuteScalar(sql).ToString());
}
public int getCodeByPhone(getCodeByPhoneEntity pEntity)
{
string sql = @"
update RegisterValidationCode set IsValidated=1,LastUpdateTime=getdate() where Mobile='{0}' and IsValidated=0;
insert RegisterValidationCode(Mobile,Code,IsValidated,IsDelete,CreateBy)
values('{0}','{1}',0,0,1);";
sql = string.Format(sql, pEntity.special.Phone, pEntity.special.Code, pEntity.common.customerId);
return(this.SQLHelper.ExecuteNonQuery(sql));
}
