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)); }